(Doc ID 1106793.1)

Last updated on MAY 15, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.1 to 12.1]
Information in this document applies to any platform.
Add ***Checked for relevance on 09-Sept-2013***
The following note just applies to releases onwards.
The following issue only appears on RAC installations with at least 2 nodes.


According to documentation your GLOBAL_TXN_PROCESSES is set to a value higher than 0 (1 is default) on all the instances of the RAC and your XA application does connect to database through a service which has not been defined as a DTP service.

The service that is being used by XA application is not a singleton service, so it does load balancing on connections.

Your XA application has created a transaction branch connected to database and then detached this branch. When a different Resource Manager or XA process tries to attach this transaction branch, it may fail with error:

ORA-24798: cannot resume the distributed transaction branch on another instance


There have not been errors on detaching the transaction branch.

The error will appear if the resource manager trying to resume/join the branched transaction is connected to a different instance as the resource manager that created the transaction.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms