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 11.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

 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
  ----------------------------------------------------------------
  xa_start()
  some DMLs
  xa_end()
  xa_prepare()
                                                  * 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.

Changes

 Upgrade JDBC Thin driver to 11.2 or above.

Cause

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