Hi all,
We had a problem on our Oracle RAC (Three nodes) and it was related to interconnect (Private) connections. I need to find root cause, but database team couldn't help us.
The Oracle RAC has:
- Three physical HPE servers.
- Connected to two different interconnect switches, each server has two interconnect connection.
- Two different subnets used for interconnect connections.
The issues:
One of nodes reboot unexpectedly and we found nothing related to hardware problem. Unfortunately, one interconnect was added in configuration and second interconnect was free on all nodes. So, there was no HA for interconnect connection.
After reboot affected node, the node was unable to select interconnect connection but there was no connection problem.
First question: Is there any metrics which checked by CRS to select interconnect links based on result?
After reboot all nodes and change configuration to add second interconnect link, Oracle database has started on third node but there is another issue, each node selects one interconnect link and two of them selects first and one of them selects second interconnect.
Can anyone help us?