Determining what IP address was picked for the cluster interconnect

In the past it was difficult for a user or DBA to determine which cluster interconnect was picked. It was possible to obtain that information with an oradebug comnmand. With Oracle Version 10gR1 this information is available with the X$ table X$KSXPIA.

The following SQL shows which information is returned by querying that view.

SQL> SELECT * FROM x$ksxpia;



  ADDR           INDX    INST_ID P PICK NAME_KSXPIA     IP_KSXPIA

  -------- ---------- ---------- - ---- --------------- ----------------

  B0757098          0         10   OSD  eth0            140.87.79.74

It shows that the OSD layer picked the NIC and to which network device it belongs. In this case it is eth0.

SQL> SELECT * FROM x$ksxpia;



  ADDR                   INDX    INST_ID P PICK NAME_KSXPIA     IP_KSXPIA

  ---------------- ---------- ---------- - ---- --------------- ----------------

  00000004FEC82C40          0          2   CI                   172.16.193.1

This example shows if the cluster_interconnects database initialization parameter has been set. The PICK column shows CI which stands for cluster interconnects. If the cluster interconnect is set in that way, no name is determined for the NIC. This is only done if the NIC is determined by the OSD.