Linux AS 5.3 64bit, Oracle 10.2.0.4 64bit , 4 Node RAC .
在其中一个平时负载比较高的节点上 alert log中发现报错信息如下, 这个节点是专用于报表查询的 ,
所以相对负载会高于其他节点 。 其他节点仅仅收到 Tue May 11 11:38:02 2010
Trace dumping is performing id=[cdmp_20100511113801] 的信息 。
节点 4 上的alert log :
Tue May 11 11:11:45 2010
Thread 4 advanced to log sequence 7945 (LGWR switch)
Current log# 45 seq# 7945 mem# 0: /ocfs_ctrl_redo/mxdell/redo45_a.log
Current log# 45 seq# 7945 mem# 1: /ocfs_data/mxdell/redo45_b.log
Tue May 11 11:38:01 2010
Errors in file /u01/product/admin/mxdell/udump/mxdell4_ora_2734.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 May 11 11:38:01 2010
Trace dumping is performing id=[cdmp_20100511113801]
Tue May 11 11:41:49 2010
Thread 4 advanced to log sequence 7946 (LGWR switch)
Current log# 46 seq# 7946 mem# 0: /ocfs_ctrl_redo/mxdell/redo46_a.log
Current log# 46 seq# 7946 mem# 1: /ocfs_data/mxdell/redo46_b.log
在其中一个平时负载比较高的节点上 alert log中发现报错信息如下, 这个节点是专用于报表查询的 ,
所以相对负载会高于其他节点 。 其他节点仅仅收到 Tue May 11 11:38:02 2010
Trace dumping is performing id=[cdmp_20100511113801] 的信息 。
节点 4 上的alert log :
Tue May 11 11:11:45 2010
Thread 4 advanced to log sequence 7945 (LGWR switch)
Current log# 45 seq# 7945 mem# 0: /ocfs_ctrl_redo/mxdell/redo45_a.log
Current log# 45 seq# 7945 mem# 1: /ocfs_data/mxdell/redo45_b.log
Tue May 11 11:38:01 2010
Errors in file /u01/product/admin/mxdell/udump/mxdell4_ora_2734.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 May 11 11:38:01 2010
Trace dumping is performing id=[cdmp_20100511113801]
Tue May 11 11:41:49 2010
Thread 4 advanced to log sequence 7946 (LGWR switch)
Current log# 46 seq# 7946 mem# 0: /ocfs_ctrl_redo/mxdell/redo46_a.log
Current log# 46 seq# 7946 mem# 1: /ocfs_data/mxdell/redo46_b.log
mxdell4_ora_2734.txt
(2010-05-12 06:43:28, Size: 1.46 MB, Downloads: 0)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-662483/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-662483/