Link to home
Start Free TrialLog in
Avatar of monto1
monto1

asked on

JDBC thin client connection problem

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
Avatar of joebednarz
joebednarz
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Forced accept.

Computer101
EE Admin