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

19 comments:

  1. After growing underground for 13 to 17 years, Coach Outlet a brood will come out in one of 15 specific regions of the United States. This year, males Coach Handbags Clearance have already started calling out to females in southwest Virginia, Coach Outlet Store West Virginia and parts of North Carolina, the mating grounds of Brood IX.Typically around Yeezy Boost 350 this time, Day starts getting calls for advice from nervous brides and grooms fearful that cicadas will drop in Champagne flutes or disrupt outdoor ceremonies with their loud buzzing, he said. (The Ray Ban Glasses sound is made only by the male, New Jordan Shoes 2020 which has a membrane in Ray Ban Outlet its abdomen Yeezy Discount that vibrates to attract females.)But with the coronavirus limiting gatherings, this could be a good time for Southerners to sit in their backyards and marvel at the creatures, Day said.

    ReplyDelete