Enabling the database vault in 11gR2

       1.       Shut down the database .

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

       2.       Stop the dbconsole

[oracle@vm1 ~]$ emctl stop dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0

Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.

https://vm1:5500/em/console/aboutApplication

Stopping Oracle Enterprise Manager 11g Database Control ...

all attemps to stop oc4j failed... now trying to kill 9

 ...  Stopped.

        3.       Stop the listener

[grid@vm1 ~]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 05-MAR-2014 10:10:46

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

The command completed successfully

For Oracle RAC installations, shut down each database instance as follows:

$ srvctl stop database -d db_name

      4.       Turn ON the database vault

[oracle@vm1 ~]$ cd $ORACLE_HOME/rdbms/lib

[oracle@vm1 lib]$ make -f ins_rdbms.mk dv_on lbac_on ioracle

[oracle@vm1 lib]$ make -f ins_rdbms.mk dv_on lbac_on ioracle

/usr/bin/ar d /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/libknlopt.a kzvndv.o

/usr/bin/ar cr /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/libknlopt.a /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/kzvidv.o

/usr/bin/ar cr /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/libknlopt.a /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/kzlilbac.o

chmod 755 /u01/app/oracle/product/11.2.0/dbhome_1/bin

……………………………………….

……………………………………………………..

………………………………………………………………..

test ! -f /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle ||\

           mv -f /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracleO

mv /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/oracle /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle

chmod 6751 /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle

      5.       Start the database, dbconsole and listener.

SQL> startup

ORACLE instance started.

Total System Global Area  263049216 bytes

Fixed Size                  2227456 bytes

Variable Size             226493184 bytes

Database Buffers           29360128 bytes

Redo Buffers                4968448 bytes

Database mounted.

Database opened.

[grid@vm1 ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-MAR-2014 16:32:20

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Starting /u01/app/grid/product/11.2.0/grid/bin/tnslsnr: please wait...

[oracle@vm1 lib]$ emctl start dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0

Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.

https://vm1:5500/em/console/aboutApplication

Starting Oracle Enterprise Manager 11g Database Control .... started.

------------------------------------------------------------------

Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/vm1_noasmdb/sysman/log

For Oracle RAC installations, restart each database instance as follows:

$ srvctl start database -d db_name

6.       Check for the status.

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

PARAMETER                           VALUE

----------------------------------- ----------------------------------------------------------------

Oracle Database Vault               TRUE