- Installation and Administration Guide
- Installation
- Upgrade the Oracle Argus Mart Database
- Upgrade the Database
Upgrade the Database
- Log in to Oracle Argus Mart Transaction Server.
- Navigate to
...\ArgusMart\Database\DBInstaller
. - Open
DBInstaller.properties
file. - 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/AM843MT Or, db_connect_string=server.us.xx.com:1521/AM843MT.us.xx.com
dba_user
—specifies the name of the Install user to run Argus Mart Liquibase Install.
- 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 namesafety_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.
-
- From the command prompt, go to
DBInstaller
directory. - 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 (****).
- Keep monitoring the Liquibase progress by querying the Liquibase Log table
mart_dbchangelog
, created in AM_MART_USER schema. - When the process is complete, a confirmation message appears with the latest version of Oracle Argus Mart.
- Validate Schema using the schema validation control file
VLDN_AM_8.4.3.CTL
.See Validate the Schema.
Parent topic: Upgrade the Oracle Argus Mart Database