Tuning the Cluster Interconnect - Expert Oracle RAC Performance Diagnostics and Tuning - page 452

Script:MVRACPDnTap_verifyic.sql

SELECT addr,
indx,
inst_id,
pub_ksxpia,
picked_ksxpia,
name_ksxpia,
ip_ksxpia
FROM x$ksxpia;
Impl
ADDR Indx Public Type Name IP Address
---------------- ------ ---------- ---------- ---------- ---------------
00002B02FB7F89A0 0 N GPnP bond2:1 169.254.183.5
00002B02FB7F89A0 1 Y GPnP bond0 10.32.5.43
00002B02FB7F89A0 2 Y GPnP bond0:1 10.32.5.48
00002B02FB7F89A0 3 Y GPnP bond0:4 10.32.5.56

SELECT inst_id,
name,
ip_address,
is_public
FROM gv$cluster_interconnects
ORDER BY inst_id;

Instance Name IP_ADDRESS IS_ SOURCE
-------- ---------- ---------------- --- -------------------------------
1 bond2:1 169.254.183.5 NO
2 bond2:1 169.254.250.200 NO
3 bond2:1 169.254.129.142 NO

[oracle@prddb1]$ /sbin/ifconfig -a
bond2 Link encap:Ethernet HWaddr 00:22:64:0F:B9:9B
inet addr:172.30.0.143 Bcast:172.30.0.255 Mask:255.255.255.0
inet6 addr: fe80::222:64ff:fe0f:b99b/64 Scope:Link
UP BROADCAST RUNNING MASTER MULTICAST MTU:9000 Metric:1
RX packets:16277881 errors:0 dropped:0 overruns:0 frame:0
TX packets:13903957 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:15725195854 (14.6 GiB) TX bytes:13853391629 (12.9 GiB)
bond2:1 Link encap:Ethernet HWaddr 00:22:64:0F:B9:9B
inet addr:169.254.183.5 Bcast:169.254.255.255 Mask:255.255.0.0
UP BROADCAST RUNNING MASTER MULTICAST MTU:9000 Metric:1

■ in the preceding outputs, note the bond2:1 , indicating that this is an upgrade from oracle 11g release 1;
bonding of interfaces for the interconnect is not required when grid infrastructure version 11.2.0.2 is installed new on
the cluster.

Note