Intermittent Connection Issues to RAC
Intermittent connection issues conencting to RAC can occur. This can be caused by the way Oracle 10G RAC handles its load-balancing. When RAC encounters a tns session redirect scenario, it is not able to handle fully qualified hostname.
For example, instead of using
racServer1.foo.com
it uses only
racServer1.
The Oracle client in client network will fail to get a proper resolution from their DNS servers for this scenario
Resolution:
The client's Network needs to define the all the rac instance servers as global alias to their DNS domain.
ie. racServer1 needs to be resolable via DNS as well as the fully qualified racServer1.foo.com.