Oracle 11g报错"ORA-12012: error on job ORACLE_OCM.MGMT_CONFIG_JOB_2

Oracle 11g报错"ORA-12012: error on job ORACLE_OCM.MGMT_CONFIG_JOB_2_1"

向右看齐 2024-04-18 00:18 163阅读 0赞

Oracle 11g报错
21953 ORA-12012: error on auto execute of job “ORACLE_OCM”.”MGMT_CONFIG_JOB_2_1”
21954 ORA-29280: invalid directory path
21955 ORA-06512: at “ORACLE_OCM.MGMT_DB_LL_METRICS”, line 2436
21956 ORA-06512: at line 1
21957 Sun Nov 06 06:35:13 2016
21958 Starting ORACLE instance (normal)

ORACLE_OCM用户主要是用于Oracle配置管理器，当发出SR请求时，它和数据库实例配置相联系，把配置信息发送给Oracle供分析。

SQL> select owner,job_name,state,enabled,start_date,end_date from dba_scheduler_jobs where owner = ‘ORACLE_OCM’;

OWNER JOB_NAME STATE ENABL START_DATE END_DATE
-————- ——————————- ———————- ——- —————————————————- —————————————————-
ORACLE_OCM MGMT_CONFIG_JOB SCHEDULED TRUE
ORACLE_OCM MGMT_STATS_CONFIG_JOB SCHEDULED TRUE 29-SEP-15 02.55.00.449417 PM +02:00

停止job

SQL> exec dbms_scheduler.disable(‘ORACLE_OCM.MGMT_CONFIG_JOB’);

PL/SQL procedure successfully completed.

SQL> exec dbms_scheduler.disable(‘ORACLE_OCM.MGMT_STATS_CONFIG_JOB’);

PL/SQL procedure successfully completed.

SQL> select owner,job_name,state,enabled,start_date,end_date from dba_scheduler_jobs where owner = ‘ORACLE_OCM’;

OWNER JOB_NAME STATE ENABL START_DATE END_DATE
-————- ——————————- ———————- ——- —————————————————- —————————————————-
ORACLE_OCM MGMT_CONFIG_JOB DISABLED FALSE
ORACLE_OCM MGMT_STATS_CONFIG_JOB DISABLED FALSE 29-SEP-15 02.55.00.449417 PM +02:00

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2127903/，如需转载，请注明出处，否则将追究法律责任。

转载于//blog.itpub.net/26506993/viewspace-2127903/