一次oracle 節點重啟問題的定位

流浪的野狼發表於2015-03-10
Oracle
告警日誌錯誤：
Tue Mar 10 21:48:29 2015
SKGXP:[110ab7ca8.1]{-}: WARNING: Failed to set buffer limit on IPC interconnect socket
SKGXP:[110ab7ca8.1]{-}: Oracle requires that the socket receive buffer size be tunable up to 2048 KB.
Please make sure the kernel parameter which limits the receive socket space set by 
applications (i.e. SO_RCVBUF) is at least that value.



Errors in file /oracle/app/db/diag/rdbms/hrprd/hrprd1/trace/hrprd1_dbw6_548954.trc  (incident=545050):
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:select (rcv) timed out failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: skgxpvfynet
Incident details in: /oracle/app/db/diag/rdbms/hrprd/hrprd1/incident/incdir_545050/hrprd1_dbw6_548954_i545050.trc
Tue Mar 10 21:48:56 2015
Dumping diagnostic data in directory=[cdmp_20150310214856], requested by (instance=1, osid=548954 (DBW6)), summary=[incident=545050].
opidrv aborting process DBW6 ospid (548954) as a result of ORA-603
Tue Mar 10 21:48:57 2015
Process DBW6 died, see its trace file
USER (ospid: 647266): terminating the instance due to error 443
Instance terminated by USER, pid = 647266


問題：該節點伺服器經常重啟。
在MOS上查了下有如下解釋與解決方法：

WARNING: Failed to set buffer limit on IPC interconnect socket (文件 ID 1552336.1) 		轉到底部轉到底部

In this Document

Symptoms
Cause
Solution


APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

SYMPTOMS

The alert.log reports the following warning:

 

SKGXP:[ffffffff7a614c88.1]{-}: WARNING: Failed to set buffer limit on IPC interconnect socket
SKGXP:[ffffffff7a614c88.1]{-}: Oracle requires that the socket receive buffer size be tunable up to 2048 KB.
Please make sure the kernel parameter which limits the receive socket space set by
applications (i.e. SO_RCVBUF) is at least that value.

 

CAUSE

The Socket Buffer Size is too small.

SOLUTION

The socket receive buffer size is established based on OS settings.

Set the maximum buffer size to at least the value reflected in the message (2048 KB in this example)

The commands required to do this depends on the Operating System.

For example, as root:

      On Linux execute   # sysctl -w net.core.rmem_max=2097152

      On Solaris execute # ndd -set /dev/udp udp_max_buf 2097152

      On AIX execute     # no -o sb_max=4194304   (note: AIX only permits sizes of 1048576, 4194304 or 8388608)

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28612416/viewspace-1455350/，如需轉載，請註明出處，否則將追究法律責任。

相關文章