Wednesday, December 08, 2010

JDBC to Oracle RAC

Here is a simple example of how to connect to an Oracle RAC DB using JDBC

 url="jdbc:oracle:thin:@(DESCRIPTION=
   (LOAD_BALANCE=on)
    (ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip)(PORT=1521))
    (ADDRESS=(PROTOCOL=TCP)(HOST=node2-vip)(PORT=1521))
    (ADDRESS=(PROTOCOL=TCP)(HOST=node3-vip)(PORT=1521))
    (CONNECT_DATA=(SERVICE_NAME=MYRACDB)))"

No comments: