Upgrading Oracle Argus Mart signal configuration from 8.1.x to 9.0

To upgrade an Oracle Argus Mart signal configuration from 8.1.x to 9.0 perform these steps.

  1. Make sure that the Oracle Argus Mart Signal Management configuration is updated to 8.1.
  2. If it does not already exist on the Oracle Empirica Signal application server, create the following directory:
    /u01/stage/projects
  3. Copy the Argus_Prep_3_0_0_1_xxx.zip file from the distribution media to:
    /u01/stage/projects
  4. Change your current directory to /u01/stage/projects as follows:
    cd /u01/stage/projects/
  5. Unpack the Argus_Prep_3_0_0_1_xxx.zip file into a temporary directory, for example:
    $ unzip Argus_Prep_3_0_0_1_xxx.zip -d /u01/stage/projects/

    The /argus_prep subdirectory is created.

  6. Navigate to the argus_prep/sigdet/db directory, for example:
    $ cd /u01/stage/projects/argus_prep/sigdet/db
  7. Run update_Argus_ISM_8_1_1_to_9_0.sql script in SQL*PLUS providing Argus Signal Management configuration Id as parameter, for example
    $ sqlplus <signal database account name>@<TNS_name> @update_Argus_ISM_8_1_1_to_9_0 <SMC_Id>

    where <signal database account name> is the Oracle Empirica Signal database user account name, for example, webvdme, and <TNS_name> is the TNS name that the application server uses to access the database server.

    A password prompt appears.

  8. Inspect update_Argus_ISM_8_1_1_to_9_0.log log file for possible errors.

Note:

If the application is not re-started after upgrade, the first refresh may fail. To avoid that, restart the Oracle Empirica Signal application after the upgrade.