Tuesday, October 23, 2012

How to Disable Oracle Label Security



-bash-3.2$ chopt disable lbac

Writing to /opt/oracle/112/product/11.2.0/dbhome_1/install/disable_lbac.log...

/usr/bin/make -f /opt/oracle/112/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk lbac_off ORACLE_HOME=/opt/oracle/112/product/11.2.0/dbhome_1

/usr/bin/make -f /opt/oracle/112/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/opt/oracle/112/product/11.2.0/dbhome_1


restart oracle dbs ( otherwise you will get Warning)

WARNING: Oracle executable binary mismatch detected.
 Binary of new process does not match binary which started instance
issue alter system set "_disable_image_check" = true to disable these messages

deinstall LBACSYS with sqlplus

sysdba

select object_type,count(*) from dba_objects where owner='LBACSYS'  group by object_type;



@?/rdbms/admin/catnools.sql


done

 -------------------- SCRIPT

select object_type,count(*) from dba_objects where owner='LBACSYS'  group by object_type;


prompt disable
prompt !host chopt disable lbac
prompt alter system set "_disable_image_check" = true scope=memory;;
prompt @?/rdbms/admin/catnools.sql

prompt enable
prompt !host chopt enable lbac
prompt @?/rdbms/admin/catols.sql

prompt INVALID YES NO?

select object_type,object_name from dba_objects where owner='LBACSYS' and status='INVALID';


prompt @?/rdbms/admin/utlrp

15 comments: