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)
- 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:
No comments:
Post a Comment