Re: ORA-02050

On Tue, Nov 05, 2002 at 06:33:44AM -0800, John.Hallas_at_vodafone.co.uk wrote:
> Ray,
> I think you need to check DBA_2PC_PENDING on both the local and remote
> database to see if anything is still in there.
> That gives the osuser, terminal and host name so you may be able to get
> something from that.
> Of course if there is nothing in that table then the transaction has been
> rolled back already

Right, nothing there, so I was wondering if there was a way to chase the transaction id to app, such as archivelog. 8.1.7.4 here.

Thanks.

> John
>
> -----Original Message-----
> Sent: 05 November 2002 13:43
> To: Multiple recipients of list ORACLE-L
>
>
>
> ORA-02050: transaction 8.82.26033 rolled back, some remote DBs may be
> in-doubt
>
> The transaction seems to have completely rolled back. My
> question is, is there any way to relate transaction id 8.82.26033
> to an application or table row or something at a higher layer?
>
> Thanks.
> ===============================================================
> Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ray Stell
> INET: stellr_at_cns.vt.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: John.Hallas_at_vodafone.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
===============================================================
Ray Stell   stellr_at_vt.edu     (540) 231-4109     KE4TJC    28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: stellr_at_cns.vt.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).