4rrr 发表于 2015-11-9 11:28:40

ORACLE_OCM.MGMT_CONFIG_JOB_2_2 ORA-12012

  alert文件报错
  ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_2"
ORA-29280: invalid directory path
ORA-06512: at "ORACLE_OCM.MGMT_DB_LL_METRICS", line 2436
ORA-06512: at line 1

select job_name,state from dba_scheduler_jobs;执行上述sql查询得到

job_name为MGMT_CONFIG_JOB的state为SCHEDULED的
  执行dbms_scheduler过程disable这个job


  SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_CONFIG_JOB');
PL/SQL procedure successfully completed

再次查询dba_scheduler_jobs,得到状态为DISABLED。





版权声明:本文为博主原创文章,未经博主允许不得转载。
页: [1]
查看完整版本: ORACLE_OCM.MGMT_CONFIG_JOB_2_2 ORA-12012