URL for Oracle RAC

To provide client-side failover and load-balancing for Oracle RAC, enter the URL in the form of:

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)

 (ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))

 (ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521))

 (CONNECT_DATA=(SERVICE_NAME=service)

   (FAILOVER_MODE =

     (TYPE = SELECT)

     (METHOD = BASIC)

     (RETRIES = 180)

     (DELAY = 5)

   )

)

)