Hi All,
Can someone shed some light on for what operations Oracle can use loopback
interface? We had the below issue on one of our primary production database
running on 12.1.0.2 running on Red Hat Linux 7.5.
skgxpvfynet: mtype: 61 process 75262 failed because of a resource problem
in the OS. The OS has most likely run out of buffers (rval: 4) opiodr
aborting process unknown ospid (75262) as a result of ORA-603
Oracle asked us to fix the MTU by lowering it from 64k to 16k by following
the below note.There were just application user connections (jsut less than
400 user processes) and couple of scp process which was shipping the backup
files from the this primary database server to standby database server as
part of DR build.
lo: flags=73<UP,LOOPBACK,RUNNING> mtu 16436 <<<<<<<<<<<< This value was
64K during the issue time. It looks starting 6.5 kernel , MTU is bumped to
64K. We lowered this to 16K
inet 127.0.0.1 netmask 255.0.0.0
loop txqueuelen 1000 (Local Loopback)
RX packets 2689657 bytes 17458642228 (16.2 GiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 2689657 bytes 17458642228 (16.2 GiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
Oracle Linux: ORA-27301:OS Failure Message: No Buffer Space Available (Doc
ID 2041723.1)
I followed up with Oracle to see, in what way loopback interface is
contributing to the issue here, but they failed to give more details saying
it's OS specific and they don't have idea on the same. :(
Appreciate if someone has some previous experience working on similar issue
provide some information related to this.
BR,
Rakesh RA
