Resolution:
Description:
===========
Configuring for an Oracle RAC failover In TIBCO BusinessEvents.

Environment:
==========
TIBCO BusinessEvents 3.0.3,4.0.x and above


Resolution:
=========

1). Database URL : 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=TIBQADB)))

2). Database URL :   jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = HOST1)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = HOST2)(PORT = 1521)))(FAILOVER=on)(LOAD_BALANCE=yes)(CONNECT_DATA =(SERVER=DEDICATED)(SERVICE_NAME = TIBQADB)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))