What are the required Oracle Database license, components, options, and initial parameters for a NuGenesis database? - WKB89938

ENVIRONMENT

• NuGenesis 9
• NuGenesis 8
• The customer has installed, or will install, the NuGenesis database instance(s) under the terms of their own licensing agreement with Oracle, rather than under the terms of the Waters-supplied Oracle license

ANSWER

License model: Oracle Database Enterprise Edition.  The "Standard Edition 2" license model is not recommended for use with production NuGenesis database due to it's restriction to 2 CPU cores. SE2 also disallows the Partitioning and Advanced Compression options.

NuGenesis requires the following Oracle Database components:

• Oracle Database Catalog Views
• Oracle Database Packages and Types
• Oracle Text: this component is required for searching the contents of records in NuGenesis SDMS and LMS
• Oracle Workspace Manager
• Oracle XML database

NuGenesis requires the following database options in the default installation process:

• Partitioning: in the default installation process, three tables in SDMS are partitioned by default
  • Which tables in the NuGenesis schemas have partitions?
• Advanced compression: several SDMS tables use advanced compression in the default installation
  • Which objects in the NuGenesis schemas use Oracle Advanced Compression?
• Note: installation procedures are available for NuGenesis 9.x on Linux which do not use the Partitioning and Advanced Compression options

NuGenesis requires the following initialization parameters:

• db_block_size >= 8192
• db_files = 1000
  • This parameter sets the upper limit on the number of data files which can be added to a database or a PDB.  1000 is the recommended minimum if database storage will be used exclusively, but if Managed Storage is to be used (and/or with larger datafiles), then this value can be set lower than 1000
• nls_characterset = AL32UTF8
• nls_nchar_characterset = AL16UTF16
• nls_length_semantics = BYTE
• optimizer_mode = FIRST_ROWS_100
• db_securefile = PREFERRED
  • The NuGenesis tablespaces by default use Automatic Segment Space Management, which requires SecureFile LOBs.  By default, many NuGenesis tables and LOB indexes use LOB compression, which also require SecureFiles
• job_queue_processes = 1000
  • SDMS and LMS both use background jobs for indexing of record contents.  A busy system will trigger more than 40 jobs (the default limit)
• sec_case_sensitive_logon = TRUE
  • Enforces case-sensitivity for Oracle DB usernames and passwords
  • "ERROR: sec case sensitive logon=FALSE in this database!" reported NuGenesis 9 in the database schema_verify log file
• sec_max_failed_login_attempts = 7
• cluster_database = FALSE
  • NuGenesis databases are not supported in a cluster environment

ADDITIONAL INFORMATION

If the Advanced Compression option is not installed, then please contact Waters Professional Services for assistance with a custom installation of the NuGenesis schemas. The default NuGenesis installation creates the tables under the assumption that Advanced Compression is enabled in the instance.

The Waters Database Manager (WDM), if installed, requires one additional component and one option:

• Application Express (APEX), installed as part of the WDM installation process if a compatible APEX version is not already present
• Java, required for some WDM components