Search This Blog

Total Pageviews

Wednesday 4 December 2013

ORA-12012: error on auto execute of job ORACLE_OCM.MGMT_CONFIG_JOB_2_1 and ORA-29280: invalid directory


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


when Newly installed 11.2.0.3 database, or recently upgraded to 11.2.0.3 from an earlier release.




when not using the OCM Collector, remove the OCM objects from database:

SQL> drop user ORACLE_OCM cascade;
OCM is a standalone, separate tool and removing won't affect the database functionality.

Or could simply disable the OCM jobs by running:

exec dbms_scheduler.disable('ORACLE_OCM.MGMT_CONFIG_JOB')
exec dbms_scheduler.disable('ORACLE_OCM.MGMT_STATS_CONFIG_JOB')




Oracle DBA

anuj blog Archive