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

Errors in file $ORA_BASE/diag/rdbms/oastdb/oastdb1/trace/oastdb1_j001_22085770.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
Tue May 22 22:15:12 2012


Following errors in the alert.log file:

ORA-12012: error on auto execute of job “ORACLE_OCM”.”MGMT_CONFIG_JOB_2_1?
ORA-29280: invalid directory path

This messages happen because of the OCM collection database job is unable to access the directory location where the OCM data is written .

you do not use OCM delete the OCM configuration from the database:

Log in to your database as user SYS and drop-cascade user ORACLE_OCM:
SQL> DROP USER ORACLE_OCM CASCADE;

If you using OCM to upload collection to My Oracle Support  please refer to note [ID 1378564.1 to re instrument your database


Ora-12012: Error On Auto Execute Of Job "Oracle_ocm"."Mgmt_config_job_2_1" [ID 1378564.1]
      Modified 13-DEC-2011     Type PROBLEM     Status PUBLISHED    

In this Document
  Symptoms
  Cause
  Solution

Applies to:
Oracle Configuration Manager - Version: 10.0.0 and later   [Release: and later ]
Information in this document applies to any platform.
Symptoms

Following errors in the alert.log file:

ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_1"
ORA-29283: invalid file operation
Cause

The CM database job is out of sync with the OCM



Solution

This messages happen because of the OCM collection database job is unable to access the directory location where the OCM data is written .


If you using OCM to upload collection to My Oracle Support please re instrument the database:

1. export ORACLE_HOME=<path to the database home>
    export ORACLE_SID=<Database SID>

2.  Please remove the OCM configuration in the database:

     cd $ORACLE_HOME/ccr/bin
     ./configCCR -r

3. Please configure the OCM configuration in the database:

    ./configCCR -a <CSI> <MyOracleSupport ID>

4.  Instrument the Database:

     cd /ccr/admin/scripts
     ./installCCRSQL.sh collectconfig -s <SID> -r SYS

5.  Run a manual collection:

    cd $ORACLE_HOME/ccr/bin
    ./emCCR collect

If you do not use OCM delete the OCM configuration from the database:

Log in to your database as user SYS and drop-cascade user ORACLE_OCM:
SQL> DROP USER ORACLE_OCM CASCADE;