Oracle Read – Oracle Blogs Aggregator

If the package MGMT_DB_LL_METRICS under schema ORACLE_OCM  in 10gR2 database has invalid body and compilation gives the following result – SQL> alter package ORACLE_OCM.MGMT_DB_LL_METRICS compile body; Warning: Package Body altered with compilation errors. SQL> show errors No errors. ORACLE_OCM needs following privileges to be granted in addition – SQL> grant execute on UTL_FILE to oracle_ocm; [...]