Monday, November 12, 2012

How to find Cluster Interconnect IP in RAC

Couple of ways around to find the Interconnect IP Address defined in RAC environment.

First thing would be to look in /etc/hosts to see which IP is assigned based on the comments or naming conventions.

Or check ASM Alert logs for the wording "Cluster Communication is configured to use the following interface(s)"

Or
Run the following sql:

select inst_id, ip_address from gv$cluster_interconnects;