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

oracle技术专栏收录该内容

14 篇文章

订阅专栏

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

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 1
has errors
---------- Wed Feb 24 05:07:30 2010
Errors in file /u01/oracle/admin/chnldb/udump/chnldb1_ora_1749452.trc:
ORA-00600: 錗-^FM-^E镸-^CㄩM-^TM-^Y璇唬鐮M-^A, 錗-^OM-^B鍹-^U? [13011], [3343517], [1069601037], [0], [1069601096], [3], [], []
---------- Wed Feb 24 08:45:18 2010
Global Enqueue Services Deadlock detected. More info in file
/u01/oracle/admin/chnldb/bdump/chnldb1_lmd0_603046.trc.

解决方法：
SQL> select username from dba_users;

USERNAME
------------------------------------------------------------
SCOTT
ORACLE_OCM
ANONYMOUS
CTXSYS
MDSYS
OUTLN
ORDPLUGINS
SI_INFORMTN_SCHEMA
OLAPSYS
XDB
ORDSYS

USERNAME
------------------------------------------------------------
WMSYS
DIP
TSMSYS
MDDATA
DMSYS
EXFSYS
SYSTEM
SYS
PATROL
DBADM
COGNOS

USERNAME
------------------------------------------------------------
SYSMAN
DSG
CHANNEL
CHANNELDEV
TRAINAPP
QCOAGT
TRAIN
CHANNELAPP
PERFSTAT
MGMT_VIEW
DBSNMP

33 rows selected.

SQL> desc dba_sys_privs;
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
GRANTEE                                   NOT NULL VARCHAR2(30)
PRIVILEGE                                 NOT NULL VARCHAR2(40)
ADMIN_OPTION                                       VARCHAR2(3)
SQL>select privilege from dba_sys_privs where grantee='ORACLE_OCM';

PRIVILEGE
--------------------------------------------------------------------------------
SELECT ANY DICTIONARY

SQL> grant execute on UTL_FILE to oracle_ocm;
SQL> grant execute on DBMS_SCHEDULER to oracle_ocm;
SQL> ALTER PACKAGE ORACLE_OCM.MGMT_DB_LL_METRICS COMPILE;
SQL> ALTER PACKAGE ORACLE_OCM.MGMT_CONFIG COMPILE;