OCM job was failing with below error at alert log:
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
ORA-06512: at "ORACLE_OCM.MGMT_DB_LL_METRICS", line 2436
ORA-06512: at line 1
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 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;
But
if OCM is in use to upload collection to My Oracle Support then it needs
reinstrumenting the database.
1.
export ORACLE_HOME=
export ORACLE_SID=
2. Remove the OCM configuration in the database:
cd $ORACLE_HOME/ccr/bin
./configCCR -r
3.
Configure the OCM configuration in the database:
./configCCR -a
4. Instrument the Database:
cd /ccr/admin/scripts
./installCCRSQL.sh collectconfig -s
-r SYS
5. Run a manual collection:
cd $ORACLE_HOME/ccr/bin
./emCCR collect
