To find the Cluster Interconnect IP address in an Oracle RAC (Real Application Clusters) environment, you can use several methods depending on your access level (OS or DB) and tools available.

Here’s how:

From the OS using oifcfg. Run this command on any RAC node:

oifcfg getif

eth0 192.168.x.0 global public
eth1 172.x.x.x global cluster_interconnect
Look for the interface marked as cluster_interconnect — that’s your interconnect network.

Using srvctl command:

srvctl config nodeapps

From the Oracle Database using SQLplus. This shows the interconnects configured for each instance. The value might be blank if the default (OS-determined) interconnect is used.

SELECT inst_id, name, value
FROM gv$parameter
WHERE name = ‘cluster_interconnects’;

This shows the IP addresses associated with RAC internode communication.

SELECT inst_id, host_name, ip_address
FROM gv$ksxpia;