Determining the IP address of the cluster interconnect in 9i

In Oracle database version 9i there is no way to determine the IP address through a database view. The only way to determine this IP address is with the oradebug command (Please keep in mind oradebug is not a supported product from Oracle, so if there are problems/crashes you are on your own). The oradebug ipc command creates a trace file. The example shows the process:

 SQL> oradebug setmypid

  SQL> oradebug ipc

  SQL> oradebug tracefile_name

The last command will show the name of the created trace file. The next step is opening the trace file and looking for the string SKGXPCTX. The following is a typical example.

SKGXPCTX: 0xcd1e730 ctx

 admno 0x7a0be402 admport:

 SSKGXPT 0xcd1e884 flags SSKGXPT_READPENDING     info for network 0

         socket no 8     IP 140.87.79.67         UDP 9152

         sflags SSKGXPT_WRITESSKGXPT_UP

         info for network 1

The cluster interconnect IP address is shown in bold. In the example above
it is 140.87.79.67.