Thursday, November 14, 2019

How to fix ORA-27301 Failure Message: No Buffer Space Available / ORA-27302: failure occurred at: sskgxpsnd2

We saw so many sudden code dumps created and generated on ASM instance in one of our systems.

In the output we can see the following :
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:65536 Metric:1 <-------------------------------- MTU:65536
RX packets:53213170461 errors:0 dropped:0 overruns:0 frame:0
TX packets:53213170461 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:12896625468946 (11.7 TiB) TX bytes:12896625468946 (11.7 TiB)


This is a known issue having the loopback adapter at a TOO HIGH value :
SOLUTION: change the parameter value to a lower number. 
Change the MTU of loopback adapter to 16384 :
--- # ifconfig lo mtu 16384

Hope this helps!

No comments:

Post a Comment