Question: During an update I got
this message ORA-02050: transaction xxx rolled back, some remote DBs may
be in-question. How to I
fix the ORA-02050 error?
Answer:
The ORA-02050 is for distributed updates, over a database link,
and it's often the result of losing connectivity during an update:
ORA-02050: transaction string rolled
back, some remote DBs may be in-question
Cause: network or remote failure in 2PC.
Action: Notify operations; remote DBs will automatically
re-sync when the failure is repaired.
The root cause of this is a network failure, not
Oracle. Read this on the
two phase commit
for details:
First, you need to clean any in-flight transaction that may have failed
by querying dba_2pc_pending:
select * from dba_2pc_pending;
Since the root cause is a network failure, get your Network
Administrator to monitor the network with netstat, looking for
lost packets or other network errors.
