Tuning the Cluster Interconnect - Expert Oracle RAC Performance Diagnostics and Tuning - page 475

Step 3
If the OCR file is correct, where is the problem? The next step was to ensure that the database understood the right IP
address for the interconnect. For this, a dump of the IPC buffer from SQL*Plus indicated that the Oracle database was
not aware of the private interconnect; the IP address registered, that is, 10.32.8.35 , was the public IP address:
SQL> oradebug setmypid
Statement processed.
SQL> oradebug ipc
Information written to trace file.
SQL> exit
The trace file output had the following entries:
user cpu time since last wait 0 sec 0 ticks
system cpu time since last wait 0 sec 0 ticks
locked 1
blocked 0
timed wait receives 0
admno 0x5b0dce1b admport:
SSKGXPT 0xf684b80 flags SSKGXPT_READPENDING socket no 7 IP 10.32.8.35 UDP 1131
context timestamp 0
no ports
The output indicates that the IP address is a public IP used by users to access the database. However the database
is also uses this as a private network. The public IP address was a 100 BaseT network, indicating it was all the more
reason for slow performance. Oracle used UDP to transfer data blocks between instances.
haIp VerIFICatION USING OraDeBUG
in oracle Database 11g release 2 (11.2.0.2), the oradebug ipc will give all the private interconnects configured
and registered with the database:
wait delta 60 sec (60287 msec) ctx ts 0x0 last ts 0x0
user cpu time since last wait 0 sec 140733193388032 ticks
system cpu time since last wait 0 sec 140733193388032 ticks
locked 2
blocked 0
timed wait receives 0
fast reaps since last wait 0
context timestamp 0
flags=1 flags1=30 zcpyflg=15824 iflags=820 aflags=80 trcflags=0 trclevel=3
rcvbuf=131072 sndbuf=262144
admno 0x5a449d81 admport:
SSKGXPT 0x2b18269e4170 flags 0x5 { READPENDING } sockno 5 IP 169.254.2.61 UDP 31955 lerr 0
SSKGXPT 0x2b18269e4198 flags 0x0 sockno 8 IP 169.254.73.36 UDP 20886 lerr 0
SSKGXPT 0x2b18269e41c0 flags 0x0 sockno 10 IP 169.254.133.38 UDP 41693 lerr 0
SSKGXPT 0x2b18269e41e8 flags 0x0 sockno 11 IP 169.254.223.49 UDP 36434 lerr 0
post port:
SSKGXPT 0x2b18269e45c8 flags 0x0 sockno 13 IP 127.0.0.1 UDP 25820 lerr 0