Distributed Transactions with MSDTC Using ORAMTS Fail With: ORA-1591 and ORA-24756 After an Upgrade to 22.214.171.124
Last updated on MARCH 06, 2017
Applies to:Oracle Services for Microsoft Transaction Server - Version 126.96.36.199 and later
Information in this document applies to any platform.
***Checked for relevance on 07-Mar-2017***
The following errors are occurring in 188.8.131.52 of Oracle Services for Microsoft Transaction Server which did not occur previously in 184.108.40.206:
"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] kpntcheckerr() - OCI_ERROR - 12154.
[04/14/2011-13:31:28:088] kpntcheckerr() - ORA-12154: TNS:couldnot resolve the connect identifier specified
Upgrade to 220.127.116.11 from 18.104.22.168.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms