Tuesday, 12 November 2013

Database Vault Uninstall and Reinstall

Database Vault Uninstall

Step 1:
 Stop all service of database
 - Database
 - ASM if available
 - Listener
    lsnrctl stop
 - Cluster
 - Dbconsole
    emctl stop dbconsloe

Step 2:
 Disable Database Vault
    cd $ORACLE_HOME/rdbms/lib
    make -f ins_rdbms.mk dv_off ioracle


Step 3:
 Verify Database Vault Status
 - Start Database and services
 - Query Database
   (SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';
    Output: FALSE)

Step 4:
 Disable Database Vault tiggers
 - Connect as sys
    alter trigger dvsys.dv_before_ddl_trg disable;
    alter trigger dvsys.dv_after_ddl_trg disable;

   
Step 5:
 Identify DV_OWNER and DV_ACCTMGR users
 - Query Database
   (select unique GRANTEE from dba_role_privs where GRANTED_ROLE in ('DV_ACCTMGR','DV_OWNER') and grantee <> 'DVSYS';)

Step 6:
 Remove database vault using dvremov.sql
 - Execute update statement
   (update dvsys.config$ set status=0;
    commit;
)
 - Set recyclebin to OFF
   (alter system set recyclebin=off scope=spfile;
    shutdown immediate;
    startup;
)
 - Execute dvremov.sql and remove DV_OWNER and DV_ACCTMGR users
    (@?/rdbms/admin/dvremov.sql;
    drop user &DV_OWNER cascade;
    drop user &DV_ACCTMGR cascade;
)
 - Set recyclebin to ON
    (alter system set recyclebin=on scope=spfile;
    shutdown immediate;
    startup;
)

Database Vault Reinstall

Step 1:  Stop all service of database
 - Database
 - ASM if available
 - Listener
    lsnrctl stop
 - Cluster
 - Dbconsole
    emctl stop dbconsloe

Step 2:
 Enable Database Vault
    cd $ORACLE_HOME/rdbms/lib
    make -f ins_rdbms.mk dv_on ioracle


Step 3:
 Verify Database Vault Status
 - Start Database and services
 - Query Database
   (SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';
    Output: TRUE)
Step 4:
  Follow the below screenshots



SCREENSHOT
Description


















No comments:

Post a Comment