> 文章列表 > ORACLE_OCM.MGMT_CONFIG_JOB_2_2

ORACLE_OCM.MGMT_CONFIG_JOB_2_2

ORACLE_OCM.MGMT_CONFIG_JOB_2_2

今天巡检一套AIX上11g rac,发现有个报错

Errors in file /opt/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_j000_16777270.trc:
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

第一次遇上 ORACLE_OCM的报错,登录MOS中查找问题

Database alert_log Shows Error: ORA-12012: error on auto execute of job ORACLE_OCM.MGMT_CONFIG_JOB_2_1" And "ORA-29280: invalid directory path" (Doc ID 1615561.1)

没有按照文档操作了,直接禁止jobs了,持续观察

SQL>select * from dba_directories where DIRECTORY_NAME like '%OCM_CONFIG%';

禁用OCM的jobs,
SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_CONFIG_JOB')
SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_STATS_CONFIG_JOB')