Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02051 from 4 independent processes using XA

650000Jun 10 2010
Hello,

I am infrequently encountering errors in starting a transaction (tpbegin). In the latest case I observed the following.

1) The XA log reported "ORA-02051: another session in same transaction failed" and "xaosterr: OCITransStart rtn 2051" from 4 independent processes (servers). The processes are in the same GROUP, but otherwise unrelated.

2) Based on the Tuxedo and Application logs I conlude:
- One process was calling tpbegin(), which returned error 14
- One process was starting an AUTOTRAN transaction. The process itself did not report any errors, but the client reported error 14 from tpcall().
- Two processes were starting a new transaction branch. The processes themselves did not report any errors, but the calling servers reported error 10 from tpcall(). In both cases the transaction was started by a TMQFORWARD, an intermediary process reported the tpcall error, and the final process logged the XA error.

I am looking for some hints on how to investigate this further. Because it happens infrequently, turning on more logging (for extended periods) is not a practical option.

Thanks...

Roger
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2010
Added on Jun 10 2010
0 comments
1,132 views