Validating the pre-upgrade DBA step (Oracle)

Applies to: On premises

Run the script to validate the pre-upgrade DBA steps.

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.

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.
  4. Open the sql-wrapper.sql file. Verify that the values are suitable for your environment.
  5. Run the following command:
    • Windows:
      op-database-product-upgrade.bat preupgrade "<op_schema_owner_password>"
    • On Linux®:
      ./op-database-product-upgrade.sh preupgrade '<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 script completed successfully.
    Look for the following message: Status:Success or a return code of 0.

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

What to do next

Run the script to upgrade the database schema.