ORA-04063: ORA-04063: package body "ORACLE_OCM.MGMT_DB_LL_METRICS" has errors
今天检查alter.log的时候发现错误提示：
Errors in file /u01/oracle/admin/webdata/bdump/webdata_j003_21219.trc:
ORA-12012: error on auto execute of job 54677
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
select owner,object_name,object_type from dba_objects where status='INVALID';
发现ORACLE_OCM.MGMT_DB_LL_METRICS是INVALID状态
alter package ORACLE_OCM.MGMT_DB_LL_METRICS compile body;
提示：Warning: Package body altered with compilation errors
后来网上查到是因为当初看到em上的提示撤销了execute utl_file的原因照成的
重新添加execute on utl_file
grant execute on utl_file to ORACLE_OCM;
再次编译
alter package ORACLE_OCM.MGMT_CONFIG compile;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/20777547/viewspace-1057472/ ，如需转载，请注明出处，否则将追究法律责任。
