JDBC connection fails after switchover
edited Apr 18, 2013 1:48AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
Hi,
we are using a simple 11.2.0.3 DG configuration on Linux platform.
After a switchover, our fat clients, using Oracle Client 10.2.0.1 can make proper connections with the new primary database.
However, our web-applications using JDBC Thin driver connections, fail to connect if the primary database is on the host that is the 2nd host in the connectstring
So, the connectstring : xcfora=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srv3)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=srv4)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XCFT_TAF)(FAILOVER_MODE =(TYPE=select)(METHODE=basic)(RETRIES=60)(DELAY=10))))
works fine if the primary database , with service_names=XCFT_TAF
0