Install an interactive VAERS 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 VAERS_Prep_3_0_0_x_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 VAERS_Prep_3_0_0_x_xxx.zip file into a temporary directory, for example:
   $ unzip VAERS_Prep_3_0_0_x_xxx.zip -d /u01/stage/projects/

   The vaers_ism_prep subdirectory is created.

5. Navigate to the vaers_ism_prep subdirectory, for example:
   $ cd /u01/stage/projects/vaers_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 vaers_ism_prep/sigdet, for example:
   $ cd /u01/stage/projects/vaers_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>@<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 VAERS 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 VAERS Signal Mgmt project already exists:

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

    You can disregard the error.

12. If you have existing bi-weekly VAERS (WVAERS) datasets imported or installed locally, perform the following step to differentiate bi-weekly VAERS (WVAERS) from monthly (VAERS).
    • As the SYS or SYSTEM user, execute the update_wvaers_source.sql script, for example:

      $ sqlplus SYSTEM/<system password>@<TNS_Name> @db/update_wvaers_source.sql