Distributed Transactions with MSDTC Using ORAMTS Fail With: ORA-1591 and ORA-24756 After an Upgrade to 11.2.0.2
(Doc ID 1346669.1)
Last updated on MARCH 04, 2022
Applies to:
Oracle Services for Microsoft Transaction Server - Version 11.2.0.2 and laterInformation in this document applies to any platform.
Symptoms
The following errors are occurring in 11.2.0.2 of Oracle Services for Microsoft Transaction Server which did not occur previously in 11.2.0.1:
"ORA-01591: lock held by in-doubt distributed transaction" occurs on client side.
In the database alert log the following is shown:
DISTRIB TRAN 44444444.575995E743E2944B872845731F4AB18100000000
is local tran 5.20.22059 (hex=05.14.562b)
insert pending prepared tran, scn=30320569 (hex=0.01cea7b9)
...
...
ORA-24756: transaction does not exist
The corresponding oramts trace is showing garbage characters and failing with:
[04/14/2011-13:31:28:088][00001310] kpntcheckerr() - OCI_ERROR - 12154.
[04/14/2011-13:31:28:088][00001310] kpntcheckerr() - ORA-12154: TNS:couldnot resolve the connect identifier specified
Changes
Upgrade to 11.2.0.2 from 11.2.0.1.
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |