问题描述:
河南在2009年4月28日早09:23出现柜面交易如CDM,FIX,CARDTLR等服务堵塞,且排队不断增加,后通过down掉FIX、CARDTLR服务后使资源得到释放,在事后的分析中,我们发现在出现异常堵塞时,产生了tuxedo和数据库通讯异常的日志,xa_NULL02232009.trc,查看日志内出现问题的pid,发现均为绿卡通的相关服务id
日志内容是多个:
092345.4210884.0:
xaostart: XAER_NOTA; RESUME|JOIN and can't switch txn
ORACLE XA: Version 9.2.0.1.0. RM name = 'Oracle_XA'.
092438.3817644.0:
ORA-24756: 事务处理不存在
分析:
查看数据库alert_*.log (back)日志:
ue Apr 28 09:28:24 2009
Undo Segment 35 Onlined
Tue Apr 28 09:28:24 2009
Undo Segment 36 Onlined
Tue Apr 28 09:28:24 2009
Undo Segment 37 Onlined
Tue Apr 28 09:28:25 2009
Created Undo Segment _SYSSMU60$
Tue Apr 28 09:28:25 2009
Created Undo Segment _SYSSMU61$
Tue Apr 28 09:28:25 2009