ORACLE_OCM.MGMT_CONFIG_JOB_2_2网站首页 学无止境

ORACLE_OCM.MGMT_CONFIG_JOB_2_2

bestsun999 2023-06-08 00:00:03

简介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')

风语者！平时喜欢研究各种技术，目前在从事后端开发工作，热爱生活、热爱工作。