当前位置: 首页 > 工具软件 > osPID > 使用案例 >

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

谢同化
2023-12-01

今天在检查11g R2系统的时候,发现了alertlog中有以下的一些错误。  


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

问了问同事,发现他们早上发现有比较严重的锁表,所以有手工kill掉一些session, 查询目前的patch,发现在oracle10.2.0.1上没有这个patch no

 

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.

 

可能我们打的patch只是2010四月份的,下面的bug文章是12月份才发出来的。但是上面写了在 11.2.0.1 上已经修复,但是的确还是会报错。 

 

 

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 affectedVersions BELOW 11.2
Versions confirmed as being affected
Platforms affectedGeneric (all / most platforms affected)

Fixed:

This issue is fixed in

Symptoms:

Related To:

  • (None Specified)

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/

 类似资料: