Apply upgrade scripts to Empirica Signal schemas

Previous Topic

Next Topic

Book Contents

Apply upgrade scripts to Empirica Signal schemas

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

  1. Move the previous Database directory to Database_8_1 as backup. For example:

    $ mv /u01/stage/Database /u01/stage/Database_8_1

  2. Unpack the Signal-8_1_1_0_XXX-Database.zip file:
    1. Create a Database directory:

      $ mkdir /u01/stage/Database

    2. Unpack the contents of the Signal-8_1_1_0_XXX-Database.zip file into the directory, for example:

      $ unzip Signal-8_1_1_0_XXX-Database.zip -d /u01/stage/Database

  3. Navigate to the Database directory, for example:

    $ cd /u01/stage/Database

  4. As the Empirica Signal database user, execute the update_8_1_to_8_1_1.sql script to update the schema from 8.1 to 8.1.1, for example:

    $ sqlplus webvdme@<TNS_NAME> @update_8_1_to_8_1_1.sql

    A password prompt appears.

  5. Enter the Empirica Signal database account password.
Send Feedback