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
Message:
   Io exception: The Network Adapter could not establish the connection
 
here is the connect string using  jdbc url

jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=ON)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=g1uxxxxc.xxxxxx.xx.com)(PORT=1525)) (ADDRESS=(PROTOCOL=TCP)(HOST=g1uxxxxc.xxxxxx.xx.com)(PORT=1525)))(CONNECT_DATA=(SERVICE_NAME=Axxx)))

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

Tns entry:
Axxx =
  (DESCRIPTION =
    (SDU = 32768)
    (enable = broken)
    (LOAD_BALANCE = yes)
    (ADDRESS = (PROTOCOL = TCP)(HOST = gvxxxx.xxxxxx.xx.com)(PORT = 1525))
    (ADDRESS = (PROTOCOL = TCP)(HOST = gvxxxx.xxxxxx.xx.com)(PORT = 1525))
    (CONNECT_DATA =
      (SERVICE_NAME = Axxx)
    )
  )



 


ASKER CERTIFIED SOLUTION
joebednarz

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