Argus Mart upgrade process has been moved from Schema Creation Tool to Liquibase.Liquibase is a refactoring tool that is utilized to enable a silent installation.
Recreate the Safety RO User of Argus Mart.
Recreate the DB_LINK_ARGUS manually, from Argus Mart to Argus Safety (see Section 2.3.1, "From Argus Mart to Argus Safety (manually).").
Log in to Argus Mart Web Server.
Navigate to Programs > Oracle > Argus Mart > Database > DBInstaller.
Open DBInstaller.properties file.
Modify the following parameters:
Mart Database:
db_connect_string—connects to the Argus Mart database.
Syntax: db_connect_string=<host>:<port>/<SID>
For example, db_connect_string=server.us.xx.com:1521/AM82MT
Or, db_connect_string=server.us.xx.com:1521/AM82MT.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—Argus Safety database instance name
safety_ro_user—Argus Mart read-only user created in Argus Safety
Note:
For more information on these parameters, see Section 2.1, "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 Argus Mart.
Validate Schema using the schema validation control file VLDN_AM_8.2.CTL.