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, or you are upgrading Oracle Signal to 2025.4.01, 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 or later Integration for use with Oracle Empirica Signal.

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

   $ unzip Update_AM_for_Signal_2025_4_01_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 select Enter.
6. Enable support of versioned case series:
   $ sqlplus am_mart_user@<TNS_name> @Update_Argus_Mart_Configurations.sql
7. Enter the am_mart_user database account password when prompted, and then select Enter.
8. If Empirica Signal is integrated with Argus Mart, execute the empirica_Utils.sql script $ sqlplus am_mart_user@<TNS_name> @empirica_Utils.sql.
9. Enter the am_mart_user database account password, and then select Enter.
10. If Empirica Signal is integrated with Argus Mart, update the CaseScore_Utils package. Execute these commands:
    • $ sqlplus am_mart_user@<TNS_name> @CaseScore_Utils.pks
    • $ sqlplus am_mart_user@<TNS_name> @CaseScore_Utils.pkb
11. Enter the am_mart_user database account password when prompted, and then select Enter .