Linux Loopback Interface

From: Rakesh Ra <rakeshra.tr_at_gmail.com>
Date: Wed, 11 Sep 2019 07:49:04 +0530
Message-ID: <CAOGpvWqMam=nz=xKY8FeWYALW6ymdGUVwJOdwb9wVn4eKNcgqA_at_mail.gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 11 2019 - 04:19:04 CEST

Original text of this message