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。