This morning we saw a lot of the following errors in the alert log.
Thu Nov 10 09:00:01 CST 2005
ORA-02050: transaction 10.44.117686 rolled back, some remote DBs may be in-doubt
ORA-03106: fatal two-task communication protocol error
ORA-02063: preceding line from INFOTECP
ORA-02068: following severe error from INFOTECP
ORA-03113: end-of-file on communication channel
Basically, what does it mean? What is 10.44.117686?
How to resolve this error?
11-10-2005, 12:34 PM
Means you got a distributed transaction that has failed. You will probably have to clean it up. Look at metalink, there's about 100 notes on how to do it...
11-10-2005, 04:56 PM
10.44.117686 is the transaction ID, If I am not mistaken.
Next time you get an error, query from
select * from DBA_2PC_PENDING;
select * from sys.PENDING_TRANS$;
And post the result here.
11-10-2005, 05:12 PM
Never mind, I just wrote something stupid, so I deleted it myself...
11-11-2005, 12:05 AM
Thanks for the input.
The results from two queries are as follows:
SQL> exec p ( ' select * from dba_2pc_pending where LOCAL_TRAN_ID = ''10.44.117686''');
I have some questions:
1)The error in the alert log says the transaction roll back. but the query shows the commit# is 947647425. Does this mean it already committed?
2)This transaction is still in the sys.pending_trans$, does this mean
this transaction is still pending?
3) Our current practice is that we just jgnore the alert errors and do nothing. Is this practice good or bad? What should we dba do?