- Installation Guide
- Install Oracle Argus Analytics
- Preinstallation Configuration
Preinstallation Configuration
- The TNS entries for both the Data Mart Schema and the Oracle Argus Safety Database Schema should be present in the Oracle Analytics Server 19c home in the path:
<OracleBI Home>\user_projects\domains\<BI Domain Name>\config\fmwconfig\bienv\core\
- Configuring the TNS for Oracle Client:
The TNS names entry for both Oracle Argus Analytics data mart and the Oracle Argus Safety Source system should be configured here:
<Oracle Client Home>\network\admin\tnsnames.ora
- Configuring the TNS for Oracle Database Servers:The TNS names entry for both Oracle Argus Analytics data mart and the Oracle Argus Safety Source system should be configured here:
- Oracle Argus Safety DB Server:
<Oracle Client Home>\network\admin\tnsnames.ora
This should contain the TNS entry for Oracle Argus Safety DB Server. - Oracle Argus
Analytics DB Server:
<Oracle DB Home>\network\admin\tnsnames.ora
This should contain the TNS entry for Oracle Argus Analytics Data DB Server.
- Oracle Argus Safety DB Server:
- Set up the Oracle Client Home in the PATH variable.
- Set up an INSTALL (DBA) user:
- Execute the ancreatedbauser.bat file from
<Argus Analytics Installer directory>\install\utils\create_an_dba_user
.A prompt appears asDo you want to use SYSDBA to run the script? (Y/N):
. Enter Y to run as SYSDBA. - Enter the following inputs:
- Database Connection String for Oracle Argus Safety or Oracle Argus Analytics DB
- Enter the user with SYSDBA privileges in <Argus Analytics/Argus Safety> database
- Enter password for <SYSDBA user> in <Argus Analytics/Argus Safety> database
- Enter DBA User to be created in <Argus Analytics/Argus Safety> database
- Enter password for <DBA user> in <Argus Analytics/Argus Safety> database
Repeat the procedure to create INSTALL(DBA) user for Oracle Argus Safety database, and Oracle Argus Analytics database.
Note:
- If the INSTALL (DBA) user already exits in the database, then the script provides the required additional grants to the user. If the user does not exists in the database, a new user is created, and necessary grants are provided.
- When the installation is complete, you may drop
this user from the database by executing the following
command:
DROP USER <INSTALL (DBA) USER> CASCADE;
- Execute the ancreatedbauser.bat file from
- Set up the TABLESPACES:
The installer creates new schemas in the data mart and prompts for the tablespaces to be used. It is recommended to create one default tablespace and a temporary tablespace to be used for the new schemas that get created in both the Oracle Argus Analytics DB Instance and the Oracle Argus Safety DB Instance.
You can choose to create tablespaces either by executing a batch file or manually.
- To create tablespace from a batch file:
- Execute the ancreatetablespace.bat
file from
<Argus Analytics Installer directory>\install\utils\an_tablespace
.A prompt appears as
Do you want to use SYSDBA to run the script? (Y/N):
. Enter Y to run as SYSDBA. - Enter the following parameters:
- Database Connection String for Oracle Argus Safety or Oracle Argus Analytics DB
- Enter the user with SYSDBA privileges in &db_mart. database
- Enter password for &sysdba_user in &db_mart. Database
- Enter the DATA Tablespace Name [e.g. AN_DATA_TS]
- Enter the TEMP Tablespace Name [e.g. AN_TEMP_TS]
- Enter the complete data file path
- Tablespace Encryption Required [0 - No, 1 - Yes]
- Tablespace Encryption Algorithm [e.g AES256]
Repeat the procedure to create tablespaces for Oracle Argus Safety database and Oracle Argus Analytics database.
- Execute the ancreatetablespace.bat
file from
- To manually create the tablespaces, see the
following examples:
Default TABLESPACE [one each needed at the Oracle Argus Analytics DWH DB Server and Oracle Argus Safety DB Server]:
CREATE TABLESPACE <AN_DATA_TS> DATAFILE '/DatafilePath/<AN_DATA_TS>_01.dbf' SIZE 100M AUTOEXTEND ON NEXT 1M LOGGING;
Temporary TABLESPACE [one each needed at the Oracle Argus Analytics DWH DB Server and Oracle Argus Safety DB Server]:CREATE TEMPORARY TABLESPACE <AN_TEMP_TS> TEMPFILE '/Tempfile Path/<AN_TEMP_TS>_01.dbf' SIZE 100M AUTOEXTEND ON NEXT 1M;
- To create tablespace from a batch file:
Next: