From Oracle Argus Safety to Oracle Argus Insight Database

This link allows real-time updates of some of the values from Oracle Argus Safety Console to Oracle Argus Insight data mart.

Create the reverse DB Link by executing the script file from Argus Release Media\Database\Argus Insight\Utilities\Database_Links\argus_to_mart.
- For Windows—execute the batch script ai_argus_db_link_setup.bat
- For Linux—execute the shell script ai_argus_db_link_setup
When prompted, enter the following parameters:
- Enter the Oracle Argus Safety Database Tns Name: <Safety Database Instance Name>
- Enter the name of Oracle Argus Safety schema owner in Oracle Argus Safety Database Instance: <user account that owns the Oracle Argus Safety schema, for example: ARGUS_APP>
- Enter the password for Oracle Argus Safety schema owner: <password of Oracle Argus Safety owner>
- Enter the name of Oracle Argus Safety Role: <Oracle Argus Safety role>
- Enter the name of Read only user in Oracle Argus Safety Database: <Oracle Argus Insight Read-only user, created in Oracle Argus Safety>
  
  For example, <INSIGHT_RO_USER>
- Enter the Oracle Argus Insight Database Tns Name: <Oracle Argus Insight database>
- Enter the name of link user in Oracle Argus Insight Database.: <link user of Oracle Argus Insight for example: APR_LINK_USER>
- Enter the password for user Link user: <link user password>
Verify that the script is successfully connected as <Oracle Argus Safety schema owner/Oracle Argus Safety schema password>@<Oracle Argus Safety Database Name>, and press Enter.
When the confirmation message appears, press Enter.

Wait until a message Created <Insight DB Global Name> @ARGUS_TO_MART appears. This link name gets stored in the key DB_LINK_ARGUS_TO_MART of CMN_PROFILE_GLOBAL of the Oracle Argus Safety database.
Press Exit to close the window.
Verify the log files for status from:

Argus Release Media\Database\Argus Insight\Utilities\Database_Links\argus_to_mart\ ARGUS_TO_MART_DB_LINK_MMDDYYYY_HH24MISS.log

Parent topic: Create Database Links