IMPORTANT INFORMATION TO KNOW ABOUT VIPs AND INTERCONNECTs

Post date: 22-May-2009 10:18:27

(A)    Get Interconnect Information

oifcfg getif

[oracle@rc1.myrac.com] # oifcfg getif

eth0  192.168.112.0  global  public

eth1  192.168.112.0  global  cluster_interconnect

(B)    The following query provides a list of Interconnect IP addresses registered with Oracle.

SELECT * FROM X$KSXPIA

ADDR       INDX    INST_ID PUB_KSXPIA PICKED_KSXPIA   NAME_KSXPIA     IP_KSXPIA

-------- ------ ---------- ---------- --------------- --------------- ----------------

B7F07A3C      0          1 N          OCR             eth1            192.168.112.11

B7F07A3C      1          1 Y          OCR             eth0            192.168.112.10

If NIC bonding or additional IP address is configured for Interconnect then the query would return something like below :

Also if instead configuring one IP for interconnect, there is a need to configure more than one ip for interconnect to provide more bandwidth to the interinstance traffic then the above query would display something like below :

• OCR = Oracle Clusterware is configured.

• OSD = Operating System dependent, meaning a third party cluster manager is configured, and Oracle Clusterware is only a bridge between Oracle RDBMS and the third party                cluster manager.

• CI = Interconnect is defined using the CLUSTER_INTERCONNECT parameter in the instance.

OR

You could check it from your /etc/hosts file about VIP and Interconnect information. However best is to use above commands and ways.

3.    Get your VIP information

srvctl config nodeapps -n rc1 -a -g -s -l

VIP exists.: /rc1-vip.myrac.com/192.168.112.30/255.255.255.0/eth0

GSD exists.

ONS daemon exists.

Listener exists.