This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one 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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript 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