How to find RAC interconnect information



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 192.158.100.65 NO Oracle Cluster Repository
2 en12 192.158.100.66 NO Oracle Cluster Repository

2. Using the clusterware command oifcfg:
$oifcfg getif
en10 10.127.149.0 global public
en11 10.127.150.0 global public
en12 192.158.100.64 global cluster_interconnect

3. Using oradebug ipc:sqlplus “/ as sysdba”
SQL>oradebug setmypid
Statement processed.
SQL>oradebug ipc
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
#
192.158.100.65 Node1-priv
192.158.100.66 Node2-priv

10.127.149.15 Node1
10.127.149.136 Node2


Leave a Reply