10gR2 RAC Database Connectivity Issue
I have built a two-node RAC database Cluster on Windows 2003. I set up a number client application servers and installed Oracle Client 10.2 to talk to a database on the cluster. Using an SQL Client connection is OK.
However when I set up an actual application to use the cluster database I keep losing my connections. Looking at the Sqlnet.log the error it gives is
'Fatal NI coonect error 12545'
TNS-12545: Connect failed ......
TNS-00515: Connect failed because host or object does not exist.
When I look at the cluster database I see that some of the tables have been created. This problem did not exist with Oracle RAC 10g version 1.
Can anyone point me in the right direction?
What does your sqlnet.ora look like? Make sure the correct sqlnet.ora file exists at OFSA location
Life is a journey, not a destination!
Originally Posted by sambavan
Problem was in another area.
Turning on SqlNet trace, pointed to the fact that SQLNET was trying to resolve the other cluster nodes name. But because our DMZ was using external DNS it could not be resolved.
The solution was to create a hosts file on the server, containing the virtual and phyical IPs.
Thanks for help
Click Here to Expand Forum to Full Width