ORA-12012: error on auto execute of job “ORACLE_OCM”.”MGMT_CONFIG_JOB_2_1″

Posted: October 15, 2013 in ASM

Got the following error on a 11.2.0.3 RAC database, after investigation it turns out to be a Oracle Configuration Manager (OCM) error as we don’t use this product its safe to  just disable the jobs

Error

Sun Oct 13 06:00:01 2013
Errors in file /u01/app/oracle/diag/rdbms/test/TEST1/trace/TEST1_j004_20464.trc:
ORA-12012: error on auto execute of job “ORACLE_OCM”.”MGMT_CONFIG_JOB_2_1″
ORA-29280: invalid directory path
ORA-06512: at “ORACLE_OCM.MGMT_DB_LL_METRICS”, line 2436
ORA-06512: at line 1
Sun Oct 13 06:00:23 2013

Fix

Login to any instance in the cluster as sysdba and run

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.

Oracle Reference documents – 1453959.1

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s