Distributed Transaction to Same Instance Fails: ORA-2051 (Doc ID 283616.1)

Last updated on MAY 15, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.4 to 11.2.0.3 [Release 9.2 to 11.2]
Information in this document applies to any platform.


Symptoms

In WebSphere® Application Server 4.0.x, the following exception might be issued when Oracleis
enlisted in an XA transaction:

org.omg.CORBA.TRANSACTION_ROLLEDBACK:
com.ibm.websphere.csi.CSITransactionRolledbackException:
at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java(Compiled
Code))
at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java(Compiled
Code))
...

A WebSphere JTS trace reveals that the transaction is rolled back due to the following exception:

Encountered an XA resource error during an XA end operation: {0} {1}
-3
oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:659)
at oracle.jdbc.xa.client.OracleXAResource.end(OracleXAResource.java:301)
at com.ibm.ejs.jts.jta.XARminst.endAssociation(XARminst.java:365)

This indicates:
XAER_RMERR resource error -3 for Oracle 9i, or
"Io exception: End of TNS data channel", (SQLState=null, vendorCode=17002) for Oracle 8.1.7

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