当前位置:Gxlcms > mysql > Oracle11.2.0.3ORA-12012ORA-29280ORA-06512

Oracle11.2.0.3ORA-12012ORA-29280ORA-06512

时间:2021-07-01 10:21:17 帮助过:27人阅读

Oracle 11.2.0.3 ORA-12012 ORA-29280 ORA-06512

问题现象:

db alert日志中出现如下告警信息:

Errors in file/app/Oracle/diag/rdbms/cctv/CCTV2/trace/CCTV2_j000_1370.trc:

ORA-12012: error on auto execute of job"ORACLE_OCM"."MGMT_CONFIG_JOB_2_2"

ORA-29280: invalid directory path

ORA-06512: at "ORACLE_OCM.MGMT_DB_LL_METRICS", line 2436

ORA-06512: at line 1

环境:

错误分析:

这个计划任务所报的错误。

的,该帐户默认是锁定状态。

ORACLE_OCM

This account contains the instrumentation for configuration collection used by the Oracle Configuration Manager.

Oracle Configuration Manager Installation and Administration Guide

问题原因:

日志中报错。

SQL>set line 300

SQL>col owner for a8

SQL>col DIRECTORY_NAME for a25

SQL>COL DIRECTORY_PATH for a60

SQL> select * from dba_directories whereDIRECTORY_NAME like '%OCM_CONFIG%';

OWNER DIRECTORY_NAME DIRECTORY_PATH

-------- -------------------------------------------------------------------------------------

SYS ORACLE_OCM_CONFIG_DIR /app/oracle/product/11.2.0/db_1/ccr/state

SQL>

,所以才会报我们上面看到这个错误。

相关阅读:

ORA-01172、ORA-01151错误处理

ORA-00600 [2662]错误解决

ORA-01078 和 LRM-00109 报错解决方法

ORA-00471 处理方法笔记

ORA-00314,redolog 损坏,或丢失处理方法

ORA-00257 归档日志过大导致无法存储的解决办法

linux

人气教程排行