SQL> select IP_KSXPIA from x$ksxpia where PUB_KSXPIA = 'N'; IP_KSXPIA ---------------- 192.168.10.11This query should be run on all instances to find the private interconnect IP address used on their respective nodes. 2) Query GV$CLUSTER_INTERCONNECTS view Querying GV$CLUSTER_INTERCONNECTS view lists the interconnect used by all the participating instances of the RAC database.
SQL> select INST_ID, IP_ADDRESS from GV$CLUSTER_INTERCONNECTS; INST_ID IP_ADDRESS ---------- ---------------- 1 192.168.10.11 2 192.168.10.123) ASM and Database log We can find out the cluster interconnect used by viewing the log file of both ASM instance and the database instance. When the ASM instance is started it registers the private interconnect used. Following is the excerpt from the ASM alert log on node 1:
: : Cluster communication is configured to use the following interface(s) for this instance 192.168.10.11 : :Similarly, the database instance also registers the private interconnect with its instance and following message is recorded in the alert log:
: : Cluster communication is configured to use the following interface(s) for this instance 192.168.10.11 : :4) CLUSTER_INTERCONNECT initialization parameter This parameter provides Oracle with information on the availability of additional cluster interconnects. It overrides the default interconnect settings at the OS level with a preferred one. You can view the current value of this parameter by issuing the following in SQL*Plus, connected as SYS user: SQL> show parameter cluster_interconect Thanks for reading :-)