Resolution:
Assuming that you have Oracle RAC env set up with following database servers
(1) SERVICE = myservice1
    HOST      =  myhost1
    PORT      =  myport1

(2) SERVICE = myservice2
    HOST      =  myhost2
    PORT      =  myport2

Case 1 : While using “tibcosoftwareinc.jdbc.oracle.OracleDriver” driver.

JDBC URL field should contain:

jdbc:tibcosoftwareinc:oracle://\&ltmyhost1\>:\&ltmyport1\>SID=\&ltmyservice1\>AlternateServers=(\&ltmyhost2\>:\&ltmyport2\>SID=\&ltmyservice2\>)

Case 2 : While using “oracle.jdbc.driver.OracleDriver”

JDBC URL field should contain –
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=\&ltmyhost1\>)(PORT=\&ltmyport1\>))(SERVICE_NAME=\&ltmyservice1\>))(ADDRESS=(PROTOCOL=TCP)(HOST=\&ltmyhost2\>)(PORT=\&ltmyport2\>))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVICE_NAME=\&ltmyservice2\>)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180))))

How to specify JDBC URL in BusinessConnect for Oracle RAC(Load Balanced) environment ?