Update an Existing Oracle Argus Mart 8.x Integration

If Oracle Argus Mart 8.x or later is already integrated with Oracle Empirica Signal and you are upgrading the integration to Oracle Argus Mart 8.2 or later, perform these steps using the non-privileged user account on the application server.

Note: If you are performing a new installation, see Set up a new Oracle Argus Mart 8.2 Integration for use with Oracle Empirica Signal.

1. Copy the Update_AM_for_Signal_9_2_0_0_xxx.zip file from the distribution media to a temporary directory on the server.
2. Unpack the Update_AM_for_Signal_9_2_0_0_xxx.zip file into a temporary directory, for example:

   $ unzip Update_AM_for_Signal_9_2_0_0_xxx.zip -d /u01/stage/

   The /UPDATE_AM_FOR_SIGNAL subdirectory is created.

3. Navigate to the /UPDATE_AM_FOR_SIGNAL directory, for example:

   $ cd /u01/stage/UPDATE_AM_FOR_SIGNAL

4. Execute the Update_Argus_Mart_to_8.2.sql script as the am_mart_user. For example:

   $ sqlplus am_mart_user@<TNS_name> @Update_Argus_Mart_to_8.2.sql

   A password prompt appears.

5. Enter the am_mart_user database account password, and then press Enter.