30 January 2014

Step by Step to Enable/Disable the Oracle Lable Security

How to Enable/Disable the Oracle Lable Security:


SQL> select INSTANCE_NAME, HOST_NAME, STARTUP_TIME, STATUS, to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') as current_date from gv$instance;

INSTANCE_NAME
----------------
HOST_NAME
----------------------------------------------------------------
STARTUP_TIME       STATUS       CURRENT_DATE
------------------ ------------ -----------------------------
PROD
hostname.domain.com
12-JAN-14          OPEN         29-JAN-2014 14:06:31


SQL> SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Oracle Label Security';

VALUE
----------------------------------------------------------------
FALSE

SQL> exit

[orprod@##### trace]$ chopt enable lbac

Writing to /u01/PROD/oracle/db/tech_st/11.2.0/db_1/install/enable_lbac.log...
/usr/bin/make -f /u01/PROD/oracle/db/tech_st/11.2.0/db_1/rdbms/lib/ins_rdbms.mk lbac_on ORACLE_HOME=/u01/PROD/oracle/db/tech_st/11.2.0/db_1
/usr/bin/make -f /u01/PROD/oracle/db/tech_st/11.2.0/db_1/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/u01/PROD/oracle/db/tech_st/11.2.0/db_1

[orprod@##### trace]$ chopt disable lbac

Writing to /u01/PROD/oracle/db/tech_st/11.2.0/db_1/install/disable_lbac.log...
/usr/bin/make -f /u01/PROD/oracle/db/tech_st/11.2.0/db_1/rdbms/lib/ins_rdbms.mk lbac_on ORACLE_HOME=/u01/PROD/oracle/db/tech_st/11.2.0/db_1
/usr/bin/make -f /u01/PROD/oracle/db/tech_st/11.2.0/db_1/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/u01/PROD/oracle/db/tech_st/11.2.0/db_1

[orprod@##### trace]$sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 29 14:15:25 2014

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining and Real Application Testing options

SQL> SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Oracle Label Security';

VALUE
----------------------------------------------------------------
TRUE

SQL>

No comments: