ORA-24774 / ORA-24798 failing OracleXAResource.start in JBoss EAP

Issue

• Multiple Oracle xa-datasource pools defined referencing the same backing database instance

• Failure when multiple connections (different datasources, same backing database instance) enlisted in a single XA transaction

  ... WARN ... IJ000305: ... oracle.jdbc.xa.OracleXAException
      at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1229)
      at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:246)
      at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:259)
      at org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.start(XAResourceWrapperImpl.java:215)
      at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:741)
      at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:423)
      at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.enlist(TxConnectionListener.java:986)
      at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:379)
      at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:553)
      at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:928)
      at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:750)
      at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:138)
      at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:66)
      at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:139)
      at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:380)
  ...
  Caused by: java.sql.SQLException: ORA-24774: cannot switch to specified transaction
  
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:385)
      at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1018)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
      at oracle.jdbc.driver.T4CTTIOtxse.doOTXSE(T4CTTIOtxse.java:164)
      at oracle.jdbc.driver.T4CXAResource.doStart(T4CXAResource.java:188)
      at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:241)
      ...
  

• In some cases the initial Oracle error is

  ... java.sql.SQLException: ORA-24774: cannot switch to specified transaction
  
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:385)
      at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1018)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
      at oracle.jdbc.driver.T4CTTIOtxse.doOTXSE(T4CTTIOtxse.java:164)
      at oracle.jdbc.driver.T4CXAResource.doStart(T4CXAResource.java:188)
      at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:241)
      ...
  

• The enlistment failure leaves the transaction in an ABORT_ONLY state which leads to other failures subsequently.