ORA-12012: error on auto execute of job 82585
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
select * from dba_objects where status ='INVALID' 发现是invalid的.
alter PACKAGE ORACLE_OCM.MGMT_DB_LL_METRICS compile body
2 /
Warning: Package body altered with compilation errors
编译提示错误
通过PL Developer找到对像，编译提示找不到UTL_FILE.
切换到SYS用户
GRANT EXECUTE ON SYS.UTL_FILE TO "ORACLE_OCM"
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
select * from dba_objects where status ='INVALID' 发现是invalid的.
alter PACKAGE ORACLE_OCM.MGMT_DB_LL_METRICS compile body
2 /
Warning: Package body altered with compilation errors
编译提示错误
通过PL Developer找到对像，编译提示找不到UTL_FILE.
切换到SYS用户
GRANT EXECUTE ON SYS.UTL_FILE TO "ORACLE_OCM"
返回再编译ORACLE_OCM.MGMT_DB_LL_METRICS，通过OK。
本文转自 anranran 51CTO博客，原文链接:http://blog.51cto.com/guojuanjun/274031
