From Oracle Argus Insight to Oracle Argus Safety (manually)

During Fresh installation, the database link from Oracle Argus Insight to Oracle Argus Safety (DB_LINK_ARGUS) is created as a part of the installation process. However, you can manually recreate the link DB_LINK_ARGUS.

1. Navigate to Argus Release Media\Database\Argus Insight\Utilities\Database_Links\db_link_argus.
   • For Windows—execute the batch script ai_create_db_link_argus.bat
   • For Linux—execute the shell script ai_create_db_link_argus
2. When prompted, enter the following parameters:
   • Enter the name of the Oracle Argus Safety Database instance: <SaOracle Argus Safetyfety Database Instance Name>
   • Enter the name of the Oracle Argus Insight Database instance: <Oracle Argus Insight Database Instance Name>
   • Enter the name of DBA User in Oracle Argus Insight DB: <Oracle Argus Insight dba user>
   • Enter the password for user &dba_user: <Oracle Argus Insight dba user pwd>
   • Enter the name of the Read Only User in Oracle Argus Safety DB: <Oracle Argus Safety Read Only user for Oracle Argus Insight, for example: INSIGHT_RO_USER>
   • Enter the password for Read Only user in Oracle Argus Safety: <Read-only user pwd>
   • Enter the name of the stage owner in Oracle Argus Insight: <Stage user of Oracle Argus Insight>
   • Enter the password for Oracle Argus Insight user: <Stage user password>
   • Enter the name of the mart owner in Oracle Argus Insight: <Oracle Argus Mart user of Oracle Argus Insight>
   • Enter the password for Oracle Argus Mart owner: <Oracle Argus Mart user password>
   • Enter the name of the mart app owner in Oracle Argus Insight: <App user of Oracle Argus Insight>
   • Enter the password for app owner: <App user password>
3. Verify that the script is successfully connected as <Oracle Argus Insight DBA user/Oracle Argus Insight DBA user pwd>@<Oracle Argus Insight>, and press Enter.

   Wait until a message Created <Safety DB Global Name> @DB_LINK_ARGUS appears for each Stage, Mart, and App user. This link name is stored in the key DB_LINK_ARGUS of CMN_PROFILE_GLOBAL in the Oracle Argus Insight database.

   For example, a typical DB link is:

   • SAF823DB@DB_LINK_ARGUS
   • SAF823DB.US.CORP.COM@DB_LINK_ARGUS
4. Press Exit to close the Oracle Argus Insight to Argus Database Link Creation window.
5. Verify the log files for status from:

   Argus Release Media\Database\Argus Insight\Utilities\Database_Links\db_link_argus\DB_LINK_ARGUS_MMDDYYYY_HH24MISS.log