Upgrading the schema (Oracle)

Applies to: On premises

Run the script to upgrade the database schema.

Before you begin

  • The Oracle database server is running. All other OpenPages® servers are stopped.
  • The JAVA_HOME system variable is defined.
  • The ORACLE_HOME system variable is defined.
  • The op-database-product-upgrade.sh|.bat preupgrade script completed successfully.

Procedure

  1. Log on to the Oracle database server computer as the OpenPages application user, opuser.
  2. Go to the /OP_<version>_Main/OP_<version>_Configuration/Database/ORACLE/UPGRADE_SCRIPTS directory.
  3. Verify that you have execute permission on the scripts in the UPGRADE_SCRIPTS directory and its subdirectories.
  4. Open the sql-wrapper.sql file. Verify that the values are suitable for your environment.
  5. Run the following command:
    • On Linux®:
      ./op-database-product-upgrade.sh upgrade '<op_schema_owner_password>'
    • Windows:
      op-database-product-upgrade.bat upgrade "<op_schema_owner_password>"
    Note: Quotation marks are required around a password only if the password contains special characters. See Special characters in passwords.
  6. Verify that the return code is 0, indicating success.

    You can also check the log file, op-database-product-upgrade.upgrade.*.log.

What to do next

Ask your database administrator to run the post-upgrade DBA script.