Update the OpenPages database manually (Oracle)

When you install a fix pack, you can choose to update the database by running scripts.

Use this option if you do not want to enter DBA credentials in the installation app.

It is not mandatory to update the database server manually. You can use the OpenPages® installation app to update the database automatically, if you prefer.

You must run all of the upgrade scripts in sequence to upgrade the database schema.

Two of the scripts require DBA privileges: a pre-upgrade script and a post-upgrade script. If you have DBA privileges, you can run all of the scripts. If you do not have DBA privileges, contact your database administrator.

A schema user can run the scripts that do not require DBA privileges.

Note: Fix pack 8.1.0.1 drops and re-creates a number of constraints and indexes. As a result, the database update scripts might take longer to run.

Pre-upgrade step – Requires DBA privileges: During this step, your database administrator runs a script to prepare the database for the upgrade.
You need SYSDBA privileges to run this script.
Validate the pre-upgrade step: During this step, you run a script to verify that the pre-upgrade DBA script completed successfully and that the database schema is ready for the upgrade.
Upgrade step: During this step, you run a script to upgrade the schema. The script determines the current version of the database schema, and then runs the upgrade scripts required to upgrade the schema to the fix pack version.
Post upgrade step – Requires DBA privileges: During this step, your database administrator runs a script to complete the database upgrade and to set database tuning parameters.
You need SYSDBA privileges to run this script.
Validate the post-upgrade step: During this step, you run a script to validate the post-upgrade DBA step.