Re: ORA-02050

On Tue, Nov 05, 2002 at 09:24:04AM -0800, Yechiel Adar wrote:
> There is another view, DBA_2PC_NEIGHBORS.
> Maybe there is some info there.

No, the transaction was rolled back completely, or perhaps it resynced when the remote db recovered and thus covered the tracks. This is a good thing.

I am wondering if I can find the app that was hit. I'm just curious, not trying to recover. Otherwise, flames would be coming from my hair. ;)

>
> Yechiel Adar
> Mehish
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, November 05, 2002 5:58 PM
>
>
> > 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Yechiel Adar
> INET: adar76_at_inter.net.il
>
> 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).