I have used various combinations of jdbc url from sql developer 4.2 but none of session failover properties are set. Is there a way to test RAC failover using sql developer jdbc thin url?
jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(ADDRESS=(PROTOCOL=TCP)(HOST=ldizd4364si.wellsfargo.com)(PORT=3203))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=racaware) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 2) (DELAY = 1)) ))
SQL> l
1* select inst_id,username,status,service_name,FAILOVER_TYPE,FAILOVER_METHOD,FAILED_OVER,module, program from gv$session where username='U267399'
SQL> /.
INST_ID USERNAME STATUS SERVICE_NAME FAILOVER_T FAILOVER_M FAILED_OVE MODULE PROGRAM
---------- ---------- -------- -------------------- ---------- ---------- ---------- ------------------------------ ------------------------------------------------
2 U267399 INACTIVE racaware NONE NONE NO SQL Developer SQL Developer