ITPub博客

首页 > 数据库 > Oracle > Oracle 11g报错"ORA-12012: error on job ORACLE_OCM.MGMT_CONFIG_JOB_2_1"

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

原创 Oracle 作者:feelpurple 时间:2016-11-07 11:14:21 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博客 ” ,链接:https://blog.itpub.net/26506993/viewspace-2127903/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-08-01

  • 博文量
    404
  • 访问量
    1673977