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 06, 2017

Applies to:

Oracle Services for Microsoft Transaction Server - Version 11.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 07-Mar-2017***

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

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