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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.