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

Last updated on NOVEMBER 15, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.