New XA feature of Oracle 8 About Local Transactions (Doc ID 767793.1)

Last updated on NOVEMBER 27, 2016

Applies to:

Oracle Tuxedo - Version 6.5 to 12.1.1
Information in this document applies to any platform.
Information in this document applies to any platform


Goal

After the error below, a new SQL statement can open an Oracle 8 local transaction and after all new calls can't work.

ULOG file:

gtrid x0 x39aa0c45 x47d5 TRACE:xa } xa_start = -4


Oracle traces:

> 095500.20969.0OCITransStart Attempting
> 095500.20969.0ORA-24756 transaction does not exist
> 095500.20969.0xaostart XAER_NOTA; RESUME|JOIN and can't switch txn


All new calls receive this return code :

ULOG file:

gtrid x0 x39aa0c45 x47dc TRACE:xa } xa_start = -9


Oracle traces:
 

> 095500.20969.0OCITransStart Attempting
> 095500.20969.0ORA-24776 cannot start a new transaction
> 095500.20969.0xaostart XAER_OUTSIDE; session in local transaction

Solution

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