This content has been marked as final. Show 3 replies
The Oracle 10 client has approximately the same problem, but produces a different error number/message:
ORA-12170: TNS:Connect timeout occurred
We fixed this problem, it was due to the listener redirecting the client to a different listener by name, not by IP. The subsequent DNS lookup was failing on the client OR the lookup would suceed and point to an IP that the client couldn't connect to. This causes all sorts of wierd, intermittant problems that only happen when the listener decides to redirect the client.
Once we figured out what the listener was sending out for the redirect to the other listener and got all the DNS and IP issues worked out, our RAC setup worked fine. We had the same issue on a non VM RAC as well.
I'm faced the same problem, kindly provide details guidelines on how you resolved this.