- Installation and Administration Guide
- Installation
- Create the Oracle Argus Mart Database Structure
- Create Database Links
- From Oracle Argus Mart to Oracle Argus Insight
From Oracle Argus Mart to Oracle Argus Insight
- 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
- For Windows—execute the batch script
- 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.
- 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.
-
- 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
Parent topic: Create Database Links