ORA-04063解决方法

最新推荐文章于 2024-09-26 17:13:45 发布

原创

最新推荐文章于 2024-09-26 17:13:45 发布 · 1.3w 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #file #2010 #null #sql #c

博客内容涉及了在Oracle数据库中遇到的ORA-04063错误，该错误与ORACLE_OCM.MGMT_DB_LL_METRICS包有关。博主检查了错误日志，并提供了详细的解决步骤，包括查看dba_users、dba_sys_privs，然后为ORACLE_OCM用户授予UTL_FILE和DBMS_SCHEDULER的执行权限，最后重新编译了受影响的包。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.alert.log check
---------- Tue Feb 23 05:05:46 2010
Errors in file /u01/oracle/admin/chnldb/udump/chnldb1_ora_1376882.trc:
ORA-00600: 錗-^FM-^E镸-^CㄩM-^TM-^Y璇唬鐮M-^A, 錗-^OM-^B鍹-^U? [13011], [3343517], [1069601037], [0], [1069601096], [17], [], []
---------- Tue Feb 23 05:05:50 2010
Errors in file /u01/oracle/admin/chnldb/udump/chnldb1_ora_1556622.trc:
ORA-00600: 錗-^FM-^E镸-^CㄩM-^TM-^Y璇唬鐮M-^A, 錗-^OM-^B鍹-^U? [kdsgrp1], [], [], [], [], [], [], []
---------- Tue Feb 23 09:17:53 2010
Global Enqueue Services Deadlock detected. More info in file
/u01/oracle/admin/chnldb/bdump/chnldb1_lmd0_603046.trc.
---------- Tue Feb 23 22:00:01 2010
Errors in file /u01/oracle/admin/chnldb/bdump/chnldb1_j000_786544.trc:
ORA-12012: error on auto execute of job 4247977
ORA-04063: ORA-04063: package body "ORACLE_OCM.MGMT_DB_LL_METRICS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "ORACLE_OCM.MGMT_DB_LL_METRICS"
ORA-06512: at line