Error On Auto Execute Of Job Oracle_ocm . Mgmt_config_job_2_1
Contents |
Oracle İntroduction · Leave a comment Got the following error on a 11.2.0.3 RAC database, after investigation it turns out to be a Oracle what is oracle_ocm mgmt_config_job Configuration Manager (OCM) error as we don’t use this product
Ora-12012 Ora-06512
its safe to just disable the jobs Errors in file /u01/app/oracle/diag/rdbms/misdev/MISDEV1/trace/MISDEV1_j001_113131.trc: ORA-12012: error on auto execute of
Oracle_ocm User
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 Solution: oracle@bakuexa1dbadm01:/u01/app/oracle/diag/rdbms/misdev/MISDEV1/trace$ sqlplus "/ as sysdba"; SQL*Plus: Release 11.2.0.3.0 Production on
Ora 12012 Error On Auto Execute Of Job Oracle_ocm Mgmt_config_job_2_2
Thu Dec 18 09:28:03 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> select name from gv$database; NAME --------- MISDEV MISDEV SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_CONFIG_JOB'); ora-12012 error on auto execute of job sys PL/SQL procedure successfully completed. SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_STATS_CONFIG_JOB'); PL/SQL procedure successfully completed. Oracle Reference documents – 859113.1 Share post:Share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Google+ (Opens in new window)Click to share on Twitter (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Reddit (Opens in new window)Click to share on Tumblr (Opens in new window)Click to email (Opens in new window)Click to print (Opens in new window)Like this:Like Loading... Related Anar GodjaevBaku, Azerbaijan+994552509150 Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using your Twitter account. (LogOut/Change) You are commenting using your Facebook account. (LogOut/Change) You are commenting using your Google+ account. (LogOut/Change) Cancel Connecting to %s Notify me of ne
a comment 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 dbms_scheduler to access the directory location where the OCM data is written . my oracle support 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 https://anargodjaev.wordpress.com/2014/12/18/ora-12012-error-on-auto-execute-of-job-oracle_ocm-mgmt_config_job_2_1-ora-29280-invalid-directory-path/ Share post:Share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Google+ (Opens in new window)Click to share on Twitter (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Reddit (Opens in new window)Click to share on Tumblr (Opens in new window)Click to email (Opens in new window)Click to https://anargodjaev.wordpress.com/2013/12/27/ora-12012-error-on-auto-execute-of-job-oracle_ocm-mgmt_config_job_2_1/ print (Opens in new window)Like this:Like Loading... Related Anar GodjaevBaku, Azerbaijan+994552509150 Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using your Twitter account. (LogOut/Change) You are commenting using your Facebook account. (LogOut/Change) You are commenting using your Google+ account. (LogOut/Change) Cancel Connecting to %s Notify me of new comments via email. Notify me of new posts via email. ← Check Asm Disks Tuning SGA → I’M SPEAKING AT TROUG IN TURKEY , ORACLE DATABASE VAULT I’M SPEAKING AT ORACLE DAY IN AZERBAIJAN 2015 Anar Godjaev, Senior Oracle DBA . Exadata successful projects / 12 February 2015 I'm speaking at " Oracle Database Vault" Oracle Day in Azerbaijan 2014 Search Blog Stats 375,394 View Categories Azərbaycanca Materiallar (26) Oracle İntroduction (720) Script (322) Türkçe Dökümanlar (77) Oracle Mimarisi (3) Uncategorized (9) Archives October 2016(1) September 2016(1) August 2016(7) July 2016(3) June 2016(4) May 2016(2) April 2016(7) March 2016(7) February 2016(28) January 2016(24) December 2015(
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 Database version: Oracle Database 11g Enterprise Edition Release http://www.programering.com/a/MTN5IDNwATY.html 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0 Production TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3.0 - Production ################# Refer to the MOS documentation: "ORA-12012: error on auto execute of job ORACLE_OCM.MGMT_CONFIG_JOB_2_1" And "ORA-29280: invalid directory path" In Database AlertLog (document ID 1453959.1) The error reason is: Newer database error on releases are automatically instrumented for OCM collections. But here, the OCM instrumentation job is trying to write to a "state" directory which doesn'T yet exists. - the directory does not exist The ORACLE_OCM account is used to manage Oracle Configuration Manager. By default, this account is Expired and locked state. This error occurs only in the OracleRDBMS 11.2.0.3 error on auto Version (new installation of DB, or from the other version upgrade to 11.2.0.3), or Oracle Configuration version of the Manager is greater than 10.3.3.0.0. To verify the OCM db directories, Run as sysdba: - through the following statement to confirm if the directory does not exist SQL>select * from dba_directories where DIRECTORY_NAME like '%OCM_CONFIG%'; MGMT_DB_LL_METRICS wants to write to ORACLE_OCM_CONFIG_DIR2, which is not created by the built-in instrumentation scripts. If you do not need to gather information upload to MOS, you can delete a user ORACLE_OCM to solve, statement: 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. ##################################### If 10g--Version 10.2.3 to 10.3.1, refer to the MOS documentation: How To Manually Remove ORACLE_OCM From Database (document ID 859113.1) Solution: If do not need to use this feature, you can delete the user ORACLE_OCMT and the corresponding DIRECTORY address, statement: In order to manually remove the ORACLE_OCM user an