Setting up 11.2 RAC client side failover not working
JDinPAAug 15 2012 — edited Aug 22 2012I have a 11.2 RAC cluster setup and have load balancing working however I can't get failover to work for a jdbc application.
I'm testing in Oracle's Sql Developer 3.1.07.42 but plan on using the configuration for multiple 3rd party jdbc applications.
For my failover test I crash the server where sql developer's client session is running I get the following error:
IO Error: connection reset by peer: socket write error.
I then reconnect (to the other node) and the query runs fine.
Does Oracle Sql Developer support client side failover?
Did I miss something in the setup?
I ran this on the successfully on the server:
EXECUTE DBMS_SERVICE.MODIFY_SERVICE (service_name => 'racdb.test.com', goal => DBMS_SERVICE.GOAL_THROUGHPUT , clb_goal => DBMS_SERVICE.CLB_GOAL_SHORT);
Here is jdbc connection url:
jdbc:oracle:thin:@
(DESCRIPTION=
(LOAD_BALANCE=on)
(FAILOVER=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=10.20.9.252)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=10.20.9.253)(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=racdb.test.com)
(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))))