ORA-24774 failing OracleXAResource.start in JWS

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(...)
              ...