Saturday, March 9, 2013

Step By Step Install Database Vault 11g

I talked before about how to install Oracle Database Vault 10g But now i will talk about 11g and how to install it ?

in database 11g database vault installation become more easier, all you have to do is check the box to install that option and even if you forgot that you can install it later by run script

the below is screen shot for the installation for database 11g , the idea is to see where to choose Database Vault features:







If you check the below screen you see that in "Select Option" you can choose Database Vault and while installation is running it will be installed :


the installation will remain in normal procedure , If you want to check it's installed or not you can go with v$option : 


SQL> select * from v$option where parameter ='Oracle Database Vault';
PARAMETER                                                        VALUE
------------------------------- --------------------------------
Oracle Database Vault                                            FALSE

to enable database vault make sure database , dbconsole and listener are shutdown:

[oracle@prim u01]$ cd /u01/app/oracle/product/11.2.0/db_1/rdbms/lib/
[oracle@prim lib]$ make -f ins_rdbms.mk dv_on lbac_on ioracle



SQL> select * from v$option where parameter ='Oracle Database Vault';
PARAMETER                                                        VALUE
----------------------------------------------------------------
Oracle Database Vault                                            TRUE

Please notice that i use Redhat in windows you need to rename some files read Oracle Documentation.

To disable Database Vault the same thing but :
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dv_off
cd $ORACLE_HOME/bin
relink all

thank you 
Osama mustafa 

2 comments:

  1. I want to know how to conduct a draft database vault. What are the precautions to be observed before installation and after installing conserning rights and profiles of users.I would like if possible to have scripts to perform these tasks.
    My email: diabyanas@yahoo.fr
    Please Help.

    ReplyDelete
  2. Thanks for sharing the information

    For more info : Oca Certification

    ReplyDelete