aspose file tools*
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle RAC intermittent connection" Watch "Oracle RAC intermittent connection" New topic

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.
subject: Oracle RAC intermittent connection
Similar Threads
SQL Server database failover
Passing user and password in Oracle RAC url
Difference in Connection Strings for the same DB(Oracle 9i)
not able to connect with 10g
Oracle 10g RAC Configuration, JBOSS