ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS

paulyibinyi發表於2009-01-10
Error

在客戶資料庫中出現alert log中出現過以下錯誤:

記錄下 解決這個錯誤有可能的幾種方法:

1:ORA-04045

ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
 
shutdown immediate;
startup migrate;
alter view lbacsys.lbac$all_table_policies compile;
alter package lbacsys.lbac_events compile body;
shutdown immediate;
startup;
 
2:

ORA-07445 [zllcini] or ORA-04045 in a Database with OLS Set to FALSE

轉自metalink

: Note:233110.1 Type: BULLETIN
Last Revision Date: 10-APR-2003 Status: PUBLISHED


Problems Description
--------------------

You may get OLS related errors in a database where the Oracle Label Security 
option was not installed.
   
  --&gt ORA-7445 core dump [zllcini...]
  --&gt ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS

Oracle Label Security was added to V$OPTION in 9.2.0.1 so additionally you can
check in a 9.2.0.X database with a query on V$OPTION that OLS is not installed:

  SQL> select * from v$option where parameter = 'Oracle Label Security';

  PARAMETER                 VALUE
  ---------------------     -------------------------------------
  Oracle Label Security     FALSE


1) Core Dump in zllcini
   --------------------
  
   ORA-07445: exception encountered: core dump [zllcini()+186] [SIGSEGV] 
             [Address not mapped to object] [0xC] [] []

   Current SQL statement for this session:
   BEGIN
      LBACSYS.lbac_events.logon(dbms_standard.login_user);
     END;
   ----- PL/SQL Call Stack -----
     object      line  object
     handle    number  name
   0x599ffb54       521  package body LBACSYS.LBAC_CACHE
   0x59ce5d94        82  package body LBACSYS.LBAC_EVENTS
   0x59a05a74         2  anonymous block

   Typical Call Stack Trace :

   zllcini spefcmpa spefmccallstd pextproc peftrusted psdexsp rpiswu2
   psdextp pefccal pefcal pevm_FCAL pfrrun peicnt 

2) ORA-4045 related to LBACSYS.LBAC_EVENTS
   ---------------------------------------

   ORA-00604: error occurred at recursive SQL level 1
   ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS
   ORA-06508: PL/SQL: could not find program unit being called
   ORA-06512: at line 2
   ORA-06508: PL/SQL: could not find program unit being called
   ORA-06512: at line 2

Solution Description
--------------------

1. Install Oracle Label Security with the Oracle Universal Installer
2. Run $ORACLE_HOME/rdbms/admin/catnools.sql script. to disable OLS
3. Optionally de-install 'The Label Security' software




Explanation
-----------
The Oracle Universal Installer may install OLS components in some cases:
patchset apply


 

                                                    

                                        

                    

                                                    來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7199859/viewspace-536280/，如需轉載，請註明出處，否則將追究法律責任。
                                            


                




相關文章