Configuring for an Oracle RAC failover In TIBCO BusinessEvents.
Article ID: KB0090575
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessEvents Enterprise Edition | - |
| Not Applicable | - |
Description
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))))
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))))
Issue/Introduction
Configuring for an Oracle RAC failover In TIBCO BusinessEvents.
Feedback
Yes
No
Powered by
