RIB Transactions Fail with "ORA-24756: Transaction Does Not Exist" (Doc ID 2462657.1)

Last updated on OCTOBER 12, 2022

Applies to:

Symptoms

RIB transactions getting failed and reported with ORA-24756 error:

From the Database, the recommendations was to review timeouts from the application:

The external Transaction Manager, in this case Weblogic, should be in control of XA transactions, so please review timeout settings.

The general recommendation per <Note 338880.1> is:
Global transaction timeout < Session timeout, or SesTm < distributed_lock_timeout (Oracle database)

specifically: global transaction timeout -->  600
                  session timeout --> 600
                 distributed_lock_timeout:
SQL> alter system set distributed_lock_timeout=value scope=spfile;

Changes

Cause

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