interconnect RAC

[satish]

Dear erman,

In RAC database.we would like to know how can we check if my database was using interconnect IP for block transfer or if it was using public IP.
Also we request you some commands which are useful to identify the private,interconnect IP's in RAC environment

Thank you for the support

[ErmanArslansOracleBlog]

It can not use public ips for that..

Check using "show parameter cluster_interconnects"

+ Use ifconfig and /etc/hosts file to check the interfaces and associated ip addresses.

you can also use srvctl and crsctl command with the relevant argument do display these settings.. Read documentation for this.

[satish]

Dear erman,

Thanks for the update.apologize for not making my question clear

If the interconnect is slow, busy, or faulty, you can look for dropped packets,
retransmits, or cyclic redundancy check errors (CRC). You can use netstat commands
to check the networks.
make sure that inter-instance traffic is
not routed through a public network.

I need your help on how to check if interconnect is slow/bsy in rac?
How to check inter-instance traffic is not routed through a public network?

[ErmanArslansOracleBlog]

If you don't see interconnect related waits in AWR, then your interconnect is probably performing okay.. Or let's it isn't a problem to solve right now..

Interconnect bandwidth should be tested with non-Oracle utilities(for example: iPerf ). No packet should be lost at 75%-80% of bandwidth utilization.

[ErmanArslansOracleBlog]

Also check the best practices documented in this note -> RAC and Oracle Clusterware Best Practices and Starter Kit (Platform Independent) (Doc ID 810394.1)

[satish]

thank you