Disabling Database Vault

In this recipe, you will disable Database Vault in two ways: Using Enterprise Manager 12c Cloud Control and command line.

How to do it...

1. Go to Database Vault home page of your database or pluggable database and click on Disable (see Figure 37):

   

   Figure 37

2. Click on continue in a small pop-up window (see Figure 38)

   

   Figure 38

   Or

   Connect to the database as Database Vault owner and disable it through command line:

   SQL> EXEC DBMS_MACADM.DISABLE_DV;
   

3. Connect to your database or pluggable database and restart it:

   SQL> connect / as sysdba
   SQL> alter pluggable database pdb1 close immediate;
   SQL> alter pluggable database pdb1 open;
   

4. Confirm that Database Vault is disabled:

   SQL> connect c##dbv_owner@pdb1
   
   SQL> SELECT PARAMETER, VALUE FROM V$OPTION WHERE PARAMETER = 'Oracle 
   Database Vault';
   PARAMETER                                VALUE
   ----------------------------             --------------
   Oracle Database Vault                     FALSE