Database install from scratch
If there is an MES Packaging Control version you want to migrate from, see Migration of Database
Supported Versions
Oracle 19c Enterprise Edition
Sizing
Memory: 16 GB / 32 GB (minimum / recommended)
Storage: Depending on data volume (typically 50-250 GB)
Setup
Character Set: AL32UTF8 (refer to Oracle 19c - A.4 Character Sets)
Time Zone: dependent target region and country (refer to Oracle 19c - 4.9 Setting the Database Time Zone);
Schema/User: 1 schema/user is required per installation with quota unlimited
Tablespaces: 1 tablespace
Tablespace Options (recommended): SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE 32767M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
Privileges
An oracle user with the privileges "NEXEED_BASIC_ROLE", "NEXEED_EXTENDED_ROLE" and "NEXEED_MONITORING_ROLE" as described in the Nexeed IAS Operations Manual is required.
- Securing Data on the Network (Service to Database)
-
Oracle supports two ways to encrypt the Data between Client and Database: Database Native Network Encryption and Transport Layer Security.
Since Transport Layer Security uses a Certificate that expires, we recommend Native Network Encryption.
The setting must be set on the Oracle Database in sql.net[] For details check the topic 18.3.2 in the Linked Documentation
For maximum security on the server, set the following sqlnet.ora parameters:
* SQLNET.ENCRYPTION_SERVER = REQUIRED
* SQLNET.ENCRYPTION_TYPES_SERVER = (AES256)
* SQLNET.CRYPTO_CHECKSUM_SERVER = REQUIRED
* SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (SHA512)
* SQLNET.ALLOW_WEAK_CRYPTO_CLIENTS = FALSE