Oracle Requirements for XA in RAC Environment

Solution Unverified - Updated -

Issue

  • A WARN log statement that prevents an XA Transaction
<DATE> <TIME> WARN  [org.jboss.resource.connectionmanager.TxConnectionManager] (main) Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@7acd4643[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@3ac017b1 handles=0 lastUse=1386874442730 permit=true trackByTx=true mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@6994bab7 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@19538399 xaResource=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@3ac017b1 txSync=null]
oracle.jdbc.xa.OracleXAException
    at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1110)
    at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:240)
    at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:213)
  • Enabling trace in Oracle driver gives more context
SEVERE [oracle.jdbc.driver] (main) 7907F614 Throwing SQLException: ORA-55712: XA transactions on RAC are not supported with GLOBAL_TXN_PROCESSES set to 0

Environment

  • Red Hat Enterprise Application Platform (EAP) 5.2.0

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.