Tuesday, April 28, 2020

Disable Oracle Label Security (OLS) 11gR1


Check Oracle Label Security OLS Status
=============================

SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Label Security';

Disable Oracle Label Security OLS
=============================

sqlplus sys as sysoper
Enter password: password

SQL> SHUTDOWN IMMEDIATE
SQL> EXIT

$ emctl stop dbconsole
$ lsnrctl stop [listener_name]
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk lbac_off
cd $ORACLE_HOME/bin
relink all

No comments:

Post a Comment