What are the ways to auto-reconnect databases with tuxedo Xa?
(Doc ID 2605415.1)
Last updated on NOVEMBER 05, 2020
Applies to:Oracle Tuxedo - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
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.
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