From Oracle Argus Mart to Oracle Argus Safety (manually)

During Fresh installation, the database link from Oracle Argus Mart 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 DBInstaller\Utilities\Create_Safety_RO_User:
   • For Windows—execute the batch script sm_create_db_link_argus.bat
   • For Linux—execute the shell script sm_create_db_link_argus
2. When prompted, enter the following parameters:
   • Enter the name of the Safety Database instance: Safety Database Instance Name
   • Enter the name of the Mart Database instance: Mart Database Instance Name
   • Enter the name of DBA User in Mart DB: Mart Install user
   • Enter the password for user Mart DBA User: Mart Install user password
   • Enter the name of the Read Only User in Safety DB: Safety Read-only user for Mart
   • Enter the password for Read Only user in Safety: Read-only user password
   • Enter the name of the stage owner in Mart: Stage user of Mart
   • Enter the password for Stage user: Stage user password
3. Verify that the script is successfully connected as <Mart Install user/Mart Install user pwd>@<Argus Mart>, and press Enter.

   Wait until a message Created <Safety DB Global Name>@DB_LINK_ARGUS appears for Stage user.

   The key DB_LINK_ARGUS of RM_CMN_PROFILE_GLOBAL in the Oracle Argus Mart database contains the DB link name.

   For example, a DB link is:

   SAF821DB@DB_LINK_ARGUS

   or

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

   DBInstaller\Utilities\Create_Safety_RO_User\DB_LINK_ARGUS_MMDDYYYY_HH24MISS.log