| ORA-02050: transaction 8.5.5627 rolled back, some remote DBs may be in-doubt [message #402915] |
Wed, 13 May 2009 01:59  |
 |
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
Hi,all
I am using dblink to connect one of my remote DB.
It`s working fine.But after some time,due to the network failure the following errors ocured.
This is from 9.2.0.1.0 version.
ERROR:
ORA-02050: transaction 8.5.5627 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from PRODUCT
ORA-03113: end-of-file on communication channel
ERROR:
ORA-02050: transaction 7.18.20700 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from PRODUCT
ORA-03135: connection lost contact
| Quote: | ORA-02050: "transaction %s rolled back, some remote DBs may be
in-doubt"
Cause: Network or remote failure in 2PC.
Action: Notify operations; remote DBs will automatically re-sync
when the failure is repaired.
|
I Googled for this Error,But thats not clear for me.Please Explain.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-02050: transaction 8.5.5627 rolled back, some remote DBs may be in-doubt [message #403019 is a reply to message #402991] |
Wed, 13 May 2009 08:46  |
|
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
Hi,Michel thanks for your reply.
I know that
| Quote: | Quote:
A transaction is a logical unit of work that contains one or more SQL statements.
|
| Quote: | I mean how we can know the transaction type(Which kind of dml or ddl on which object) based on transaction number
|
But what i mean is that,
Is there any way to find the transaction types(N Number) based on the transaction number.
Lets say for Example
If I am executing some group of sql statements,and not committed,then after some time, due to the network failure, the error occured. Now i want those statements based on the transaction number, which are rollbacked because of the Error.For this kind of Task, is there any way from Oracle?
Thanks& Regards
Sriram
[Updated on: Wed, 13 May 2009 08:50] Report message to a moderator |
|
|
|
| Re: ORA-02050: transaction 8.5.5627 rolled back, some remote DBs may be in-doubt [message #403020 is a reply to message #403019] |
Wed, 13 May 2009 09:04 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: | If I am executing some group of sql statements,and not committed,then after some time, due to the network failure, the error occured. Now i want those statements based on the transaction number, which are rollbacked because of the Error.For this kind of Task, is there any way from Oracle?
|
Only Log Miner can do it for you in your version and even then you will not have the original statements but equivalent ones that to the same modifications. Of course, you will not have remote modifications.
Regards
Michel
[Updated on: Wed, 13 May 2009 09:16] Report message to a moderator |
|
|
|
|
|
|
|
| Re: ORA-02050: transaction 8.5.5627 rolled back, some remote DBs may be in-doubt [message #403160 is a reply to message #403059] |
Thu, 14 May 2009 00:12 |
|
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
SQL> select count(*) from DBA_2PC_PENDING;
COUNT(*)
----------
0
SQL> select * from DBA_2PC_PENDING;
no rows selected
SQL> select * from DBA_2PC_NEIGHBORS;
no rows selected
SQL>
But i can say one thing.Before error there are 6205 records in one table @my local DB which is populated through my script (not committed records) But after Error there are 0 rows in the same table@local DB so only the insert statements are roll backed.Each and every transaction is different from each session right?even though we are using db links....so if any thing goes wrong with the current session,then current sessions transactions should be roll backed.So there is no chance of rollback at remote, As we are only selecting records from remote and insert at local Db.Is my assumption correct?
Thanks
Sriram
[Updated on: Thu, 14 May 2009 00:14] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
