ORA-12012 ,ORA-04063的解决方法
2009-02-26 11:59
Errors in file /oracle/admin/mydb1/bdump/mydb1_j003_5927.trc:
ORA-12012: error on auto execute of job 23452
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
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;
|
原因造成可能是以下处理
revoke execute on utl_file from public;
本文转自 jxwpx 51CTO博客，原文链接：http://blog.51cto.com/jxwpx/322884，如需转载请自行联系原作者
