ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS

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

原创 Linux操作系统 作者:paulyibinyi 时间:2009-01-10 12:42:57 0 删除 编辑

在客户数据库中出现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

Doc ID: 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.

--> ORA-7445 core dump [zllcini...]
--> 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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    902
  • 访问量
    6565960