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

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

Navigate to the Database/Signal8.1.1.1 directory, for example:
$ cd /u01/stage/Database/Signal8.1.1.1
If you are upgrading from version 7.3.3:
1. Execute the update_7_3_3_3_to_8_0.sql script as the Empirica Signal database user, for example:
  $ sqlplus webvdme@<TNS_NAME> @update_7_3_3_3_to_8_0.sql
  
  A password prompt appears.
2. Enter the Empirica Signal database account password.
3. Review the disabled_userlist.txt file in the current directory.
  The file contains user names for accounts that are locked out of the application due to excessive failed login attempts.
4. After the upgrade is complete, you may log in to the Empirica Signal application and disable these users. For more information, see the User Guide and Online Help.
5. Create the empirica_admin account:
6. Execute the create_dbadmin_user.sql script as the Oracle sys user, for example:
  $ sqlplus sys@<TNS_NAME> as sysdba @create_dbadmin_user.sql webvdme
  
  A password prompt appears.
7. Enter the Oracle sys account password.
  A second password prompt appears.
8. Enter a password for the empirica_admin account.
9. Reenter the password.
  After a few moments, the script is completed.
10. Enter exit to change user accounts.
11. To complete the schema upgrade to version 8.0, perform the following command:
  $ sqlplus system@<TNS_NAME> @update_proxy_authentication.sql webvdme
12. When prompted, enter the Oracle system account user password.
13. After the script completes, enter exit.
14. If you use the Topics feature, update the Empirica Topics schema:
  1. Execute the update_twc_7_3_3_3_to_8_0.sql script as the topic_workflow user, for example:
    $ sqlplus topic_workflow@<TNS_NAME> @update_twc_7_3_3_3_to_8_0.sql
    
    A password prompt appears.
  2. Enter the topic_workflow account password.
    A prompt for the Empirica Signal database account appears.
  3. Enter the name of the Empirica Signal database account. For example, webvdme.
If you are upgrading from version 7.3 or 8.0:
1. As the 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 Empirica Signal 8.0:
  
  $ sqlplus webvdme@<TNS_NAME> @update_8_0_to_8_1.sql
  
  A password prompt appears.
2. Enter the Empirica Signal database account password.
If you are upgrading from version 7.3, 8.0.x or 8.1.0.x:
1. 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.
2. Enter the Empirica Signal database account password.
If you're upgrading from Signal 7.3, 8.0.x, or 8.1.0.x, or 8.1.1 or 8.1.1.1:
1. Navigate to the Database, for example:
  $ cd /u01/stage/Database
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 Empirica Signal database account password.

Note: If you upgrade from 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.