My Oracle Support Banner

What are the ways to auto-reconnect databases with tuxedo Xa? (Doc ID 2605415.1)

Last updated on NOVEMBER 15, 2023

Applies to:

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

Goal

At present, the customer production environment tuxedo finds that when the database is restarted, the transaction type service can automatically reconnect to the database, and the query type service cannot be reconnected automatically. The differences between the two types of services are as follows:
Trading business: tuxedo client tpbegin tpcall tpcommit. tpcall server dml operation on the database
Query class service: tuxedo client tpcall tpcall server select operation on the database
In other words, the transaction service is executed under tpbegin. The query service directly calls the server. The server directly exec sql select....., the server code has tpopen in the srvinit method, and there is no reconnection logic in other places.

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution

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