WARNING: Failed to set buffer limit on IPC interconnect socket

SKGXP:[110a4d248.1]{-}: WARNING: Failed to set buffer limit on IPC interconnect socket

适用于: Oracle 11.2.0.2 以后的版本


在Oracle中的警告日志alert.log 出现以下报警:

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.
 

产生原因

The Socket Buffer Size 设置太小.

解决方案

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.

在操作系统以root用户执行:

      Linux 平台   # sysctl -w net.core.rmem_max=2097152

      Solaris 平台 # ndd -set /dev/udp udp_max_buf 2097152

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