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

In this Document

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)