Description:
General instruction:

Make sure that you have latest ojdbc14.jar deployed.
Oracle client version: 10.2.0.1
Add the following entries in your C:\WINDOWS\system32\drivers\etc file (for trusted hosts).

10.97.108.106    rac1.tibco.com                rac1
10.97.108.107    rac2.tibco.com      rac2
10.97.108.109    racvip1.tibco.com    racvip1
10.97.108.110    racvip2.tibco.com    racvip2

For JBOSS:

Add the following Connection URL in oracle-ds.xml file.

&ltconnection-url&gtjdbc:oracle:thin:@(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = racvip1.tibco.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = racvip2.tibco.com)(PORT = 1521))
    )
    (FAILOVER=on)
    (LOAD_BALANCE=yes)
    (CONNECT_DATA =
      (SERVER=DEDICATED)
      (SERVICE_NAME = orclrac)
      (FAILOVER_MODE=
         (TYPE=SELECT)
     (METHOD=BASIC)
     (RETRIES=180)
     (DELAY=5)
      )
    )
  )
  </connection-url>


For Weblogic:

Add the following connection URL in weblogic datasource url.

jdbc:oracle:thin:@(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = racvip1.tibco.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = racvip2.tibco.com)(PORT = 1521))
    )
    (FAILOVER=on)
    (LOAD_BALANCE=yes)
    (CONNECT_DATA =
      (SERVER=DEDICATED)
      (SERVICE_NAME = orclrac)
      (FAILOVER_MODE=
         (TYPE=SELECT)
     (METHOD=BASIC)
     (RETRIES=180)
     (DELAY=5)
      )
    )
  )

For Websphere:

Add the above connection URL in Websphere datasource Url.

jdbc:oracle:thin:@(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = racvip1.tibco.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = racvip2.tibco.com)(PORT = 1521))
    )
    (FAILOVER=on)
    (LOAD_BALANCE=yes)
    (CONNECT_DATA =
      (SERVER=DEDICATED)
      (SERVICE_NAME = orclrac)
      (FAILOVER_MODE=
         (TYPE=SELECT)
     (METHOD=BASIC)
     (RETRIES=180)
     (DELAY=5)
      )
    )
  )