- Installation and Upgrade Instructions
- Prepare the application server
- Apply upgrade scripts to Oracle Empirica Signal 8.x, 9.0.0.x, 9.1.0.x, 9.2.0.x, or 9.2.1.x schemas (upgrade only)
Apply upgrade scripts to Oracle Empirica Signal 8.x, 9.0.0.x, 9.1.0.x, 9.2.0.x, or 9.2.1.x schemas (upgrade only)
Schema upgrade is incremental. If you are upgrading from a version prior to Signal 9.2.1.x, multiple scripts need to be executed.
- If you are upgrading from version 8.x, 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 8.0:
- 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.
- Enter the Oracle Empirica Signal database account password.
- As the Oracle Empirica Signal database user, execute the
- If you are upgrading from version 8.0.x or 8.1.0.x:
- 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.
- Enter the Oracle Empirica Signal database account password.
- As the Oracle Empirica Signal database user, execute the
- If you're upgrading from 8.0.x, 8.1.0.x, 8.1.1, or 8.1.1.1:
- Navigate to the database folder, for example:
$ cd /u01/stage/Database/Signal9.0.0.0
- 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.
- Enter the SYS database account password.
- When the second password prompt appears, enter the Oracle Empirica Signal database account password.
- Navigate to the database folder, for example:
- Perform the following steps to upgrade database schemas to 9.1.0.
- Navigate to the Database folder, for example:
$ cd /u01/stage/Database/Signal9.1.0.0
- Using a text editor, open the
update_9_0_to_9_1.sql
file. - Update
WEBVDME_ACCOUNT
andtablespace_name
to actual value. - 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.
- Enter the SYS database account password.
- Once the execution completes, verify
update_9_0_to_9_1.log
.
- Navigate to the Database folder, for example:
- Perform the following steps to upgrade database schemas to 9.2.0.
- Navigate to the Database folder, for example:
$ cd /u01/stage/Database
- Using a text editor, open the
update_9_1_to_9_2.sql
file. - Update WEBVDME_USER and TOPIC_WORKFLOW_USER to actual value.
- As the SYS database user, execute the
update_9_1_to_9_2.sql
script to update the schema from 9.1.0.x to 9.2, for example:$ sqlplus SYS@<TNS_NAME> as sysdba @update_9_1_to_9_2.sql
A password prompt appears.
- Enter the SYS database account password.
- Once the execution completes, verify that there are no errors in the
log files
update_9_1_to_9_2.log
andupdate_all_smcs.log
.Note:
When verifying the logs, ignore any messages caused by dropping an object that does not exist, such as User or role 'DATA_ADMIN' does not exist.
- Navigate to the Database folder, for example:
- Perform the following steps to upgrade database schemas to 9.2.1.
- Navigate to the Database folder, for example:
$ cd /u01/stage/Database
- As the WEBVDME database user, execute the
update_9_2_to_9_2_1.sql
script to update the schema from 9.2.0.x to 9.2.1, for example:$ sqlplus webvdme@<TNS_NAME> @update_9_2_to_9_2_1.sql
A password prompt appears.
- Enter the WEBVDME database account password.
- Once the execution completes, verify that there are no errors in the
log files
update_9_2_to_9_2_1.log
andupdate_all_smcs.log
.
- Navigate to the Database folder, for example:
- Perform the following steps to upgrade database schemas to 9.2.2.
- Navigate to the Database folder, for example:
$cd /u01/stage/Database
- Using a text editor, open the
update_9_2_1_to_9_2_2.sql
file. - Update WEBVDME_USER to actual value.
- As the SYS database user, execute the
update_9_2_1_to_9_2_2.sql
to update the schema from 9.2.1.x to 9.2.2, for example:$sqlplus SYS@<TNS_NAME> as sysdba @update_9_2_1_to_9_2_2.sql
A password prompt appears.
- Enter the SYS database account password.
- Once the execution completes, verify that there are no errors in any of
the log files, such as
update_9_2_1_to_9_2_2.log.
- Navigate to the Database folder, for example:
- If you use the Oracle Empirica Topics feature, perform the following steps to upgrade the Oracle Empirica Topics schema:
- If you are upgrading from Signal 8.0.x, 8.1.x, or 9.0.x
:
- Using a text editor, open the
update_twc_9_0_to_9_1.sql
file. - Update WEBVDME_ACCOUNT and TOPIC_WORKFLOW_USER.
- 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.
- Enter the SYS database account password.
- Once the execution completed, verify
update_twc_9_0_to_9_1.log
.
- Using a text editor, open the
- If you are upgrading from Signal 8.0.x, 8.1.x, 9.0.x, or
9.1.x:
- Using a text editor, open the
update_twc_9_1_to_9_2.sql
file. - Update WEBVDME_ACCOUNT and TOPIC_WORKFLOW_USER.
- As the SYS database user, execute the
update_twc_9_1_to_9_2.sql
script to update TWC schema from 9.1.x to 9.2, for example:$ sqlplus SYS@<TNS_NAME> as sysdba @update_twc_9_1_to_9_2.sql
A password prompt appears.
- Enter the SYS database account password.
- Once the execution completed, verify
update_twc_9_1_to_9_2.log
.
- Using a text editor, open the
- If you are upgrading from Signal 8.0.x, 8.1.x, or 9.0.x
:
Parent topic: Prepare the application server