oracle 11g alert logo （ ospid (15270050) as a result of ORA-604）

xia

环境（AIX 7.1:oracle 11.2.0.3.0：RAC）
在节点1上打开了em，平时看一下对数据库的监控状态。这几天在节点1上查看alert log 发现有一些报错，大概有两种类型，不知道该怎么处理，罗列出来，发帖求助！麻烦大家了：由于这几个trc文件的内容几乎一致，就上传了两个trc文件；

portaldb1_j000_9830558.rar (700 Bytes, 下载次数: 881)

2013-11-5 10:26 上传

点击文件名下载附件

portaldb1_j000_11534368.rar (704 Bytes, 下载次数: 898)

2013-11-5 10:26 上传

点击文件名下载附件

F
ri

第一种类型：

Thu Oct 31 22:00:03 2013
Errors in file /oracle/diag/rdbms/portaldb/portaldb1/trace/portaldb1_j000_9830558.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



Nov 01 22:00:03 2013
Errors in file  /oracle/diag/rdbms/portaldb/portaldb1/trace/portaldb1_j000_11534368.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



Sat Nov 02 06:00:01 2013
Errors in file /oracle/diag/rdbms/portaldb/portaldb1/trace/portaldb1_j002_17629262.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


Sun Nov 03 06:00:02 2013
Errors in file /oracle/diag/rdbms/portaldb/portaldb1/trace/portaldb1_j000_17301864.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


Mon Nov 04 22:00:01 2013
Errors in file /oracle/diag/rdbms/portaldb/portaldb1/trace/portaldb1_j001_17891670.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

这样的报错类型下面两个页面有介绍：

https://blogs.oracle.com/UPGRADE/entry/upgrade_to_11_2_0
http://www.xifenfei.com/forum/accident/ora-12012-error-on-auto-execute-of-job-oracle_ocm-mgmt_config_job_2_1

########################
B. 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本身的bug引起的，是这样么？

Archived Log entry 3806 added for thread 1 sequence 1889 ID 0x279002d6 dest 1:
Sun Nov 03 09:44:06 2013
opidcl aborting process unknown ospid (15270050) as a result of ORA-604
Sun Nov 03 09:44:20 2013
opidcl aborting process unknown ospid (12845348) as a result of ORA-604
Sun Nov 03 09:52:08 2013
opidcl aborting process unknown ospid (12779948) as a result of ORA-604
Sun Nov 03 10:12:30 2013


Sun Nov 03 17:40:07 2013
opidcl aborting process unknown ospid (14745978) as a result of ORA-28
Sun Nov 03 17:40:07 2013
opidcl aborting process unknown ospid (18874562) as a result of ORA-28
Sun Nov 03 17:40:07 2013
opidcl aborting process unknown ospid (12386312) as a result of ORA-28
Sun Nov 03 17:40:07 2013
opidcl aborting process unknown ospid (14418056) as a result of ORA-28
Sun Nov 03 17:42:28 2013

whutabs

第一个错误我知道，ORACLE CONFIG MANAGER

你给的处理是官方建议，木有问题，不会影响你的业务。

第二个木有见过，求大神路过。

lunar

都是跟EM相关的bug，你看下官方的解释和解决方法：
"opiodr abortingprocess" Messages in Alert.Log [ID 1230858.1]
Bug 6377339 - Misleading alertlog message for "opiodr aborting" [ID 6377339.8]
Audit Network Does Not Work When notSuccessful in Oracle 11gR2 [ID 1241325.1]
Grid Control Agent 10.2 Crashes with CoreDump if 'nscd' daemon is Hung on Linux OS [ID 430200.1]
Lsnrctl Status is Failing and Alert.logShows TNS-12537 and ORA-609 [ID 950135.1]

dywjzh

opidcl aborting process unknown ospid (5420) as a result of ORA-604
我也遇到这个问题了，我现在把EM停了看看效果如何

psufnxk2000

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