Oracle 11g報錯"ORA-12012: error on job ORACLE_OCM.MGMT_CONFIG_JOB_2_1"

feelpurple發表於2016-11-07
OracleError
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章