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 <[EMAIL PROTECTED]> > Sent: Tuesday, November 05, 2002 5:58 PM > > > > On Tue, Nov 05, 2002 at 06:33:44AM -0800, [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Ray Stell > > > INET: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ray Stell > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
