Description:
TIBCO Enterprise Message Service 5.0.0 now supports Oracle 10 RAC as an optional data store in addition to the databases listed in the product documentation.

The verification included the use of Oracle 11g Instant Client. This is an optimized light-weight OCI Driver package available from Oracle

(http://www.oracle.com/technology/tech/oci/instantclient/index.html)

Please refer to the product documentation for the other supported databases.

Limitation and Restrictions:
===================

All functionality provided by TIBCO Enterprise Message Service 5.0.0 Multiple Stores feature is supported, however an OCI driver and TAF configuration must be used for

connecting to database.
Please refer to Configuration Changes below for detail.


Installation Steps:
===================

Please use the Windows installation package provided with TIBCO Enterprise Message Service 5.0.0 and follow the instructions as detailed in the respective product

documentation.


Configuration Changes:
==================

1. Ensure an OCI Driver is installed.

2. Ensure the driver files folder (*.so or *.dll) is in the LD_LIBRARY_PATH (for Unix) or PATH (for Windows).

3. If using the Instant Client, use the JDBC driver with JDK 1.5 or JDK 1.6 (ojdbc5.jar or ojdbc6.jar, respectively).

4. To ensure the client doesn’t lose connection to the database during database failover (when one of the database nodes is shutdown), the client must use a TAF

configured URL, which has the format:


jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)(FAILOVER_M

ODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))

5. There is a limitation of 256 characters for the dbstore_driver_url field in stores.conf. Hence, it is recommended to create an alias in tnsnames.ora file for the TAF

connection parameters listed above.


Known Issues:
============

None apart from those identified above and those listed in the TIBCO Enterprise Message Service 5.0.0 Release Notes.

TIBCO Enterprise Message Service 5.0.0 supports Oracle RAC