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

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
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google