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

20 comments:

  1. Replies
    1. Great Article Cyber Security Projects projects for cse Networking Security Projects JavaScript Training in Chennai JavaScript Training in Chennai The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  2. 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