你好,游客 登錄 注冊 搜索
背景:
閱讀新聞

無法成功執行catalog.sql,ORA-04045 ORA-04064

[日期:2013-11-08] 來源:Linux社區  作者:leshami [字體: ]

最近同事報料,數據庫無法執行一些關于數據字典的查詢。即使是查詢dba_users都會出現錯誤。從錯誤日志來看,全部是數據字典的一些錯誤信息,而用戶數據還是ok的。Google了一下,看了看metalink,需要重建數據字典。那就執行catalog.sql吧。暈,竟然連執行這個SQL語句都報錯!數據沒有備份呢,汗!!! 如果你也是無法成功執行catalog.sql,接著往下看。


一、故障現象
--后臺alert log日志出現大量的ORA-00604,ORA-04045的錯誤信息
Tue Nov  5 14:14:02 2013
Errors in file /u02/database/XA4701/udump/XA4701_ora_30871.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS
ORA-04064: not executed, invalidated
ORA-04064: not executed, invalidated package body "LBACSYS.LBAC_EVENTS"
ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS"
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS"
ORA-06512: at line 2

--下面是trace文件的具體信息
Oracle@DBBK10P:~> more /u02/database/XA4701/udump/XA4701_ora_30871.trc
/u02/database/XA4701/udump/XA4701_ora_30871.trc
Oracle Database 10g Release 10.2.0.3.0 - 64bit Production
ORACLE_HOME = /users/oracle/OraHome10g
System name:    Linux
Node name:      linux-ejad
Release:        2.6.16.60-0.54.5-smp
Version:        #1 SMP Fri Sep 4 01:28:03 UTC 2009
Machine:        x86_64
Instance name: XA4701
Redo thread mounted by this instance: 1
Oracle process number: 22
Unix process pid: 30871, image: [email protected]

*** SERVICE NAME:(XA4701) 2013-11-05 14:14:02.308
*** SESSION ID:(1092.3369) 2013-11-05 14:14:02.308
Skipped error 604 during the execution of LBACSYS.LBAC$LOGON
*** 2013-11-05 14:14:02.326
ksedmp: internal or fatal error
ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS
ORA-04064: not executed, invalidated
ORA-04064: not executed, invalidated package body "LBACSYS.LBAC_EVENTS"
ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS"
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS"
ORA-06512: at line 2

--查詢數據字典,收到類似的錯誤
SQL> select comp_id, comp_name, version, status from dba_registry;
select comp_id, comp_name, version, status from dba_registry
                                                *
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBA_REGISTRY
ORA-04064: not executed, invalidated
ORA-04064: not executed, invalidated package body "LBACSYS.LBAC_EVENTS"
ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS"
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS"
ORA-06512: at line 2
ORA-00904: "DBMS_REGISTRY"."SCHEMA_LIST_STRING": invalid identifier

更多詳情見請繼續閱讀下一頁的精彩內容http://www.nmzech.live/Linux/2013-11/92488p2.htm

相關閱讀:

SPFILE 錯誤導致數據庫無法啟動(ORA-01565) http://www.nmzech.live/Linux/2013-08/88932.htm

ORA-01172、ORA-01151錯誤處理 http://www.nmzech.live/Linux/2013-06/86529.htm

ORA-00600 [2662]錯誤解決 http://www.nmzech.live/Linux/2013-06/86528.htm

ORA-01078 和 LRM-00109 報錯解決方法 http://www.nmzech.live/Linux/2012-07/66044.htm

ORA-00471 處理方法筆記 http://www.nmzech.live/Linux/2013-09/90017.htm

ORA-00314,redolog 損壞,或丟失處理方法 http://www.nmzech.live/Linux/2013-09/90646.htm

ORA-00257 歸檔日志過大導致無法存儲的解決辦法  http://www.nmzech.live/Linux/2013-09/90594.htm

linux
相關資訊       ORA-04045  ORA-04064 
本文評論   查看全部評論 (0)
表情: 表情 姓名: 字數

       

評論聲明
  • 尊重網上道德,遵守中華人民共和國的各項有關法律法規
  • 承擔一切因您的行為而直接或間接導致的民事或刑事法律責任
  • 本站管理人員有權保留或刪除其管轄留言中的任意內容
  • 本站有權在網站內轉載或引用您的評論
  • 參與本評論即表明您已經閱讀并接受上述條款
北京快乐8走势图彩客网