oracle 11g alert logo （ ospid (15270050) as a result of ORA-604）
本帖最后由 xia 于 2013-11-5 15:07 编辑环境（AIX 7.1:oracle 11.2.0.3.0：RAC）
在节点1上打开了em，平时看一下对数据库的监控状态。这几天在节点1上查看alert log 发现有一些报错，大概有两种类型，不知道该怎么处理，罗列出来，发帖求助！麻烦大家了：由于这几个trc文件的内容几乎一致，就上传了两个trc文件；
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
第一个错误我知道，ORACLE CONFIG MANAGER
你给的处理是官方建议，木有问题，不会影响你的业务。
第二个木有见过，求大神路过。 都是跟EM相关的bug，你看下官方的解释和解决方法：
"opiodr abortingprocess" Messages in Alert.Log
Bug 6377339 - Misleading alertlog message for "opiodr aborting"
Audit Network Does Not Work When notSuccessful in Oracle 11gR2
Grid Control Agent 10.2 Crashes with CoreDump if 'nscd' daemon is Hung on Linux OS
Lsnrctl Status is Failing and Alert.logShows TNS-12537 and ORA-609 opidcl aborting process unknown ospid (5420) as a result of ORA-604
我也遇到这个问题了，我现在把EM停了看看效果如何 "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)
页:
[1]