IBM Support

OracleXAException or XAER_RMERR occurs in WebSphere Application Server DataSource

Troubleshooting


Problem

When a DataSource is used to connect to an Oracle database in WebSphere Application Server, the following exception might be issued when Oracle is enlisted in an XA transaction:
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)...
You may also see XA resource manager errors, XAER_RMERR, in the logs and traces.
The XA exceptions would cause the transaction to roll back, so you would also see TransactionRolledbackExceptions.

[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"ARM Category":[{"code":"a8m50000000CdYAAA0","label":"WebSphere Application Server traditional-All Platforms-\u003EJ2C-ConnectionPooling-JDBCDrivers-\u003EConnection Pooling-J2C-DB Connections-\u003EConnection Pooling"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.5.5;9.0.5"},{"Product":{"code":"SSNVBF","label":"Runtimes for Java Technology"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":"Java SDK","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
03 March 2025

UID

swg21109954