You must complete these tasks before starting an upgrade with a database using Oracle Label Security or Oracle Database Vault.
Audit Table Preupgrade and Archive Requirements
For Oracle Database releases earlier than 12.1 using Oracle Label Security and Oracle Database Vault, you must run the OLS preprocess script before you upgrade.
If you are upgrading from a database earlier than Oracle Database release 12.1 that uses Oracle Label Security (OLS) and Oracle Database Vault, then you must first run the OLS preprocess script,
olspreupgrade.sql, to process the
aud$ table contents. The OLS upgrade moves the
aud$ table from the
SYSTEM schema to the
SYS schema. The
olspreupgrade.sql script is a preprocessing script required for this move.
olspreupgrade.sql script before upgrading is mandatory for upgrading databases earlier than Oracle Database release 12.1 that use Oracle Label Security and Oracle Database Vault. Once you have upgraded to Oracle Database release 12.1, you do not have to perform the OLS preprocessing procedure going forward to patch or upgrade the database.
olspreupgrade.sql script creates a temporary table
PREUPG_AUD$ in the
SYS schema and moves the
SYSTEM.aud$ records to
SYS.PREUPG_AUD$. As a safety measure, Oracle recommends that you archive your audit trail before running the
olspreupgrade.sql script. If Oracle Label Security is installed on your database, and you are upgrading from an earlier release, then you must run the OLS preprocess script before upgrading.
Oracle Database Vault and Upgrades of Oracle Database Release 11.2
If Oracle Label Security is installed in the earlier release that you are upgrading, then grant the DV_PATCH_ADMIN role to SYS.
If Oracle Database Vault is not installed with your release 11.2 database, then you can skip steps 2, 3, 6, and 7 in this section.
To run the OLS preprocess script on a release 11.2 database before upgrading:
Copy the following scripts script from the newly installed Oracle home to the Oracle home of the database that y0u want to upgrade:
Start SQL*Plus and connect as
DVOWNERto the database that you want to upgrade.
Run the following statement:
SQL> GRANT DV_PATCH_ADMIN to SYS;
At the system prompt, connect SYS as SYSDBA:
CONNECT SYS AS SYSDBA
Run the preprocess scripts for Data Vault
ORACLE_HOME/rdbms/admin/olspreupgrade.sql ORACLE_HOME/rdbms/admin/emremove.sql ORACLE_HOME/rdbms/admin/catnoamd.sql
You may continue to run your applications on the database while the preprocess scripts are running.
olspreupgrade.sqlcompletes its run successfully, start SQL*Plus and connect to the database as
Run the following SQL statement:
SQL> REVOKE DV_PATCH_ADMIN from SYS;
Granting the DV_PATCH_ADMIN Role to SYS for Oracle Database Vault
If Oracle Database Vault is enabled, then to perform checks for Oracle Data Vault, the upgrade process requires running three SQL scripts.
The SYS user requires the DV_PATCH_ADMIN role for the following scripts:
AMD_EXISTS CHECK runs