Create a Fresh Oracle Argus Mart Schema

1. Log in to the Oracle Argus Mart Server with administrator privileges.
2. Navigate to Programs > Oracle > Argus Mart > Database > DBInstaller.
3. Open Dbinstaller\dbinstaller.properties file.
4. Modify the following parameters:

   • Mart Database:

     • db_connect_string—connects to the Oracle Argus Mart database.

       Syntax: db_connect_string=<host>:<port>/<service name>

       For example:

       server.us.xx.com:1521/AM821MT

       or

       server.us.xx.com:1521/AM821MT.us.xx.com
     • dba_user—specifies the name of the Install user to run Oracle Argus Mart Liquibase Install.

       See Create the Install User in Oracle Argus Mart.

     • default_datafile_directory—default location on the database server, where datafiles will be created.

   • Mart User of each schema, where password is optional:

     • appschema_sm_mart
     • appschema_sm_stage
     • appschema_sm_app
     • appschema_etl_user
     • appschema_rls_user
     • appschema_bi_user

   • Safety Database:

     • safety_db—Oracle Argus Safety database instance name
     • safety_ro_user—Oracle Argus Mart Read-only user created in Oracle Argus Safety

   Note:

   For more information on these parameters, see Overview of the dbinstaller.properties file.

   It is recommended that you preserve the default names for tablespaces and roles.

5. From the command prompt, go to DBInstaller directory.
6. Type dbinstaller.bat, and press Enter.

   The Liquibase install begins, and the parameters (as entered) appear on the command prompt screen with password in the hidden mode (****).

7. Keep monitoring the Liquibase progress by querying the Liquibase Log table mart_dbchangelog, created in AM_MART_USER schema.
8. When the process is complete, a confirmation message appears with the latest version of Oracle Argus Mart.

   The following is created as per the values specified in the dbinstaller.properties file:

   • Users
     • AM_MART_USER
     • AM_STAGE_USER
     • AM_APP_USER
     • AM_ETL_USER
     • AM_VPD_USER
     • AM_BI_USER

   • Roles

     • AM_VPD_ADMIN_ROLE

   • Factory Data

     • Out of the box Factory data is loaded into tables such as ETL_SIGNAL_TABLE_MAPPING, RM_CMN_PROFILE_GLOBAL, etc.
   • Database Links, DB_LINK_ARGUS:
     • From AM_STAGE_USER of Oracle Argus Martto AS_MART_USER of Safety.
   • Tablespaces

     Note that the tablespace names begin with AM.

     The Schema Creation Tool creates the following tablespaces for the Oracle Argus Mart database, when you create Oracle Argus Mart schema:

     • AM_APP_DATA_01
     • AM_APP_INDEX_01
     • AM_APP_LOB_01
     • AM_MART_DATA_01
     • AM_MART_INDEX_01
     • AM_MART_LOB_01
     • AM_STAGE_DATA_01
     • AM_STAGE_INDEX_01
     • AM_STAGE_LOB_01