ORA-24774 failing OracleXAResource.start in JWS

Solution Verified - Updated -

Issue

  • JWS configured to use the Tomcat JDBC Connection Pool with Narayana as transaction coordinator
  • Two Oracle pools are configured to permit different users to access the same database server/SID
  • In a single XA transaction with a connection from each of these pools, the second connection that is used fails with the error below

    ... ARJUNA016089: TransactionImple.enlistResource - xa_start  - caught: XAException.XAER_RMERR for < ... >
        oracle.jdbc.xa.OracleXAException: XAErr (-3): A resource manager error has occured in the transaction branch. ORA-24774 SQLErr (0)
                at oracle.jdbc.xa.OracleXAResource.checkError(...)
                at oracle.jdbc.xa.client.OracleXAResource.start(...)
                at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(...)
                at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(...)
                at org.apache.tomcat.dbcp.dbcp2.managed.TransactionContext.setSharedConnection(...)
                at org.apache.tomcat.dbcp.dbcp2.managed.ManagedConnection.updateTransactionStatus(...)
                at org.apache.tomcat.dbcp.dbcp2.managed.ManagedConnection.<init>(...)
                at org.apache.tomcat.dbcp.dbcp2.managed.ManagedDataSource.getConnection(...)
                at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(...)
                ...
    

Environment

  • Red Hat JBoss Web Server (JWS) 5
  • Red Hat Process Automation Manager 7 (when process server deployed in JWS)
  • Tomcat JDBC Connection Pool
  • Oracle

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In