Install Oracle Database on the Database Server.
In a multi-tenant environment, you must install the Oracle database with the Oracle Database Server Enterprise edition (and not the Standard edition).
Open or download the installation guide for your operating system:
For version 18c— https://docs.oracle.com/en/database/oracle/oracle-database/18/install-and-upgrade.html
For version 12.1.0.2—https://docs.oracle.com/database/121/nav/portal_11.htm
For version 12.2.0.1— https://docs.oracle.com/en/database/oracle/oracle-database/12.2/install-and-upgrade.html
Refer to the Oracle Database Installation Guide for instructions.
As a part of the Oracle Database, Argus Safety requires:
Oracle Database Enterprise or Standard Edition
Oracle Database Client
Follow the instructions in the Oracle Database Installation Guide, making selections appropriate for Argus Safety as noted in the following sections.
You can configure the database as part of the database software installation or after, using the Database Configuration Assistant (DBCA). Argus Safety supports installation on either a Container Database (CDB) containing a Pluggable Database (PDB) or a non-CDB database.
For an explanation of which options require an additional license, see the Database Licensing Information User Manual at http://docs.oracle.com/database/
During installation of the database software (binaries, or server code), select the following:
Advanced or Typical installation
Time Zone
Oracle Real Application Clusters (RAC) (Optional)
| Feature or Option | Mandatory | Recommended | Optional | Notes |
|---|---|---|---|---|
| Character Set: AL32UTF8 | Yes | — | — | — |
| Oracle Text | Yes | — | — | Included automatically if you install the database during server installation. |
| Oracle JVM | Yes | — | — | Included automatically if you install the database during server installation. |
| Oracle XML DB | Yes | — | — | Included automatically if you use the Oracle Database Configuration Assistant to create the database. http://docs.oracle.com/database/121/ADXDB/appaman.htm#ADXDB2700">>http://docs.oracle.com/database/121/ADXDB/appaman.htm#ADXDB2700 |
| Oracle Automatic Storage Management | — | Yes | — | Provides an alternative to conventional volume managers, file systems, and raw devices. |
| Automatic Memory Management | — | Yes | — | Manages instance memory to allow the Oracle Database instance to automatically manage and tune it for you. |
| Oracle Advanced Security Transparent Data Encryption (TDE) | — | Yes | — | Available only for the Enterprise Edition. |
| Oracle Real Application Clusters (RAC) | — | — | Yes | — |
| Oracle Partitioning | — | — | Yes | Available only for the Enterprise Edition. |
Download and install the latest patch set: WINDOWS DB BUNDLE PATCH through Oracle Support.
To install Oracle Client Oracle Client, use the Custom option (NOT the Administrator option) and make sure that the MTS component is checked explicitly.
Set oracle_home to your client home location. For example:
SET ORACLE_HOME=<Oracle Client home path>
Run sqlldr help=y or sqlldr.exe.
Apply the July 2019 CPU patch.
We recommend that you evaluate each site before installation and on an ongoing basis to determine whether these settings are suitable for your business needs.
| # |
Database Parameters | Small(under 30,000 cases reported per month) | Mid-Sized(30,000 to 200,000 cases reported per month) | Large(200,000 to 1,000,000 cases reported per month) | Very Large(over 1,000,000 cases reported per month) |
|---|---|---|---|---|---|
| 1 | MEMORY_TARGET | 10 GB | 16-24 GB | 32-64 GB | >64 GB |
| 2 | PROCESSES | Expected concurrent users + 100 | Expected concurrent users + 100 | Expected concurrent users + 100 | Expected concurrent users + 100 |
| 3 | MEMORY_MAX_TARGET | >= value set
for MEMORY_TARGET |
>= value set
for MEMORY_TARGET |
>= value set
for MEMORY_TARGET |
>= value set
for MEMORY_TARGET |
| 4 | OPTIMIZER_SECURE_VIEW_MERGING | FALSE | FALSE | FALSE | FALSE |
| 5 | CURSOR_SHARING
(Mandatory) |
EXACT | EXACT | EXACT | EXACT |
| 6 | WORKAREA_SIZE_POLICY | AUTO | AUTO | AUTO | AUTO |
| 7 | JOB_QUEUE_PROCESSES | 25 | 25 | 25 | 25 |
| 8 | DB_BLOCK_SIZE (bytes) | 8192 | 8192 | 8192 | 8192 |
| 9 | NLS_LENGTH_SYMANTICS
(Mandatory) |
CHAR | CHAR | CHAR | CHAR |
| 10 | GLOBAL_NAMES | TRUE | TRUE | TRUE | TRUE |
| # |
Setting | Small(under 30,000 cases reported per month) | Mid-Sized(30,000 to 200,000 cases reported per month) | Large(200,000 to 1,000,000 cases reported per month) | Very Large(over 1,000,000 cases reported per month) |
|---|---|---|---|---|---|
| 1 | Number and Size of Redo Log Files | 5 Groups * 100 MB | 5 Groups * 100 MB | 5 Groups * 100 MB | 5 Groups * 100 MB |
| 2 | TEMP Tablespace Size | 8 GB | 16 GB | 32 GB | >=64 GB |
| 3 | Undo Tablespace Size | 8 GB | 16 GB | 32 GB | >=64 GB |
Partitioning of CMN_AUDIT_LOG table can significantly improve performance of the system on large Argus Safety databases. Range partitioning can be performed on the CMN_AUDIT_LOG table for the LOG_DATETIME_STAMP column.
We recommend create partitioning on a yearly basis. Partitioning must be performed and maintained by a qualified database administrator.
Partitioning is an optional Oracle Database feature that can be purchased separately.