Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# Setting Up Oracle Transparent Application Failover (TAF)

## Status

If you are... | This task is...
Installing a new iProcess Engine Version 11.9.0 | Optional or Required (see )
Upgrading from an iProcess Engine Version 11.0 or later | Optional or Required (see )

## Database

Oracle

## Description

Oracle TAF enables an application user (such as the iProcess Engine) to automatically reconnect to a database if the connection fails. If you are running parallel servers, using TAF can allow the iProcess Engine to switch to an alternative instance if the one that it is using fails. Even if you are not using parallel servers, using TAF still means that although the iProcess Engine will not function while the database is down, it can recover immediately and automatically when the database is recovered.

Note |
| • | TIBCO strongly recommends the use of Oracle TAF with iProcess Engine to provide 24*7 resilient operation. If you are deploying iProcess Engine for user acceptance testing (UAT) or to a production environment, you must enable TAF.
For more information about how the iProcess Engine supports database failover, see TIBCO iProcess Engine Architecture Guide.
| • | You should not use TAF to protect the iProcess Engine from a scheduled Oracle shutdown.
| • | The standard Oracle client connection is not protected by TAF. Therefore, if a failover occurs, iProcess Engine Workspace users may need to log in again.

To enable the use of TAF with the iProcess Engine, you need to configure TAF support for the service name that you intend to use to connect to the Oracle database.

## Procedure

The procedure you use to set up TAF depends on whether you are using Oracle RAC:

| • | If you are not using Oracle RAC, you must manually configure a net service name that includes the `FAILOVER_MODE` parameter included in the `CONNECT_DATA` section of the connect descriptor.

You must specify at least the `TYPE` and `METHOD` sub-parameters for the `FAILOVER_MODE` parameter.

| • | If you are installing iProcess Engine on one of the nodes of an Oracle RAC, you can use Oracle's Database Configuration Assistant (DBCA) to create a new service that will use TAF. DBCA will update all the `tnsnames.ora` files for the instances you choose to be in the Oracle RAC. If your iProcess Engine is connected via an Oracle client to the Oracle RAC, you can copy the changes that DBCA makes to the Oracle database `tnsnames.ora` file to the client's `tnsnames.ora` file.

## See Also

For more information about how to set up TAF, see the following documents in the Oracle documentation set:

| • | Oracle Net Services Administrator’s Guide

| • | Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide (if you are using Oracle RAC)

Did you find this helpful?

Yes No
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 iProcess® Engine

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