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;

         版权声明：本文为博主原创文章，未经博主允许不得转载。