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 laterInformation 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 |