opiodr aborting process unknown ospid (21767) as a result of ORA-28

今天在检查11g R2系统的时候，发现了ａｌｅｒｔｌｏｇ中有以下的一些错误。　　 Fri Jan 07 09:01:40 2011 Thread 1 advanced to log sequence 976 (LGWR switch)   Current log# 1 seq# 976 mem# 0: /data/ccptdb/redo01a.log   Current log# 1 seq# 976 mem# 1: /data/ccptdb/redo01b.log Fri Jan 07 09:01:40 2011 Archived Log entry 757 added for thread 1 sequence 975 ID 0xbd6779f9 dest 1: Fri Jan 07 09:19:55 2011 opiodr aborting process unknown ospid (21767) as a result of ORA-28 Fri Jan 07 09:24:22 2011 opiodr aborting process unknown ospid (22359) as a result of ORA-28 Fri Jan 07 09:30:37 2011 Thread 1 advanced to log sequence 977 (LGWR switch)   Current log# 2 seq# 977 mem# 0: /data/ccptdb/redo02a.log   Current log# 2 seq# 977 mem# 1: /data/ccptdb/redo02b.log Fri Jan 07 09:30:37 2011 Archived Log entry 758 added for thread 1 sequence 976 ID 0xbd6779f9 dest 1: Fri Jan 07 09:36:02 2011 opiodr aborting process unknown ospid (23918) as a result of ORA-28 Fri Jan 07 09:37:15 2011 opidcl aborting process unknown ospid (21118) as a result of ORA-28 Fri Jan 07 09:37:15 2011 opidcl aborting process unknown ospid (19652) as a result of ORA-28 Fri Jan 07 09:45:40 2011 Thread 1 advanced to log sequence 978 (LGWR switch)   Current log# 3 seq# 978 mem# 0: /data/ccptdb/redo03a.log   Current log# 3 seq# 978 mem# 1: /data/ccptdb/redo03b.log Fri Jan 07 09:45:40 2011 Archived Log entry 759 added for thread 1 sequence 977 ID 0xbd6779f9 dest 1: Fri Jan 07 09:49:42 2011 Thread 1 advanced to log sequence 979 (LGWR switch)   Current log# 4 seq# 979 mem# 0: /data/ccptdb/redo04a.log   Current log# 4 seq# 979 mem# 1: /data/ccptdb/redo04b.log Fri Jan 07 09:49:42 2011 问了问同事，发现他们早上发现有比较严重的锁表，所以有手工ｋｉｌｌ掉一些ｓｅｓｓｉｏｎ，　查询目前的ｐａｔｃｈ，发现在ｏｒａｃｌｅ１０．２．０．１上没有这个ｐａｔｃｈ　ｎｏ   ccptdb$opatch　 lsinventory Invoking OPatch 11.2.0.1.3 Oracle Interim Patch Installer version 11.2.0.1.3 Copyright (c) 2010, Oracle Corporation.  All rights reserved. Oracle Home       : /u01/product/oracle Central Inventory : /u01/oraInventory    from           : /etc/oraInst.loc OPatch version    : 11.2.0.1.3 OUI version       : 11.2.0.1.0 OUI location      : /u01/product/oracle/oui Log file location : /u01/product/oracle/cfgtoollogs/opatch/opatch2011-01-07_15-01-24PM.log Patch history file: /u01/product/oracle/cfgtoollogs/opatch/opatch_history.txt Lsinventory Output file location : /u01/product/oracle/cfgtoollogs/opatch/lsinv/lsinventory2011-01-07_15-01-24PM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 11g                                                  11.2.0.1.0 There are 1 products installed in this Oracle Home. Interim patches (2) : Patch  9352237      : applied on Fri Dec 24 08:09:58 CST 2010 Unique Patch ID:  12250325    Created on 25 Mar 2010, 00:05:17 hrs PST8PDT    Bugs fixed:      8661168, 8769239, 8898852, 8801119, 9054253, 8706590, 8725286, 8974548      8778277, 8780372, 8769569, 9027691, 9454036, 9454037, 9454038, 8761974      7705591, 8496830, 8702892, 8639114, 8723477, 8729793, 8919682, 8818983      9001453, 8475069, 9328668, 8891929, 8798317, 8820324, 8733749, 8702535      8565708, 9036013, 8735201, 8684517, 8870559, 8773383, 8933870, 8812705      8405205, 8822365, 8813366, 8761260, 8790767, 8795418, 8913269, 8897784      8760714, 8717461, 8671349, 8775569, 8898589, 8861700, 8607693, 8642202      8780281, 9369797, 8780711, 8784929, 8834636, 9015983, 8891037, 8828328      8570322, 8832205, 8665189, 8717031, 8685253, 8718952, 8799099, 8633358      9032717, 9321701, 8588519, 8783738, 8796511, 8782971, 8756598, 9454385      8856497, 8703064, 9066116, 9007102, 8721315, 8818175, 8674263, 9352237      8753903, 8720447, 9057443, 8790561, 8733225, 9197917, 8928276, 8991997, 8837736 Patch  8730312      : applied on Fri Dec 24 08:01:57 CST 2010 Unique Patch ID:  12177426    Created on 7 Feb 2010, 06:41:26 hrs PST8PDT    Bugs fixed:      8730312   -------------------------------------------------------------------------------- OPatch succeeded.   可能我们打的ｐａｔｃｈ只是２０１０四月份的，下面的ｂｕｇ文章是１２月份才发出来的。但是上面写了在　１１．２．０．１　上已经修复，但是的确还是会报错。　     Bug 6377339 - Misleading alert log message for "opiodr aborting" [ID 6377339.8]
		Modified 03-DEC-2010     Type PATCH     Status PUBLISHED

Bug 6377339  Misleading alert log message for "opiodr aborting"

 This note gives a brief overview bug 6377339.
 The content was last updated on: 03-DEC-2010
 Click here for details of each of the sections below.

Affects:

Product (Component)	Oracle Server (Rdbms)
Range of versions believed to be affected	Versions BELOW 11.2
Versions confirmed as being affected	11.1.0.7 11.1.0.6
Platforms affected	Generic (all / most platforms affected)

Fixed:

This issue is fixed in

11.2.0.1 (Base Release)

Symptoms:	Related To:
(None Specified)	Miscellaneous

Description

HOOKS LIKELYAFFECTS XAFFECTS_11.1.0.6 XAFFECTS_V11010006 AFFECTS=11.1.0.6 XAFFECTS_11.1.0.7 XAFFECTS_V11010007 AFFECTS=11.1.0.7 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_MISC MISC FIXED_11.2.0.1

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.

References

Bug:6377339 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-683439/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-683439/