Loopback Dblink Errors : ORA-02050 / ORA-03113; RECO Reports ORA-24756: transaction does not exist

(Doc ID 1270327.1)

Last updated on MAY 05, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.2.0.2.0 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Loopback database link connections are failing with errors:

Error stack returned to user:
ORA-02050: transaction 1.27.33415 rolled back, some remote DBs may be in-doubt
ORA-03113: end-of-file on communication channel
Sun Oct 17 07:59:16 2010
DISTRIB TRAN QUODPROD.18f9d452.1.27.33415
is local tran 1.27.33415 (hex=01.1b.8287)
insert pending collecting tran, scn=89373741 (hex=0.0553bc2d)
Sun Oct 17 07:59:16 2010
Errors in file /q01/oracle/admin/quodprod/bdump/quodprod_reco_14858.trc:
ORA-24756: transaction does not exist

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