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 JUNE 05, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.