mtype: 61 process 14152 failed because of a resource problem in the OS. The OS has most likely run out of buffers (rval: 4)
Errors in file /oracle/admin/diag/rdbms/<DB>/<SID>/trace/<SID>_ora_14152.trc  (incident=249601):
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:sendmsg failed with status: 105
ORA-27301: OS failure message: No buffer space available
ORA-27302: failure occurred at: sskgxpsnd2
Incident details in: /oracle/admin/diag/rdbms/<DB>/<SID>/incident/incdir_249601/<SID>_ora_14152_i249601.trc

解决方案

  • 设置vm.min_free_kbytes参数,避免尝试超过物理内存5%的设置,否则会立即触发内存不足的情况。建议按照官方建议进行设置。
  • On NUMA Enabled Systems, the value of vm.min_free_kbytes = n * 0.4% of total Physical Memory. Here 'n' is the number of NUMA nodes.
  • 根据当前系统内存情况计算:0.004* 251* 1024* 1024= 1052770 ,1052770* 4= 4211080
vm.min_free_kbytes = 4211080
  • 设置MTU,修改 /etc/sysconfig/network-scripts/ifcfg-lo,添加如下内容,然后需要重启网络生效,同时建议重启操作系统。
    注意:RAC环境需要先停止集群,然后进行修改操作
MTU=16436

临时在线生效措施,root用户执行
#ifconfig lo mtu 16436