1. Installation Guide
  2. Install or Upgrade Oracle Argus Safety Database Tier
  3. Create the Oracle Argus Insight Data Mart Structure
  4. Configure dbinstaller.properties file

Configure 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

Database instance details

Yes

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

dba_user

Name of the Target Database DBA user

Yes

dba_user=AI_DBA_USER

log_level

Log level setting related to liquibase for smooth run.

Possible values:

  • DEBUG
  • INFO

Yes

log_level=info

argus_securekey_path

Complete directory path of Oracle Argus Safety Secure Key ini file on the middle-tier.

Yes

argus_securekey_path=c:/windows

appschema_mart_user

Oracle Argus Insight Mart schema Owner

No

appschema_mart_user=APR_MART/pwd

appschema_stage_user

Oracle Argus Insight Staging schema Owner

Yes

appschema_stage_user=APR_STAGE/pwd

appschema_ai_link_user

Oracle Argus Insight Link User

Yes

appschema_ai_link_user=APR_LINK/pwd

appschema_rls_user

Oracle Argus Insight VPD schema Owner

Yes

appschema_rls_user=RLS_USER/pwd

appschema_mart_app_user

Oracle Argus Insight Application schema Owner

Yes

appschema_mart_app_user=APR_APP/pwd

appschema_mart_hist_user

Oracle Argus Insight History schema Owner

Yes

appschema_mart_hist_user=APR_HIST/pwd

appschema_ai_apr_user

Oracle Argus Insight apr User Name

No

appschema_ai_apr_user=APR_USER/pwd

appschema_ai_login_user

Oracle Argus Insight Login User Name

Yes

appschema_mart_user=APR_LOGIN/pwd

ai_role

Oracle Argus Insight Mart Role

Yes

ai_role=MART_ROLE

ai_app_role

Oracle Argus Insight Mart App Role

Yes

ai_app_role=APP_ROLE

ai_link_role

Oracle Argus Insight Mart Link Role

Yes

ai_link_role=LINK_ROLE

safety_db

Oracle Argus Safety database instance name

Yes
  • safety_db=SAF823DB, or
  • safety_db=SAF823DB.US.EXAMPLE.COM

safety_ro_user

Oracle Argus Insight read only user in Safety DB

Yes

safety_ro_user=INSIGHT_RO_USER

#Default Datafiles Directory

Default location of the datafiles. on the Database Server

Yes

default_datafile_destination

=<c:/app/oradata/823DB>

#Insight Stage Normal Datafiles

Location of Oracle Argus Insight normal datafiles.

Yes
  • ai_stage_data_01_datafile=APR_STAGE_DATA_01.DBF
  • ai_stage_ind_01_datafile=APR_STAGE_INDEX_01.DBF
  • ai_stage_lob_01_datafile =APR_STAGE_LOB_01.DBF

#Insight Stage ESM Datafiles

Location of Oracle Argus Insight ESM datafiles.

Yes
  • apr_sesm_data_01_datafile=APR_SESM_DATA_01.DBF
  • apr_sesm_ind_01_datafile=APR_SESM_INDEX_01.DBF
  • apr_sesm_lob_01_datafile=APR_SESM_LOB_01.DBF

#Insight Stage WHO Datafiles

Location of Oracle Argus Insight WHO datafiles.

Yes
  • stage_who_01_datafile=APR_SWHOC_DATA_01.DBF

#Insight Mart Case/Rpt Datafiles

Location of Oracle Argus Insight Mart case and report datafiles.

Yes
  • mart_case_rpt_data_01_datafile=APR_MCAS_DATA_01.DBF
  • mart_case_rpt_ind_01_datafile=APR_MCAS_INDEX_01.DBF
  • mart_case_rpt_lob_01_datafile=APR_MCAS_LOB_01.DBF

#Insight Mart Non-Case/Rpt Datafiles

Location of Oracle Argus Insight Mart non-case and report datafiles.

Yes
  • mart_non_case_data_01_datafile=APR_MCFG_DATA_01.DBF
  • mart_non_case_ind_01_datafile=APR_MCFG_INDEX_01.DBF
  • mart_non_case_lob_01_datafile=APR_MCFG_LOB_01.DBF

#Insight Mart EDM Datafiles

Location of Oracle Argus Insight Mart EDM datafiles

Yes
  • mart_edm_data_01_datafile=APR_MEDM_DATA_01.DBF
  • mart_edm_ind_01_datafile=APR_MEDM_INDEX_01.DBF
  • mart_edm_lob_01_datafile=APR_MEDM_LOB_01.DBF

#Insight Mart WHO Datafiles

Location of Oracle Argus Insight Mart WHO datafiles

Yes
  • mart_who_01_datafile=APR_MWHOC_DATA_01.DBF

#Insight Hist Case/Rpt Datafiles

Location of Oracle Argus Insight case or report History datafiles

Yes
  • hist_case_rpt_data_01_datafile=APR_MCAS_HIST_DATA_01.DBF
  • hist_case_rpt_ind_01_datafile=APR_MCAS_HIST_INDEX_01.DBF
  • hist_case_rpt_lob_01_datafile=APR_MCAS_HIST_LOB_01.DBF

#Insight Hist Non-Case/Rpt Datafiles

Location of Oracle Argus Insight non-case and report History datafiles.

Yes
  • hist_non_case_data_01_datafile=APR_MFACT_HIST_DATA_01.DBF
  • hist_non_case_ind_01_datafile=APR_MFACT_HIST_INDEX_01.DBF
  • hist_non_case_lob_01_datafile=APR_MFACT_HIST_LOB_01.DBF

#Insight Apr Datafiles

Location of Oracle Argus Insight APR datafiles

Yes
  • apr_user_data_01_datafile=APR_USER_DATA_01.DBF
  • apr_user_ind_01_datafile=APR_USER_INDEX_01.DBF
  • apr_user_lob_01_datafile=APR_USER_LOB_01.DBF

Default and Temporary tablespaces

Defines default and temporary tablespace name

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

Parent topic: Create the Oracle Argus Insight Data Mart Structure