Monday, April 2, 2012

Connecting to a RAC instance with Oracle SQL Developer

New Connection
Connection Type: Advanced
in Custom JDBC URL enter:


jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(FAILOVER=ON)(ENABLE=BROKEN)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost1-vip.acme.com)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=myhost2-vip.acme.com)(PORT=1522)))(CONNECT_DATA=(SERVICE_NAME=srv_osb)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(DELAY=5)(RETRIES=36))))



and.... it works! No need to set any special classpath.

No comments: