There are several ways to automatically reconnect the database to tuxedo Xa (Doc ID 2266332.1)

Last updated on MAY 17, 2017

Applies to:

Oracle Tuxedo - Version 11.1.1.2.0 and later
Information in this document applies to any platform.

Goal

 Customer's tuxedo production environment database restart, the transaction business can automatically re-connect the database, query class business can not automatically reconnect. The difference between the two types of business is as follows:

Transaction business: tuxedo client in the following order: tpbegin tpcall tpcommit. Client tpcall server services, the service is called on the database dml operation.
Query service: The tuxedo client only executes the tpcall function. Client tpcall server service is called the service of the database select operation.
The transaction business is carried out after the implementation of tpbegin, tpbegin in xa operation will automatically re-connect to the database.
Query business is directly call the server, the server directly exec sql select ....., the server code in the srvinit method tpopen, other places no reconnect action.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms