How To Uninstall Or Reinstall Database Vault in 11g

	Goal

	Solution

	References

Applies to:

Oracle Database Vault – Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]

Information in this document applies to any platform.

Checked for relevance on 07-Jan-2013

Goal

How to uninstall or reinstall Database Vault in 11g?

Solution

1. Stop Database Control, the listener and the database

1. Disable Database Vault :

Unix :

Windows:

1. Start the listener and the database.

1. Disable the Database Vault triggers :

1. Identify the DV_OWNER and DV_ACCTMGR users that were configured:

1. Run script dvremov.sql as SYSDBA after setting parameter recyclebin to OFF:

After this only DVSYS and DVF users and DV roles are removed, but the security admin and account manager accounts are not removed as they are considered custom database accounts. They have to be removed manually, use the usernames obtained in step 5. (take care not to drop any users that you may have granted these roles manually):

conn / as sysdba

drop user &DV_OWNER cascade;

drop user &DV_ACCTMGR cascade;

dvremov.sql just removes the DV components and does not affect in any way OLS.

1. Run dbms_network_acl_admin.drop_acl(In 11gR2 this is included in dvremov.sql) :

1. Turn on recycle bin if it was turned off before

At this stage Database Vault is removed from the database and the binaries are relinked with dv_off. If Database Vault is not needed (all you wanted to do was to remove/uninstall it) then stop here and restart the database. If Database Vault needs to be enabled then do the following:

1. Stop Database Control, listener and database.

1. Enable DV :

Unix:

Windows:

1. Start the listener and the database

1. Run DBCA again to register Database Vault. If it is not possible to run the DBCA GUI then run dbca silently:

References

NOTE:744390.1 – How To Reconfigure Database Vault in 10g

NOTE:207959.1 – All About Security: User, Privilege, Role, SYSDBA, O/S Authentication, Audit, Encryption, OLS, Database Vault, Audit Vault