Open topic with navigation

TIBCO BusinessEvents® Enterprise Edition 6.3.1

# Oracle Real Application Cluster (RAC)

Oracle Real Application Cluster (RAC) supports both thin and OCI drivers.

The sample connection string for a thin driver is:

    jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
    (ADDRESS=(PROTOCOL=TCP)(HOST=10.107.146.70) (PORT=1521))
    (ADDRESS=(PROTOCOL=TCP)(HOST=10.107.146.71) (PORT=1521))
    (CONNECT_DATA=(SERVICE_NAME=TIBQADB)))

Failover mode is supported with the basic and preconnect methods.

The sample connection string for an OCI driver is:

    jdbc:oracle:oci:@net_service_name

When using an OCI driver, Transparent Application Failover (TAF) is supported.

You can configure a Single Client Access Name (SCAN) for an Oracle database in a cluster with numerous nodes. SCAN is a feature of Oracle Real Applications Clusters (RAC) 11g, which provides a single name for clients to access Oracle Databases running in a cluster. You can configure SCAN during the installation of Oracle Grid Infrastructure. Once configured, application tier connection descriptors specify the SCAN name instead of all the virtual hosts in the cluster.

You can specify the SCAN name as follows: `VISION = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=C-SCAN)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VISION)))`

For more information, see the Oracle documentation.

For a thin driver, the sample SCAN connection string is as follows:

    jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=engrac-scan)(PORT=1521))(CONNECT_DATA
    =(SERVER = DEDICATED)(SERVICE_NAME = TIBQADB)))

For an OCI driver, the sample SCAN connection string is as follows:

    jdbc:oracle:oci:@TIBQADB

The sample TNSNames.ora file for the above URL is as follows:

    TIBQADB =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = engrac-scan)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = TIBQADB)
    )
    )

Note: See JDBC Connection Reference for details of the database URL of a shared JDBC connection.

Did you find this helpful?

YesNo
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO BusinessEvents® Enterprise Edition

Copyright © 2004-2024. Cloud Software Group, Inc. All Rights Reserved.