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;
版权声明：本文为博主原创文章，未经博主允许不得转载。
页:
[1]