今天在检查11g R2系统的时候，发现了ａｌｅｒｔｌｏｇ中有以下的一些错误。 问了问同事，发现他们早上发现有比较严重的锁表，所以有手工ｋｉｌｌ掉一些ｓｅｓｓｉｏｎ， 查询目前的ｐａｔｃｈ，发现在ｏｒａｃｌｅ１０．２．０．１上没有这个ｐａｔｃｈ ｎｏ ccptdb<*ccptdb*/home/oracle>$opatch lsinventory Oracle Interim Patch Installer version 11.2.0.1.3 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 -------------------------------------------------------------------------------- Oracle Database 11g 11.2.0.1.0 Patch 9352237 : applied on Fri Dec 24 08:09:58 CST 2010 Patch 8730312 : applied on Fri Dec 24 08:01:57 CST 2010 -------------------------------------------------------------------------------- OPatch succeeded. 可能我们打的ｐａｔｃｈ只是２０１０四月份的，下面的ｂｕｇ文章是１２月份才发出来的。但是上面写了在 １１．２．０．１ 上已经修复，但是的确还是会报错。 Bug 6377339 - Misleading alert log message for "opiodr aborting" [ID 6377339.8]
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
Invoking OPatch 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
Installed Top-level Products (1):
There are 1 products installed in this Oracle Home.
Interim patches (2) :
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
Unique Patch ID: 12177426
Created on 7 Feb 2010, 06:41:26 hrs PST8PDT
Bugs fixed:
8730312
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 Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in
Symptoms: |
Related To: |
|
Description
One may see misleading error messaes in alert.log which do not show the real Oracle error message triggering a process to abort. eg: The alert log may show messages like: ORA-28 : opiodr aborting process unknown ospid (21016_3086862016) which can be confusing as one may think the message for ORA-28 is the "opiodr aborting ..." text. This fix changes the format of the message to try to make it clearer. eg: With the fix the message reads: opidcl aborting process unknown ospid (32110) as a result of ORA-28
| 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