This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Oracle RAC intermittent connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle RAC intermittent connection" Watch "Oracle RAC intermittent connection" New topic
Author

Oracle RAC intermittent connection

Dan Parsons
Ranch Hand

Joined: May 30, 2007
Posts: 70
I am connecting to Oracle 10g RAC using JDBC in Tomcat 6.0.20.
It works around 50% of the time. When it doesnt work it shows this error message:
IO exception: The Network Adapter could not establish the connection.

Here is my JDBC String:
The above Description parameters I use in my tnsnames.ora and can successfully connect to the Oracle RAC using SQL Plus with no issues. I can also successfully ping to the IP addresses with no issues.
I also played around with the JDBC string and added (FAILOVER=ON) but still have same issues.

Please advise.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle RAC intermittent connection
 
Similar Threads
SQL Server database failover
Difference in Connection Strings for the same DB(Oracle 9i)
not able to connect with 10g
Oracle 10g RAC Configuration, JBOSS
Passing user and password in Oracle RAC url