Thursday, August 5, 2010

11g Upgrade Failed with Incorrect Deduction of Vault

ScreenHunter_0049 2010-08-05 10.35.gif

DBUA reported on a database where I have not configured Oracle Database Vault when upgrading from 10.2.0.4 to 11.1.0.7.

Here is a workaround that will enable you to get rid of this error.
Please make a note that this is possible only if you do not have enabled Oracle Database Vault and that is verified.

To verify
Check is if Data Vault is enabled or not. Data Vault is disabled if following is TRUE
$ cd $ORACLE_HOME/rdbms/lib
$ ar -t libknlopt.a | grep dv
kzvndv.o <<<<<< Shows DV is disabled

In my case the above was verified and I did not have Vault.

Workaround
1. Cleanly shutdown and take complete cold backup of the 10.2 database
2. Startup (in upgrade mode) and shutdown the 10.2 database (prior to upgrade) using 11.1 binaries
-- login to 11.1 Oracle Home environment
% export ORACLE_SID=<10.2 database SID>
% sqlplus / as sysdba
SQL> startup upgrade pfile="<10.2 database pfile>"
SQL> select * from v$option where PARAMETER='Oracle Database Vault';
-- ensure that DV option is FALSE
SQL> shutdown immediate

3. Now retry the DBUA
% dbua

Once database is opened (in upgrade mode) and closed using 11.1 binaries, DBUA stops showing this error.

Note: The above action plan was provided by Oracle Support. So before executing it please cross check with Support.

Popular Posts