ALERT Errors in the log, such as the following :

Sun Mar 30 06:05:40 2014

Errors in file /oracle/app/oracle/diag/rdbms/zscims/zscims1/trace/zscims1_j001_15269946.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

Database version number :

Oracle Database 11g Enterprise Edition Release 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 MOS file :

"ORA-12012: error on auto execute of job ORACLE_OCM.MGMT_CONFIG_JOB_2_1" And "ORA-29280: invalid directory path" In Database AlertLog ( file ID 1453959.1)

The reason for the error is :

Newer database 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.   --- Folder does not exist

ORACLE_OCM Accounts are used to manage Oracle Configuration Manager Of . By default , The account is Expired and locked state .

The mistake is only now OracleRDBMS 11.2.0.3 Version number of ( Newly installed db, Or upgrade from another version number to 11.2.0.3 Of ). perhaps Oracle Configuration Manager The version number of is greater than 10.3.3.0.0.

To verify the OCM db directories, run as sysdba:  --- Can confirm whether the next folder does not exist through the following statement

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.



Suppose you don't have to ask MOS Upload and collect information , Can delete users ORACLE_OCM To solve , sentence :

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.

#####################################

" 10g--Version 10.2.3 to 10.3.1, Refer to MOS file :How To Manually Remove ORACLE_OCM From Database ( file ID 859113.1)

resolvent :

If you don't need to use this function , Can delete users ORACLE_OCMT And the corresponding DIRECTORY To solve . sentence :

In order to manually remove the ORACLE_OCM user and associated objects from database, run:

SQL> drop user ORACLE_OCM cascade;

SQL> drop directory ORACLE_OCM_CONFIG_DIR;

ORA-12012: error on auto execute of job "ORACLE_OCM More articles about

  1. Orace 12.2 ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_21"

    A test environment 12.2.0.1 Database background alert Keep reporting the following error messages : Errors in file /d12/app/oracle/diag/rdbms/test/test/trace/test_ ...

  2. Oracle 12.2 Report errors :ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_7458"

    alert Report errors 2019-01-12T10:10:11.499130+08:00Errors in file /u01/app/oracle/diag/rdbms/rac1/rac112/trace/ ...

  3. ORA-12012 Error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_<NN> in 12.2.0 Database

    An error is as follows :ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_88"ORA-2000 ...

  4. ORA-12012 error on auto execute of job 8887

    *** ACTION NAME:(AUTO_SPACE_ADVISOR_JOB) -- ::58.046 *** MODULE NAME:(DBMS_SCHEDULER) -- ::58.046 ** ...

  5. [ERROR] Failed to execute goal org.apache.maven.plugins:maven-install-plugin:2.3.1:

    security-sdk-1.0.jar Already in existence D:/secServerSDK-test/src/main/resources/lib Next An error is as follows : xxxxxx@xxxxxxxx /d/secSe ...

  6. [ERROR] Failed to execute goal org.apache.maven.plugins:maven-archetype-plugin:2.4:create (default-cli) on project standalone-pom: Unable to parse configuration of 3: mojo org.apache.maven.plugins:

    problem : [ERROR] Failed to execute goal org.apache.maven.plugins:maven-archetype-plugin:2.4:create (defau ...

  7. [ERROR] Failed to execute goal org.apache.maven.plugins:maven-jar-plugin:2.3.1:jar (default-jar) on

    [ERROR] Failed to execute goal org.apache.maven.plugins:maven-jar-plugin:2.3.1:jar (default-jar) on ...

  8. [ERROR] Failed to execute goal org.apache.maven.plugins:maven-war-plugin:2.2:war (default-war) on project child02

    maven Pack it up war when , Report errors : [ERROR] Failed to execute goal org.apache.maven.plugins:maven-war-plugin:2.2:war (d ...

  9. [ERROR] Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.1:compile (default-compile) on project triage: Compilation failure [ERROR] No compiler is provided in this environment.

    [ERROR] Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.1:compile (default-c ...

Random recommendation

  1. jQuery Disable or enable

    Ban :.attr("disabled","disabled"); Enable :.removeAttr("disabled");

  2. bzoj3743: [Coci2015]Kamp

    First of all, trees dp Find the answer to a point And then again dfs Change one ( Is it called root changing .. See the code for details. #include <iostream> #include <cstdio> #include &l ...

  3. c Terminal control

    #include <stdio.h> #include <termios.h> #include <stdio.h> #include <unistd.h&g ...

  4. Linux Execute multiple commands on a single command line ( Reprint )

    I think most people understand the execution of a single command , That is, to execute a command on a command line . What about executing multiple commands on one line , It's also very simple , Just add a special command symbol between the commands , What we normally use are 3 A special command symbol . 1. ...

  5. Android Some popular uses of the platform 3D Technology development lock screen

    Digression : from 2007 year android The release of the system begins , To 2008 The first mobile phone came out in , And now beat Symbian ,wm, Black mold , And then it blooms all over the place ,2013 year , Smart machines are more than functional machines ,android " . Along the way , although a ...

  6. ROS Use FAQs

    1.Q: see ros edition A: Enter... At the terminal first roscore, Open a new terminal , Input again ,rosparam list, Input again rosparam get /rosdistro, You get the version . 2.Q: Run the command $ ros ...

  7. WPF Latitude and longitude control

    1. Needs and ideas Draw a control , You can set latitude and longitude , Latitude and longitude use double Type said , Supports binding data , Data change notification . Error verification , Input calibration . The general design interface is shown in the figure below : 2. Main code The main code is computation ,double Type conversion ...

  8. 【CentOS】 Set the time to perform the task

    1.Crond Service startup status confirmation service crond status crond (pid ) を In the line ... 2. Add a new execution task crontab -e #Ansible: dnsmasq fo ...

  9. 3、 ... and 、HTTP Basic routing details

    1. The complete implementation of a request 2. Basic routing Route::get($uri,$callback); Route::post($uri,$callback); Route::put($uri,$callb ...

  10. python Anonymous functions capture variable values ( The value at execution time )