Check the Oracle cluster interconnect information

Check the Oracle cluster interconnect information

Interconnect is the physical connection between the RAC Nodes to perform health check like heartbeats and use cachefusion with help of private lan by Cluster.
Interconnect are the private connection between RAC Nodes.
Private connection used private network between RAC Nodes to maintain connectivity between RAC Nodes and check availability of each other with heartbeats signal.

Check Oracle RAC interconnect information

SELECT * FROM GV$CLUSTER_INTERCONNECTS;

INSTID NAME   IP_ADDRESS IS_PUBLIC SOURCE
------ ------ ---------- --------- -------------------------
1      eth2   10.0.20.1  NO        Oracle Cluster Repository
2      eth2   10.0.20.2  NO        Oracle Cluster Repository

Check Oracle RAC interconnect information
Both private and public information is stored in OCR.

$ /u01/app/grid/bin>oifcfg getif
e1000g0 192.168.1.0 global public
e1000g1 10.0.20.0 global cluster_interconnect --Private
Output:
First column is the network adapter name
Second column is the subnet ID
Third column is value always global
Last column indicates between public or cluster_interconnect( means private) in Oracle Clusterware

Verify the interconnect setting from this view

SELECT * FROM V$CONFIGURED_INTERCONNECTS;

NAME             IP_ADDRESS       IS_PUBLIC   SOURCE
---------------  ---------------  ---         -------------------------------
eth2             10.0.20.1        NO          Oracle Cluster Repository
eth0             192.168.1.1      YES         Oracle Cluster Repository

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply