Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Setting up 11.2 RAC client side failover not working

JDinPAAug 15 2012 — edited Aug 22 2012
I 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))))
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 19 2012
Added on Aug 15 2012
10 comments
791 views