Tuesday 23 June 2020

Unable to Connect to Cluster databases due to ORA-27301: OS failure message: No buffer space available

DB alert log:

skgxpvfynet: mtype: 61 process 35044 failed because of a resource problem in the OS. The OS has most likely run out of buffers (rval: 4)

Errors in file /u01/app/oracle/diag/rdbms/racdb01/racdb011/trace/racdb011_ora_35044.trc  (incident=1120006):

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: /u01/app/oracle/diag/rdbms/racdb01/racdb011/incident/incdir_1120006/racdb011_ora_35044_i1120006.trc

opiodr aborting process unknown ospid (35044) as a result of ORA-603

Wed May 27 15:06:03 2020

Dumping diagnostic data in directory=[cdmp_20200527150603], requested by (instance=1, osid=35044), summary=[incident=1120006].

Wed May 27 15:06:41 2020

 

 

Issue: Connections failing due to loopback mtu settings, we need to lower MTU value  for loopback adapter on all cluster nodes 


We can make changes without bringing down cluster service 


Loopback Settings:

 1. Change MTU size of loopback adapter as below.

  ifconfig lo mtu 16384

 

 2. To make the change persist after a reboot: Add MTU value in ifcfg-lo

  vi /etc/sysconfig/network-scripts/ifcfg-lo

  MTU=16384

No comments:

Post a Comment