Apply upgrade scripts to Empirica Signal schemas
Perform these steps using the non-privileged user account on the application server.
- Move the previous Database directory to Database_8_1_1 as backup. For example:
$ mv /u01/stage/Database /u01/stage/Database_8_1_1
- Unpack the Signal-8_1_1_1_XXX-Database.zip file:
- Create a Database directory:
$ mkdir /u01/stage/Database
- Unpack the contents of the Signal-8_1_1_1_XXX-Database.zip file into the directory, for example:
$ unzip Signal-8_1_1_1_XXX-Database.zip -d /u01/stage/Database
- Create a Database directory:
- Navigate to the Database directory, for example:
$ cd /u01/stage/Database
- As the sys user, execute the update_8_1_1_to_8_1_1_1.sql script to update the schema from 8.1.1 to 8.1.1.1, for example:
$ sqlplus sys@<TNS_NAME> as sysdba @update_8_1_1_to_8_1_1_1.sql
A password prompt appears.
- Enter the sys account password.
A second password prompt appears.
- Enter the Empirica Signal database user password.