Topic: Oracle Real Application Clusters (RAC) >> !0gR2 RAC Database Connectivity Issue
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: !0gR2 RAC Database Connectivity Issue |
| Paul |
Posted: Jan 09, 2006 10:25:17 AM |
Total Post: 2
Joined: Jun, 2005
|
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. It has lost its connection.
This problem did not exist with Oracle RAC 10g version 1.
Can anyone point me in the right direction?
Thanks
Paul
|
|
|
 Paul |
| Posted: Jan 10, 2006 11:34:51 AM |  |
|
Total Post: 2
Joined: Jun, 2005
|
Problem Solved,
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
|
|
|
|
|
| Vigyan |
| Posted: Jan 10, 2006 12:34:02 PM | |
|
Total Post: 386
Joined: May, 2001
|
Thanks for sharing solution with rest of us.
Vigyan
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
