XAResource#commit() Returns XA_NOTA (ORA-24756) Instead of XA_HEURMIX (ORA-24766) After Upgrade to JDBC Thin 11.2

(Doc ID 2003174.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

JDBC - Version and later
Information in this document applies to any platform.


 After upgrading to JDBC Thin 11.2, XAResource#commit() returns XA_NOTA (ORA-24756) instead of XA_HEURMIX (ORA-24766).

 According to <Bug 6881212> - XA HEURISTIC ERROR CAUSE -7 (XAER_RMFAIL) AFTER PATCH#5721063 IS APPLIED , it is expected that XAResource#commit() returns XA_HEURMIX in the following cases:

  JDBC XA                                         Oracle Server
  some DMLs
                                                  * Rollback Force
  xa_commit()  <-- XA_HEURMIX is expected, but XA_NOTA is returned.

 The issue happens with the THIN driver. JDBC OCI returns XA_HEURIMIX in the above case.


 Upgrade JDBC Thin driver to 11.2 or above.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms