Apply upgrade scripts to Oracle Empirica Signal 8.x or 9.0.x schemas (upgrade only)

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

1. Navigate to the Database/Signal8.1.1.1 directory, for example:

   $ cd /u01/stage/Database/Signal8.1.1.1

2. If you are upgrading from version 8.0:
   1. As the Oracle Empirica Signal database user, execute the update_8_0_to_8_1.sql script to update the schema from 8.0 to 8.1.

      For example, for Oracle Empirica Signal 8.0:

      $ sqlplus webvdme@<TNS_NAME> @update_8_0_to_8_1.sql

      A password prompt appears.

   2. Enter the Oracle Empirica Signal database account password.
3. If you are upgrading from version 8.0.x or 8.1.0.x:
   1. As the Oracle 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.

   2. Enter the Oracle Empirica Signal database account password.
4. If you're upgrading from 8.0.x, 8.1.0.x, 8.1.1, or 8.1.1.1:
   1. Navigate to the database, for example:
      $ cd /u01/stage/Database/Signal9.0.0.0
   2. As the SYS database user, execute the update_8_1_1_to_9_0.sql script to update the schema from 8.1.x to 9.0, for example:
      $ sqlplus SYS@<TNS_NAME> as sysdba @update_8_1_1_to_9_0.sql

      A password prompt appears.

   3. Enter the SYS database account password.
   4. When the second password prompt appears, enter the Oracle Empirica Signal database account password.

   Note:

   If you upgrade from Oracle Empirica Signal 8.0.1, an error message appears when ALTER TABLE PASSWORD_HISTORY is attempted, because the column being added already exists in the table. You can ignore this message.
5. Perform the following steps to upgrade database schemas to 9.1.0.
   1. Navigate to the Database folder, for example:
      $ cd /u01/stage/Database
   2. Using a text editor, open the update_9_0_to_9_1.sql file.
   3. Update WEBVDME_ACCOUNT and tablespace_name to actual value.
   4. As the SYS database user, execute the update_9_0_to_9_1.sql script to update the schema from 9.0.x to 9.1, for example:
      $ sqlplus SYS@<TNS_NAME> as sysdba @update_9_0_to_9_1.sql

      A password prompt appears.

   5. Enter the SYS database account password.
   6. Once the execution completed, verify update_9_0_to_9_1.log.
6. If you use the Oracle Empirica Topics feature, to upgrade the Oracle Empirica Topics schema:
   1. Using a text editor, open the update_twc_9_0_to_9_1.sql file.
   2. Update WEBVDME_ACCOUNT and TOPIC_WORKFLOW_USER.
   3. As the SYS database user, execute the update_twc_9_0_to_9_1.sql script to update TWC schema from 9.0.x to 9.1, for example:
      $ sqlplus SYS@<TNS_NAME> as sysdba @update_twc_9_0_to_9_1.sql

      A password prompt appears.

   4. Enter the SYS database account password.
   5. Once the execution completed, verify update_twc_9_0_to_9_1.log.
   6. If multiple TOPIC_WORKFLOW accounts are configured, repeat from Step b, by updating TOPIC_WORKFLOW_USER for each account.