Upgrade an Oracle external runtime database (for appliance versions earlier than 9.0.0.0)

If Oracle is the external runtime database, upgrade it after you install the appliance upgrade so that you are using the correct .sql file version. Attention: Use this task only if you have not installed v9000. The updates to the .sql file for each release are not cumulative. Therefore, depending on which version of the isam_access_control_oracle_update_v*.sql file you installed, make the following updates:

• v8011.sql not installed: First upgrade to v8011 and then to v9000.
• v8011.sql is installed: Upgrade to v9000.

Use this task to install each version we require, replacing references to isam_access_control_oracle_update_v9000.sql with the version number you are upgrading to each time, and starting with the earliest version we require.

Steps

1. Log in to the local management interface.
2. Click System > File Downloads.
3. Expand access_control > database > oracle > runtime.
4. Select isam_access_control_oracle_update_v9000.sql
5. Click Export.
6. Save the file.
7. Copy the downloaded isam_access_control_oracle_update_v9000.sql file into the Oracle home directory. For example: ORACLE_HOME=/opt/oracle/app/oracle/product/11.2.0/dbhome_1
8. Log in to SQL*Plus.
9. At the SQL prompt, run START isam_access_control_oracle_update_v9000.sql.
10. Validate the tables were successfully updated.
11. Ensure that no errors were returned during the update and log in to the database to manually check the tables exist.

Parent topic: Upgrade configuration