From Oracle Argus Mart to Oracle Argus Insight

1. When Oracle Argus Insight and Oracle Argus Mart are on different database instances, execute the script from the folder DBInstaller\Utilities\Database_Links\ai_am_db_link:
   • For Windows—execute the batch script am_insight_db_link_setup.bat
   • For Linux—execute the shell script am_insight_db_link_setup
2. When prompted, enter the following parameters:
   • Enter the Oracle Argus Mart Database Instance name
   • Enter the INSTALL user name in Oracle Argus Mart, like AM_DBA_USER
   • Enter the password for the above user
   • Enter the Oracle Argus Mart application user name, like AM_APP_USER
   • Enter the password for the above user
   • Enter the Oracle Argus Mart Schema user name, like AM_MART_USER
   • Enter the password for the above user
   • Enter the Oracle Argus Insight Database Name
   • Enter the Oracle Argus Insight Application User name, like APR_APP
   • Enter the Password for the above user
   • Enter the Oracle Argus Insight Readonly User name, like APR_LINK_USER
   • Enter the Password for the above user

   The process of creating the database links begins.

3. The following database links are created (by dropping the existing links if any, with the same name.

   • <Insight DB Global Name>@DB_LINK_INSIGHT—From Oracle Argus Mart AM_APP_USER >Oracle Argus Insight APR_APP

     The key DB_LINK_INSIGHT of RM_CMN_PROFILE_GLOBAL in the Oracle Argus Mart database is updated with this DB link name.

   • <Insight DB Global Name>@ARGUS_MART_TO_INSIGHT_MART—From Oracle Argus Mart AM_MART_USER > Oracle Argus Insight APR_LINK_USER

     The key DB_LINK_AM_MART_TO_AI_MART of RM_CMN_PROFILE_GLOBAL in the Oracle Argus Mart database is updated with this DB link name.

4. Review the following log file, and check for any errors, when a confirmation message appears.

   \DBInstaller\Utilities\ai_am_db_link\MART_TO_INSIGHT_DB_LINK_MMDDYYYY_HH24MISS.log