Oracle Solution for Error ora-02051

ORA-02051: another session in same transaction failed

What triggered the Error:

a session at the same site with same global transaction ID failed; It can also be caused by application error if an attempt was made to update database while another tightly coupled transaction branch with same global transaction ID has been finalized.

What should we do to fix it:

none necessary, transaction automatically recovered. In case of application error, make sure no more updates to database once transaction manager has started two-phase commit for tightly coupled distributed transaction.