Disable Oracle Database Vault
Recently I needed to upgrade one of our 11gR1 DB (126.96.36.199) to 11gR2(188.8.131.52). 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
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