-
10gR2 RAC Database Connectivity Issue
Hi,
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'
followed by:
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?
Thanks
Paul
-
What does your sqlnet.ora look like? Make sure the correct sqlnet.ora file exists at OFSA location
Thanx,
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Originally Posted by sambavan
What does your sqlnet.ora look like? Make sure the correct sqlnet.ora file exists at OFSA location
Thanx,
Sam
Thanks Sam,
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
Regards Paul
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|