Get IP-Address in RAC interconnect from Oracle Instance.

Sometimes we have no access to the clusterware and we need to verify or find out the IP of the NIC interconnect. We can get this information in a simple way because Oracle provides two Oracle views, V$CLUSTER_INTERCONNECTS and V$CONFIGURED_INTERCONNECTS.

V$CONFIGURED_INTERCONNECTS displays all the interconnects that Oracle is aware of and where Oracle found the information about a specific interconnect. This view have four attributes.

  • NAME, name of the interconnect (such as eth0)
  • IP_ADDRESS, IP address of the interconnect
  • IS_PUBLIC, if the value is YES, the interface is known to the public. If the value is NO to be private
  • SOURCE, indicates where Oracle found the information. CLUSTER_INTERCONNECTS parameter, Oracle Cluster Repository (OCR) or Operating-system dependent software

 

Example in active/active

We connect to all the nodes that make up the cluster and execute the following statement .(In this case there are only two nodes).

rac_x_1

 

Example in active/passive

In this case there is only one instance so we will only get the NIC configured where the instance is running.

rac_x_2

 

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s