troubleshooting Question

JDBC thin client connection problem

Avatar of monto1
monto1 asked on
Oracle Database
2 Comments1 Solution4819 ViewsLast Modified:
Hi ,
      The application team is trying to connect a oracle 10g db using jdbc thin client , as it is RAC db one of the node is down , so the aplication should failover to the surviving node but its giving the following error.Do i have to add any additional parameter in my tns.

An error occured while establishing the connection.
   Type: java.sql.SQLException   Error Code: 17002
   Io exception: The Network Adapter could not establish the connection
here is the connect string using  jdbc url


Do i have to add any additional parameter in my tns?

Tns entry:
Axxx =
    (SDU = 32768)
    (enable = broken)
    (LOAD_BALANCE = yes)
    (ADDRESS = (PROTOCOL = TCP)(HOST = = 1525))
    (ADDRESS = (PROTOCOL = TCP)(HOST = = 1525))
      (SERVICE_NAME = Axxx)



Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros