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 19c— https://docs.oracle.com/en/database/oracle/oracle-database/19/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
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, 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 latest 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.
Note:
Argus Safety database compatible parameter should be set as the <current version>.| # |
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 |
Table 2-1 lists the database parameters and the values that must be set for Argus Insight.
For those parameters that require a numeric value, Table 2-1 lists the minimum value recommended. You may need to increase the value depending on your system configuration and the number of cases. It is the responsibility of the database administrator to monitor the system and adjust the database parameters as necessary.
Table 2-1 Database Parameters for Argus Insight
| Database Parameter | Required Value |
|---|---|
|
COMPATIBLE (for Oracle 12c R1) |
12.1.0.2 or later |
|
CURSOR_SHARING |
EXACT |
|
JOB_QUEUE_PROCESSES |
10 (Minimum value recommended) |
|
NLS_LENGTH_SEMANTICS |
CHAR |
|
OPTIMIZER_MODE |
ALL_ROWS |
|
OPTIMIZER_SECURE_VIEW_MERGING |
TRUE |
|
PARALLEL_MAX_SERVERS |
Minimum value recommended based on the total number of cases:
|
|
PGA_AGGREGATE_TARGET |
Minimum value recommended based on the total number of cases:
|
|
QUERY_REWRITE_ENABLED |
TRUE (if computing statistics regularly) FALSE (if not computing statistics regularly) |
|
SGA_MAX_SIZE |
Greater than or equal to the value of the SGA_TARGET parameter. |
|
SGA_TARGET |
Minimum value recommended based on the total number of cases:
The 32-bit architecture allows for 4 GB of physical memory to be addressed. DBAs should verify the maximum addressable RAM for their respective architectures. |
|
UNDO_MANAGEMENT |
AUTO |
|
WORKAREA_SIZE_POLICY |
AUTO |
|
DB_BLOCK_BUFFERS (in MB) / |
Leave set to the Oracle default value |
|
DB_BLOCK_SIZE (in bytes) |
Leave set to the Oracle default value |
|
QUERY_REWRITE_INTEGRITY |
Leave set to the Oracle default value |
|
SHARED_POOL_SIZE |
Leave set to the Oracle default value |
Table 2-2 Recommended Database I/O Configuration for Argus Insight
| Total Number of Cases | ||||
|---|---|---|---|---|
| Database I/O Configuration | Small (< 30,000) | Medium (30,000 to 200,000) | Large (200,000 to 1,000,000) | Extra Large (> 1,000,000) |
|
Number and Size of Redo Log Files |
Default |
3 X 500 MB |
5 X 500 MB |
5 X 500 MB |
|
The value depends on the characteristics of the I/O subsystem such as the I/O bandwidth, storage disks type, and RAID level. (Oracle recommends RAID 1+0 or similar.) |
||||
|
TEMP Tablespace Size |
32 GB |
32 GB |
64 GB |
128 GB |
|
UNDO Tablespace Size |
16 GB |
32 GB |
64 GB |
128 GB |
|
The recommended UNDO tablespace size is based on the projections with the following two parameter values: RETENTION=NOGUARANTEE UNDO_RETENTION=900 (seconds) |
||||
Table 2-3 Recommended Configuration for the Argus Insight Database Server
| Total Number of Cases | ||||
|---|---|---|---|---|
| Database Server Configuration | Small (< 30,000) | Medium (30,000 to 200,000) | Large (200,000 to 1,000,000) | Extra Large (> 1,000,000) |
|
RAM |
4–8 GB |
8–16 GB |
16–32 GB |
16–32 GB |
|
CPU |
Equivalent to 2–4 Dual Core, 3 GHz |
Equivalent to 4–8 Dual Core, 3 GHz |
Equivalent to 8–12 Dual Core, 3 GHz |
Equivalent to 8–12 Dual Core, 3 GHz |
Note:
The Argus Insight Database and Argus Safety Database TNS names entry must be available in both Argus Insight Database Server and Argus Safety Database Server. Argus Safety Database TNS should also be present in the Argus Insight Web Server.