告警日志错误：
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博客

一次oracle 节点重启问题的定位

APPLIES TO:

SYMPTOMS

CAUSE

SOLUTION

最新文章