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
