Thursday, July 5, 2012

Disable Oracle Database Vault



Recently I needed to upgrade one of our 11gR1 DB (11.1.0.7) to 11gR2(11.2.0.1). 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
/u01/app/oracle/product/11.2.0/db_1
[oracle@appsdbnode db_1]$ cd rdbms/lib/
[oracle@appsdbnode lib]$ make -f ins_rdbms.mk 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. 
SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';
If successfully done, the value should be FALSE