oracle+packages+权限,oracle权限处理一例

Errors in file /oracle/admin/mydb1/bdump/mydb1_j003_5927.trc:

ORA-12012: error on auto execute of job 23452

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

SQL> grant execute on UTL_FILE to oracle_ocm;

SQL> grant execute on DBMS_SCHEDULER to oracle_ocm;

SQL> ALTER PACKAGE oracle_ocm.MGMT_DB_LL_METRICS compile;

SQL> ALTER PACKAGE oracle_ocm.mgmt_config compile;