Thursday, July 5, 2012

Disable Oracle Database Vault

Recently I needed to upgrade one of our 11gR1 DB ( to 11gR2( I have my binaries for R2 in place and backup of the DB was also done. 
So I fired up DBUA from R2 Oracle Home, but hit the error as follows

database vault option is enabled in oracle home. This option must be disabled for upgrade

So I was left with choice to disable the DB Vault option as follows
[oracle@appsdbnode db_1]$ sqlplus "/ as sysdba"
SQL> shut immediate;

-- For Oracle RAC installations, run these commands on all nodes.
[oracle@appsdbnode db_1]$ pwd
[oracle@appsdbnode db_1]$ cd rdbms/lib/
[oracle@appsdbnode lib]$ make -f dv_off
/usr/bin/ar cr /u01/app/oracle/visr12/db/tech_st/11.1.0/rdbms/lib/libknlopt.a /u01/app/oracle/visr12/db/tech_st/11.1.0/rdbms/lib/kzvndv.o
[oracle@appsdbnode lib]$ cd ../../bin/
[oracle@appsdbnode bin]$ ./relink all
writing relink log to: /u01/app/oracle/visr12/db/tech_st/11.1.0/install/relink.log

-- If you have DB in place with DV option enabled you need to disable it as follows.

[oracle@appsdbnode bin]$dvca -action disable 
  -oh /u01/app/oracle/product/11.2.0/db_1
  -service visr12
  -instance visr12
  -dbname visr12 
  -owner_account dvowner 
  -logfile dvcalog.txt 
Enter SYS password: sys_password
Enter owner password: dvowner_password

Once done you can now connect to your DB to check if the Vault option is disabled or not. 
If successfully done, the value should be FALSE