Upgrade the Database

1. Log in to Oracle Argus Mart Transaction Server.
2. Navigate to ...\ArgusMart\Database\DBInstaller.
3. Open 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:
       db_connect_string=server.us.xx.com:1521/AM822MT 
       Or, db_connect_string=server.us.xx.com:1521/AM822MT.us.xx.com
       

     • dba_user—specifies the name of the Install user to run Argus Mart Liquibase Install.

       See Create the Install User in Oracle Argus Mart.

   • 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.

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

   The Liquibase upgrade 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.
9. Validate Schema using the schema validation control file VLDN_AM_8.2.2.CTL.

   See Validate the Schema.