Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help! Distributed cleanup?
Called Oracle on this one. We were able to clean things up by executing
a dbms_transaction.rollback_force('Local_tran_id') from looking at
dba_2pc_pending.
However, if anyone has any insight as to how I would end up with distributed
transactions in doubt I would appreciate it. We do use a gateway. Otherwise
there is nothing distributed about it.
Doug Cowles wrote:
> 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 Tue Aug 24 1999 - 08:54:33 CDT