重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 1555|回复: 0
打印 上一主题 下一主题

[转载] Oracle Linux: ORA-27301:OS Failure Message: No Buffer Space Available

[复制链接]
跳转到指定楼层
楼主
发表于 2018-6-27 17:20:08 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式

Applies to:  
Linux OS - Version Oracle Linux 6.0 and later

Oracle Database - Enterprise Edition

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/nadb29/NADB29-7/trace/NADB29-7_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/nadb29/NADB29-7/incident/incdir_249601/NADB29-7_ora_14152_i249601.trc

  • Network communication issue and High Memory consumption would be observed during this time.
  • Server is running with UEK3 kernel.

Cause
This happens due to less space available for network buffer reservation.
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 1048576 ***


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.

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.


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 changes
#service network restart


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.


分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 支持支持 反对反对
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-4-30 13:41 , Processed in 0.093600 second(s), 20 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表