Oracle Tips by Burleson

Oracle10g Grid Computing with RAC
Chapter 6 - Install, Configure and Database Creation

Interconnect

If more than two nodes are interconnected in a cluster, they must be linked with a switch. Wherever possible, we must provide redundant interconnects by using dual switches. How do you detect which interconnect is used? The following commands show which interconnect is used for UDP or TCP:

sqlplus> connect / as sysdba
oradebug setmypid
oradebug ipc
exit

The corresponding trace can be found in the user_dump_dest directory, and contains the following information in the last couple of lines:

SKGXPCTX: 0x32911a8 ctx
admno 0x12f7150d admport:
SSKGXPT 0x3291db8 flags SSKGXPT_READPENDING
    info for network 0
  socket no 9 IP 172.16.193.1 UDP 43307
  sflags SSKGXPT_WRITESSKGXPT_UP
  info for network 1
  socket no 0 IP 0.0.0.0 UDP 0
  sflags SSKGXPT_DOWN
context timestamp 0x1ca5
  no ports

When other protocols such as HMP or RDG are used, the trace file will not reveal the IP address.