Oracle 10.2.0.4 (64bit) , Linux AS 5.3 64 bit , 4节点RAC系统
节点 1, 2, 3 用于生产系统 , alert log 基本正常 。
节点 4 用于报表查询系统 , alert log 中有报错信息,发生问题时候节点4的负载较高,但是也不是最高。
备注: 这里通过将节点 4 上的remote_listener置为空,将1,2,3 和 节点4 分开,不存在连接1,2,3的session
连接到节点4 的情况, 同样节点4上的session 也不会因为负载连接到其他用于生产系统的节点 。
节点1 上的alert log :
Tue Oct 5 10:05:59 2010
Thread 1 advanced to log sequence 23897 (LGWR switch)
Current log# 31 seq# 23897 mem# 0: /ocfs_ctrl_redo/mxdell/redo31_a.log
Current log# 31 seq# 23897 mem# 1: /ocfs_data/mxdell/redo31_b.log
Tue Oct 5 10:17:45 2010
Trace dumping is performing id=[cdmp_20101005101745]
Tue Oct 5 10:36:00 2010
Thread 1 advanced to log sequence 23898 (LGWR switch)
Current log# 32 seq# 23898 mem# 0: /ocfs_ctrl_redo/mxdell/redo32_a.log
Current log# 32 seq# 23898 mem# 1: /ocfs_data/mxdell/redo32_b.log
节点2 上的alert log :
Tue Oct 5 10:17:42 2010
Thread 3 advanced to log sequence 23412 (LGWR switch)
Current log# 40 seq# 23412 mem# 0: /ocfs_ctrl_redo/mxdell/redo40_a.log
Current log# 40 seq# 23412 mem# 1: /ocfs_data/mxdell/redo40_b.log
Tue Oct 5 10:17:45 2010
Trace dumping is performing id=[cdmp_20101005101745]
Tue Oct 5 10:40:22 2010
Thread 3 advanced to log sequence 23413 (LGWR switch)
Current log# 41 seq# 23413 mem# 0: /ocfs_ctrl_redo/mxdell/redo41_a.log
Current log# 41 seq# 23413 mem# 1: /ocfs_data/mxdell/redo41_b.log
节点4 上的alert log :
Tue Oct 5 10:17:30 2010
Thread 4 advanced to log sequence 16150 (LGWR switch)
Current log# 48 seq# 16150 mem# 0: /ocfs_ctrl_redo/mxdell/redo48_a.log
Current log# 48 seq# 16150 mem# 1: /ocfs_data/mxdell/redo48_b.log
Tue Oct 5 10:17:44 2010
Errors in file /u01/product/admin/mxdell/udump/mxdell4_ora_375.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:sskgxp_select failed with status: 3
ORA-27301: OS failure message: No such process
ORA-27302: failure occurred at: skgxpvfymmtu
ORA-27303: additional information: MTU could not be verified. Did not receive valid message.
Tue Oct 5 10:17:45 2010
Trace dumping is performing id=[cdmp_20101005101745]
Tue Oct 5 10:47:30 2010
Thread 4 advanced to log sequence 16151 (LGWR switch)
Current log# 43 seq# 16151 mem# 0: /ocfs_ctrl_redo/mxdell/redo43_a.log
Current log# 43 seq# 16151 mem# 1: /ocfs_data/mxdell/redo43_b.log
Tue Oct 5 11:17:30 2010
Thread 4 advanced to log sequence 16152 (LGWR switch)
Current log# 44 seq# 16152 mem# 0: /ocfs_ctrl_redo/mxdell/redo44_a.log
Current log# 44 seq# 16152 mem# 1: /ocfs_data/mxdell/redo44_b.log
节点4上的trace 文件 (截断) :
/u01/product/admin/mxdell/udump/mxdell4_ora_375.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /u01/product/oracle
System name: Linux
Node name: mxrac04
Release: 2.6.18-128.el5
Version: #1 SMP Wed Dec 17 11:41:38 EST 2008
Machine: x86_64
Instance name: mxdell4
Redo thread mounted by this instance: 4
Oracle process number: 0
Unix process pid: 375, image: oracle@mxrac04
SKGXPVFYMMTU: select failed 3.
*** 2010-10-05 10:17:44.470
SKGXPVFYMMTU: Could not create context which satisfies the minimum
MTU requirement of 32768 bytes
struct ksxpp * ksxppg_ [0x68a7b38, 0x1a307610) = 0x1a307608
Dump of memory from 0x000000001A307608 to 0x000000001A308750
01A307600 1A309680 00000000 [..0.....]
01A307610 1A30AC20 00000000 00000000 00000000 [ .0.............]
01A307620 00000000 00000000 00000000 00000000 [................]
Repeat 269 times
01A308700 00000000 00000000 96F9AFAA 0000012C [............,...]
01A308710 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
struct skgxpctx * ksxp_osdctx [0x1a307608, 0x1a309688) = 0x1a309680
Dump of memory from 0x000000001A309680 to 0x000000001A30AC20
01A309680 00000000 00000000 00000000 00000000 [................]
01A309690 052FC280 00000000 068966E0 00000000 [../......f......]
01A3096A0 00000000 00000000 00000000 00000000 [................]
01A3096B0 A0EEAA04 00002B07 000000DA 00000000 [.....+..........]
01A3096C0 A0EEAA14 00002B07 000000DB 00000000 [.....+..........]
01A3096D0 A0EEAA2C 00002B07 000000DC 00000000 [,....+..........]
01A3096E0 A0EEAA48 00002B07 000000DD 00000000 [H....+..........]
01A3096F0 A0EEAA68 00002B07 000000DE 00000000 [h....+..........]
01A309700 A0EEAA88 00002B07 000000DF 00000000 [.....+..........]
01A309710 A0EEAAB0 00002B07 000000E3 00000000 [.....+..........]
01A309720 A0EEAADC 00002B07 000000E4 00000000 [.....+..........]
01A309730 A0EEAAF0 00002B07 00000000 00000000 [.....+..........]
01A309740 A0EEAB08 00002B07 00000000 00000000 [.....+..........]
01A309750 000005DC 00000000 00000001 00000001 [................]
01A309760 31687465 00000000 00000000 00000000 [eth1............]
01A309770 00000000 00000000 00000000 00000000 [................]
Repeat 14 times
01A309860 0E01A8C0 00000000 00000000 00000000 [................]
01A309870 00000000 00000000 00000000 00000000 [................]
Repeat 153 times
01A30A210 00000000 00000000 00010006 000005DC [................]
01A30A220 00000000 000003E8 000003E8 00000000 [................]
01A30A230 0000003C 00000005 00000400 0000012C [<...........>01A30A240 1A30B720 00000000 1A30B720 00000000 [ .0..... .0.....]
01A30A250 00000400 00000001 00000000 00000000 [................]
01A30A260 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
01A30A280 4CAB4F9D 00000000 0007244B 00000000 [.O.L....K$......]
01A30A290 00000000 00000000 00000064 00000000 [........d.......]
01A30A2A0 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
01A30A2E0 00000000 00000000 1A30A2E8 00000000 [..........0.....]
01A30A2F0 1A30A2E8 00000000 1A30A2F8 00000000 [..0.......0.....]
01A30A300 1A30A2F8 00000000 1A30A308 00000000 [..0.......0.....]
01A30A310 1A30A308 00000000 1A30A318 00000000 [..0.......0.....]
01A30A320 1A30A318 00000000 1A30A328 00000000 [..0.....(.0.....]
01A30A330 1A30A328 00000000 1A30A338 00000000 [(.0.....8.0.....]
01A30A340 1A30A338 00000000 00000010 00000000 [8.0.............]
01A30A350 00000000 00000000 00000000 00000000 [................]
Repeat 19 times
01A30A490 00000000 00000000 1A30A498 00000000 [..........0.....]
01A30A4A0 1A30A498 00000000 00000000 7A9F91A8 [..0............z]
01A30A4B0 00000000 00000007 00000000 A4080002 [................]
01A30A4C0 0E01A8C0 00000000 00000000 0E01A8C0 [................]
01A30A4D0 0000A408 00000000 00000000 00000000 [................]
01A30A4E0 00000000 00000000 00000000 00000000 [................]
Repeat 115 times
kgefec: fatal error 0
*** 2010-10-05 10:17:44.471
ksedmp: internal or fatal error
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:sskgxp_select failed with status: 3
ORA-27301: OS failure message: No such process
ORA-27302: failure occurred at: skgxpvfymmtu
ORA-27303: additional information: MTU could not be verified. Did not receive valid message.
Current SQL information unavailable - no session.
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
7FFF09BE0000 ? 7FFF09BE0060 ?
7FFF09BDFFA0 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
7FFF09BE0000 ? 7FFF09BE0060 ?
7FFF09BDFFA0 ? 000000000 ?
ksfdmp()+21 call ksedmp() 000000003 ? 000000001 ?
7FFF09BE0000 ? 7FFF09BE0060 ?
查询Metalink 发现是Bug :
Bug 7331323 - ORA-27302 "failure occurred at: skgxpvfymmtu" in RAC [ID 7331323.8] | |||||
| |||||
修改时间 17-AUG-2010 类型 PATCH 状态 PUBLISHED |
Bug 7331323 ORA-27302 "failure occurred at: skgxpvfymmtu" in RAC
This note gives a brief overview bug 7331323.
The content was last updated on: 17-AUG-2010
Click here for details of each of the sections below.
This bug is marked as an important issue.
There are additional notes on this bug in Note:746888.1
Affects:
Product (Component) Oracle Server (Rdbms) Range of versions believed to be affected Versions >= 10.2.0.4 Versions confirmed as being affected
- 11.1.0.6
- 10.2.0.4
Platforms affected Generic (all / most platforms affected)
It is believed to be a regression in default behaviour thus:
Regression introduced in 10.2.0.4
Regression introduced in 11.1.0.6
Fixed:
This issue is fixed in
- 10.2.0.5 (Server Patch Set)
Symptoms: | Related To: |
|
|
Description
This problem is introduced in 10.2.0.4 and 11.1.0.6. In a RAC environment errors of the form. below may be seen causing process failures: ORA-00603: ORACLE server session terminated by fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:sskgxp_select failed with status: 3 ORA-27301: OS failure message: No such process ORA-27302: failure occurred at: skgxpvfymmtu ORA-27303: additional information: MTU could not be verified. Did not receive valid message. See Note:746888.1 for more details.
Further details on this issue can be found in Note:746888.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:7331323 (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-675480/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-675480/