Database Vault Setup and Configuration
Summery:
1. Pre check
2. Stop
Services
3. Enable Database Vault link product
4. Database Vault Installation / configuration with dbca
5. Database
Vault Console Login
Disable Database
Vault
1.
Pre-check
Database Vault Configurations
Normally Database Vault should not be installed, and you
can confirm it like:
SQL > SELECT * FROM V$OPTION WHERE
PARAMETER = 'Oracle Database Vault';
PARAMETERS VALUE
-----------------------------------------------------------------
Oracle Database Value FALSE
The
make command enables both Oracle
Database Vault and Oracle Label Security.
You must enable Oracle Label Security before you can use
Database Vault.
Ø Oracle Label Security
SQL > SELECT * FROM V$OPTION WHERE
PARAMETER = 'Oracle Label Security';
PARAMETERS VALUE
-----------------------------------------------------------------
Oracle Label Security FALSE
2.
Stop
Services
Ø To
install it Stop listener, Stop listener, Stop database, Stop database console
$ lsnrctl stop
listener_name
$ sqlplus / as sysdba
SQL> shu immediate
$emctl stop dbconsole
$emctl
stop dbconsole: if you have already configured otherwise you may skip this in
my case I don’t have Oracle Enterprise Express / manager, so I will install EM along
with DV
3. Enable Database Vault Link Product
Enable Database Vault link product with following commands
ð Make sure all services stopped then proceed following
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk dv_on lbac_on ioracle
$ sqlplus / as sysdba
Enter password: password
SQL> STARTUP
SQL> EXIT
$ lsnrctl start [listener_name]
4. Database Vault Installation /
configuration with $ dbca
ð Make sure you have an
entry in /etc/oratab for your
database unless option are not accessible.
ð Please check
“Database Vault and label parameter it will be true now After linking” to check
please follow Step#1
ð Login database
machine from oracle user and run
ð $ dbca
Image: 01
Select on Configure Database Option
click Next
Image: 02
Click on Database on which you want to Configure
In my case just have one database named "dbvault'
Click Next
Image: 03
If you have already Configured Enterprise manager then unchecked
Click Next
Image: 04
Click Next
- Enter User name for Database Vault Owner
- Like: DVOWNER and DVMGR. In my case is dvo and dva
- Enter password for both user
- Click Next
Image: 05
Image: 06
Click Next
Image: 07
Click Next
Image: 08
click OK
Image: 09
click OK
Image: 10
Waiting until complete
Image: 11
Click Yes
1.
Database
Vault Console Login
ð Open Browser
ð
Type
or past url
ð Enter user name dvo
Image: 12
Console
DVA =>
DVOWNER User
DVA =>
DVACCOUNTMANAGER
Ø Home Page
Image: 13
Admin Page
1.
Disable
Database Vault
To
disable Database Vault the same thing but you should Follow:
ð Stop
listener
ð Shutdown
database
ð Stop
dbconsole
$ cd
$ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk dv_off lbac_off ioracle
Thank you
No comments:
Post a Comment