Re-enabling Database Vault

In this recipe, you will enable previously disabled 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 Enable, then click on continue in a small pop-up window (see Figures 39, 40).

   

   Figure 39

   

   Figure 40

   Or

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

      SQL> EXEC DBMS_MACADM.ENABLE_DV;
   

2. 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;
   

3. Confirm that Database Vault is enabled:

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