- Installation and Administration Guide
- Installation
- Create the Oracle Argus Mart Database Structure
- Install Oracle Argus Mart
- Create a Fresh Oracle Argus Mart Schema
Create a Fresh Oracle Argus Mart Schema
- Log in to the Oracle Argus Mart Server with administrator privileges.
- Navigate to
...\ArgusMart\Database\DBInstaller
. - Open
Dbinstaller\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:
server.us.xx.com:1521/AM84MT
or
server.us.xx.com:1521/AM84MT.us.xx.com
- dba_user—specifies the name of the Install user to run Oracle Argus Mart Liquibase Install.
- default_datafile_directory—default location on the database server, where datafiles will be created.
- db_connect_string—connects to the Oracle Argus Mart database.
-
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.
-
- From the command prompt, go to DBInstaller directory.
- 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 (****).
- Keep monitoring the Liquibase progress by querying the Liquibase Log table
mart_dbchangelog
, created inAM_MART_USER
schema. - 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_ADMIN
- 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 Mart to AS_MART_USER of Safety.
- Tablespaces
Note that the tablespace names begin with AM.
The DBInstaller 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
- Users
Parent topic: Install Oracle Argus Mart