签到成功

知道了

CNDBA社区CNDBA社区

Oracle Linux: ORA-27301:OS Failure Message: No Buffer Space Available

2020-12-02 15:56 672 0 转载 Oracle 19c
作者: Dave

APPLIES TO:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Cloud Infrastructure - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Linux x86-64

SYMPTOMS

  •  Database Alert log captures below:
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
  • Network communication issue and High Memory consumption would be observed during this time.
  • Server is running with UEK3 kernel
Note : This issue has been noticed in other kernels as well. Hence, this document can be applied on a generic level based on the error code

 

CHANGES

 https://www.cndba.cn/dave/article/4320https://www.cndba.cn/dave/article/4320

CAUSE

 This happens due to less space available for network buffer reservation.https://www.cndba.cn/dave/article/4320https://www.cndba.cn/dave/article/4320

SOLUTION

1. On servers with High Physical Memory, the parameter vm.min_free_kbytes should be set in the order of 0.4% of total Physical Memory. This helps in keeping a larger range of defragmented memory pages available for network buffers reducing the probability of a low-buffer-space conditions.

*** For example, on a server which is having 256GB RAM, the parameter vm.min_free_kbytes should be set to 1073742 ***

 https://www.cndba.cn/dave/article/4320

On NUMA Enabled Systems, the value of vm.min_free_kbytes should be multiplied by the number of NUMA nodes since the value is to be split across all the nodes.

https://www.cndba.cn/dave/article/4320


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.

 https://www.cndba.cn/dave/article/4320

2. Additionally, the MTU value should be modified as below

#ifconfig lo mtu 16436

 

To make the change persistent over reboot add the following line in the file /etc/sysconfig/network-scripts/ifcfg-lo :

MTU=16436

Save the file and restart the network service to load the changeshttps://www.cndba.cn/dave/article/4320https://www.cndba.cn/dave/article/4320

#service network restart

 https://www.cndba.cn/dave/article/4320

Note : While making the changes in CRS nodes, if network is restarted while CRS is up, it can hung CRS. So cluster services should be stopped prior to the network restart.
用户评论
* 以下用户言论只代表其个人观点,不代表CNDBA社区的观点或立场
Dave

Dave

关注

人的一生应该是这样度过的:当他回首往事的时候,他不会因为虚度年华而悔恨,也不会因为碌碌无为而羞耻;这样,在临死的时候,他就能够说:“我的整个生命和全部精力,都已经献给世界上最壮丽的事业....."

  • 1879
    原创
  • 2
    翻译
  • 437
    转载
  • 127
    评论
  • 访问:3440027次
  • 积分:3049
  • 等级:核心会员
  • 排名:第1名
精华文章
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        Copyright © 2016 All Rights Reserved. Powered by ZhiXinTech · 皖ICP备19020168号·

        QQ交流群