How to configure BW JDBC connection(TIBCO JDBC Driver, DataDirect) to an Oracle 9i RAC database cluster ?

How to configure BW JDBC connection(TIBCO JDBC Driver, DataDirect) to an Oracle 9i RAC database cluster ?

book

Article ID: KB0085731

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Resolution:
A new option called 'AlternateServers', allows a list of additional database servers to be specified. The value of the AlternateServers connection  option is a string that specifies the server name and port  number of alternate servers that can be tried if the primary server is not accepting connections for some reason.

This string  has the format:

AlternateServers= (servername1:port1,servername2:port2, ..., servernameN:portN)

To use the AlternateServers connection option, you must specify the primary ServerName and PortNumber values in the URL or DataSource

Here is an example URL to connect to an Oracle 9i RAC :

jdbc:tibcosoftwareinc:oracle://server1:1521;SID=TEST;AlternateServers=(server2:1521,server3:1521,server4:1521)

Specifying the above URL causes the driver to attempt to connect to the TEST database on server1 using port 1521. If that connection attempt  fails, the driver tries to connect to the TEST database on server2. If that attempt fails, the driver attempts to connect to  server3, and so on, until all servers in the list are tried

Issue/Introduction

How to configure BW JDBC connection(TIBCO JDBC Driver, DataDirect) to an Oracle 9i RAC database cluster ?