DBMS_MACADM Package to Disable / Enable Database Vault in Oracle 12c

advertisements

_____________________________________________________________________________________________________________________

SQL Query to Check Database Vault is enable or not.

SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';

PARAMETER            VALUE                    CON_ID

---------------------- ------------------------ ----------

Oracle Database Vault  TRUE                     0

Disabling Steps:

Step 1. Connect as DVOWNER user and execute the package.

SQL> conn DVOWNER/install_1

Connected.

SQL> EXEC DBMS_MACADM.DISABLE_DV;

PL/SQL procedure successfully completed.

SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';

PARAMETER           VALUE                    CON_ID

---------------------- ------------------------ ----------

Oracle Database Vault  TRUE                     0

Step 2. Bounce the database – Connect sys as sysoper

SQL> SQL> conn sys as sysoper;

Enter password:

Connected.

SQL> shut immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Database mounted.

Database opened.

SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';

PARAMETER           VALUE                    CON_ID

---------------------- ------------------------ ----------

Oracle Database Vault  FALSE                    0

Enabling Steps:

Step 1. Connect as DVOWNER user and execute the package.

SQL> conn DVOWNER/install_1

Connected.

SQL> EXEC DBMS_MACADM.ENABLE_DV;

PL/SQL procedure successfully completed.

SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';

PARAMETER             VALUE                    CON_ID

---------------------- ------------------------ ----------

Oracle Database Vault  FALSE                    0

Step 2. Bounce the database – Connect sys as sysoper

SQL> SQL> conn sys as sysoper;

Enter password:

Connected.

SQL> shut immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Database mounted.

Database opened.

SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';

PARAMETER             VALUE                    CON_ID

---------------------- ------------------------ ----------

Oracle Database Vault  TRUE                     0

_____________________________________________________________________________________________________________________

Website Stats