Install an interactive AERS signal configuration

Perform these steps using the non-privileged user account on the application server.

1. If it does not already exist on the Oracle Empirica Signal application server, create the following directory:
   /u01/stage/projects
2. Copy the AERS_Prep_3_0_0_1_xxx.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_3_0_0_1_xxx.zip file into a temporary directory, for example:
   $ unzip AERS_Prep_3_0_0_1_xxx.zip -d /u01/stage/projects/

   The aers_ism_prep subdirectory is created.

5. Navigate to the aers_ism_prep subdirectory, for example:
   $ cd /u01/stage/projects/aers_ism_prep
6. Execute the following command to give execute permissions to all .sh files:
   $ chmod u+x common/*.sh sigdet/*.sh site/*.sh
7. Navigate to aers_ism_prep/sigdet, for example:
   $ cd /u01/stage/projects/aers_ism_prep/sigdet
8. Execute the following command to give write permissions to the database directory:
   $ chmod u+w db
9. Execute the main_install_sigmgt.sh script to initiate the installation:
   $ ./main_install_sigmgt.sh < signal database account name gt;@<TNS_name>

   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.

10. Enter <password>, where <password> is the Oracle Empirica Signal database user account password.

    A second password prompt appears.

11. Reenter <password>.

    The database tables for the interactive AERS signal configuration are populated. The install_sigmgmt.log file is created in the sigdet/sigmgt/install/log subdirectory.

    Note:

    If you enter the password incorrectly, an error such as this appears in the install_sigmgmt.log file: Error returned from execution of "sqlplus /NOLOG @db/connect webvdme @db/fetch_next_config_id".

    If the following error message appears, the AERS SM project already exists:

    ERROR at line 1:ORA-00001: unique constraint (WEBVDME.UC_PROJECTS1) violated

    You can disregard the error.