Tuesday, March 18, 2008

Find out Interconnect Protocol

SQL > oradebug setmypid
Statement processed.

SQL>oradebug ipc
Information written to trace file.


Trace file can be found in user_dump_dest directory
SSKGXPT 0x66964c0 flags SSKGXPT_READPENDING socket no 7 IP 10.1.10.22 UDP 52459


This method can be used for both RDMS and ASM instances.

Alert logs of these various types of instances also can be used to find out the interconnect protocol.
cluster interconnect IPC version:Oracle UDP/IP (generic)