Thanks for the question, Manoj.
Asked: May 14, 2020 - 9:09 pm UTC
Last updated: May 15, 2020 - 2:48 am UTC
Version: 11.2.0.4.0
Viewed 1000+ times
You Asked
Hi Team,
I have a DBMS job which is failing with ORA 02050 error frequently.
DB1 which has the job, is calling a procedure which runs a select query on DB2 through DB link and runs few DML statements in DB1.
When it hits COMMIT, i am getting ORA-02050.
Error message is :
ORA-02050 transaction rolled back some remote DBs maybe in doubt
ORA-02051 another session or branch in same transaction failed or finalized
ORA-06512
I have queried dba_2pc_pending view in DB1 -- couldnt get any data.
In DB2, it is showing few transactions from 2019 in Collecting status
Could you please help me on how to troubleshoot further or any fixes for this issue.
Doing force commit on transactions in DB2 can help? -- However I am not sure that these transactions are between DB1 and DB2.
Thanks in advance
and Connor said...
If DBA_2PC_NEIGHBORS and DBA_2PC_PENDING are empty on both db's (or at least have no recent entries), then it means that RECO has recovered from the problem (ie, both database should be in a consistent state). If not you can purge entries via commit force or rollback force.
In terms of troubleshooting, you could set a system event to dump out more information
ALTER SYSTEM SET EVENT ='2050 trace name errorstack level 3' SCOPE=spfile;
and see what comes out of the trace files when it next occurs.
Is this answer out of date? If it is, please let us know via a Comment