Update Oracle Argus Mart 8.2 (and later) for use with Oracle Empirica Signal 9.1

To update Oracle Argus Mart 8.2 and later to Oracle Empirica Signal 9.1, perform these steps using the non-privileged user account on the application server.

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

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

   The /UPDATE_AM_8_0_FOR_SIGNAL_9_1 subdirectory is created.

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

   $ cd /u01/stage/UPDATE_AM_8_0_FOR_SIGNAL_9_1

4. Using a text editor, open the create_argus_spontaneous_configurations.sql file.
5. Locate the following WHERE clause:

   WHERE UPPER (report_type_ve) IN (''SPONTANEOUS'',''LITERATURE'')

   The WHERE clause describes the spontaneous reports from the Oracle Argus Mart database user account.

6. Modify the WHERE clause as needed.
7. Save and close the file.
8. Execute the UPDATE_AM_8_0_FOR_SIGNAL_8_1.sql script as the am_mart_user, for example:
   $ sqlplus am_mart_user@<TNS_name> @UPDATE_AM_8_0_FOR_SIGNAL_8_1.sql

   A password prompt appears.

9. Enter the am_mart_user database account password, and then press Enter.
10. Execute the UPDATE_AM_8_2_FOR_SIGNAL_9_1.sql script as the am_mart_user. For example:
    $ sqlplus am_mart_user@<TNS_name> @UPDATE_AM_8_2_FOR_SIGNAL_9_1.sql

    A password prompt appears.

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