Overview of the dbinstaller.properties file

Open the DBInstaller\dbinstaller.properties file, and view or modify the following parameters to make sure that Liquibase runs properly.

Parameter Description Modify Default or Sample Value

db_connect_string

Jdbc Url to connect to the Target Database

Yes

url= <host>:<port>/<service name>

dba_User

Name of the Target Database DBA user

Yes

dba_User=am_dba_user

logLevel

Log level setting related to liquibase for smooth run.

Possible values:

  • DEBUG
  • INFO

Yes

logLevel=info

appSchema_sm_mart

Oracle Argus Mart schema Owner name and password

No

appSchema_mart_user=am_mart/pwd

appSchema_sm_stage

Oracle Argus Mart Staging schema Owner

No

appSchema_sm_stage=am_stage

appSchema_sm_app

Oracle Argus Mart Application schema Owner name and password

No

appSchema_sm_app=am_app/pwd

appSchema_etl_user

Oracle Argus Mart Etl User and password

No

appSchema_etl_user=am_etl/pwd

appSchema_rls_user

Oracle Argus Mart VPD schema Owner name and password

No

appSchema_rls_user=am_vpd/pwd

appSchema_bi_user

Oracle Argus Mart BI schema Owner name and password

No

appSchema_bi_user=am_bi/pwd

#Mart Database Role

am_vpd_admin_role

Admin role given to AM_ETL_USER

Yes

am_vpd_admin_role=AM_VPD_ADMIN_ROLE

Safety_db

Oracle Argus Safety Database TNS

Yes

safety_db=SAF821DB

or

safety_db= SAF821DB.US.EXAMPLE.COM

Safety_RO_User

Oracle Argus Mart read-only user name in Argus Safety

Yes

Safety_RO_User=am_ro_user

#Datafile directory location

Location of the default datafiles directory.

Yes

default_datafile_destination=c:/app/oradata/AM821DB

#Argus Mart > Stage User Datafiles

Location of Oracle Argus Mart stage user datafiles.

Yes

  • stage_data_ts_datafile=C:\app\oradata\AM81MTF2\AM__STAGE_DATA_01.DBF
  • stage_ind_ts_datafile=C:\app\oradata\AM81MTF2\AM_STAGE_INDEX_01.DBF
  • stage_lob_ts_datafile=C:\app\oradata\AM81MTF2\AM_STAGE_LOB_01.DBF

#Argus Mart > Mart User Datafiles

Location of Oracle Argus Mart > Mart user datafiles.

Yes

  • mart_data_ts_datafile=C:\app\oradata\AM81MTF2\AM_MART_DATA_01.DBF
  • mart_ind_ts_datafile=C:\app\oradata\AM81MTF2\AM_MART_INDEX_01.DBF
  • mart_lob_ts_datafile=C:\app\oradata\AM81MTF2\AM_MART_LOB_01.DBF

#Argus Mart > Apr User Datafiles

Location of Oracle Argus Mart APR user datafiles

Yes

  • apr_user_data_ts_datafile=C:\app\oradata\AM81MTF2\AM_APP_DATA_01.DBF
  • apr_user_ind_ts_datafile=C:\app\oradata\AM81MTF2\AM_APP_INDEX_01.DBF
  • apr_user_lob_ts_datafile=C:\app\oradata\AM81MTF2\AM_APP_LOB_01.DBF

Default and Temporary tablespaces

Defines default and temporary tablespace name

No

  • default_ts=USERS
  • temp_ts=TEMP

Tablespace Encryption

Specifies the logic used for default encryption

Yes

tablespace_encryption=<blank> or <text>, where

  • blank—no encryption
  • text— like encryption using 'AES256' default storage (encrypt)

Tablespace Parameters

Specifies the details of the tablespace

Yes

  • tablespace_initial_size=10M
  • tablespace_autoextend=ON
  • tablespace_next_size=10M
  • tablespace_block_size=8K