Last updated on November 28th, 2015 at 12:25 pm
Here are a few ways to How to find RAC interconnect information
1. Using the dynamic view gv$cluster_interconnects:SQL> select * from gv$cluster_interconnects;
INST_ID NAME IP_ADDRESS IS_ SOURCE
———- ————— —————- — ——————————-
1 en12 18.104.22.168 NO Oracle Cluster Repository
2 en12 22.214.171.124 NO Oracle Cluster Repository
2. Using the clusterware command oifcfg:
en10 10.127.149.0 global public
en11 10.127.150.0 global public
en12 126.96.36.199 global cluster_interconnect
3. Using oradebug ipc:sqlplus “/ as sysdba”
Information written to trace file.
The above command would dump a trace to user_dump_dest. The last few lines of the trace would indicate the IP of the cluster interconnect. Below is a sample output of those lines.
4) Information in /etc/hosts
#RAC Cluster 1