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

Edit online

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.

About this task

Attention: Use this task only if you have not installed v9000 or v1000.
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 you 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 you require.

Procedure

  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 that the tables were successfully updated.
  11. Ensure that no errors were returned during the update and log in to the database to manually check that the tables exist.