Help! Distributed cleanup?

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Mon, 23 Aug 1999 13:15:45 -0400
Message-ID: <37C181C1.36F81C2E@bigfoot.com>

Our system is not really distrubuted, or so I thought.. but a user got an
error ORA-01591, which according to oerr, means that there is a problem with
a distributed transaction and to look at pending_trans$; Sure enough, there
is an entry - but I don't know how to drill around to find out what to do.
The entry given by the table is
local_tran_id = 19.36.2410, and it tells be the osuser , the dbuser, something called
global_trans, but how do I drill this down to a transaction or session? How to recover?
I queried dba_2pc_neighbors, and found this -

19.36.2420             in
                            APPS                           N
       1 0000

19.36.2420             out DB2P.WORLD
                            ARC                            C C2DB2
       1 4

DB2P.WORLD is a database link, and it would appear is involved in this? Can
anyone help be diagnose this? Thanks.. Oracle Financials 10.7 on 7.3.3 Received on Mon Aug 23 1999 - 12:15:45 CDT