一次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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28612416/viewspace-1455350/