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

Last updated on NOVEMBER 15, 2023

Applies to:

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

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