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:@(DESCRIP TION=(FAIL OVER=ON)(A DDRESS_LIS T=(LOAD_BA LANCE=ON)( ADDRESS=(P ROTOCOL=TC P)(HOST=g1 uxxxxc.xxx xxx.xx.com )(PORT=152 5)) (ADDRESS=(PROTOCOL=TCP)(HO ST=g1uxxxx c.xxxxxx.x x.com)(POR T=1525)))( CONNECT_DA TA=(SERVIC E_NAME=Axx x)))
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)
)
)
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:@(DESCRIP
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
(ADDRESS = (PROTOCOL = TCP)(HOST = gvxxxx.xxxxxx.xx.com)(PORT
(CONNECT_DATA =
(SERVICE_NAME = Axxx)
)
)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Computer101
EE Admin