Upgrading AERS signal configuration from 8.1.1.1 to 9.0

You can upgrade an AERS interactive signal configuration from 8.1.1.1 to 9.0.

1. Rename your /u01/stage/projects/aers_ism_prep directory to aers_ism_prep_2_0 for safe keeping.
2. Copy the AERS_Prep.zip file from the distribution media to:
   /u01/stage/projects
3. Change your current directory to /u01/stage/projects as follows:
   cd /u01/stage/projects/
4. Unpack the AERS_Prep.zip file into a temporary directory, for example:
   $ unzip AERS_Prep.zip -d
   /u01/stage/projects/

   The aers_ism_prep subdirectory is created.

5. Navigate to the aers_ism_prep/sigdet/db directory, for example:
   $ cd /u01/stage/projects/aers_ism_prep/sigdet/db
6. Run update_AERS_ISM_8_1_1_1_to_9_0.sql script in SQL*PLUS providing AERS Signal Management configuration Id as parameter:
   $ sqlplus <signal database account name>@<TNS_name> @update_AERS_ISM_8_1_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. You will be prompted to enter the Oracle Empirica Signal account password.

7. Inspect update_AERS_ISM_8_1_1_1_to_9_0.log log file for possible errors.

Note:

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