标题: Error 2396 Trapped In 2PC On Transaction xid. Cleaning Up [打印本页] 作者: 刘泽宇 时间: 2021-4-4 17:04 标题: Error 2396 Trapped In 2PC On Transaction xid. Cleaning Up 在12.1.0.2及以上版本的数据库中,可能会出现这样的报错:
Error 2396 trapped in 2PC on transaction 62.13.607. Cleaning up.
Error in cleaning up 2PC subordinates; error stack:
ORA-01012: not logged on
ORA-02063: preceding line from <dblink>
ORA-02396: exceeded maximum idle time, please connect again
ORA-02063: preceding line from <dblink>
DISTRIB TRAN CCBPRD.828b1d56.62.13.607
Error received from <dblink>
造成出现这样的提示的原因是(参照官方文档ID:2592367.1):
Indoubt distributed transaction due to dblink disconnect, which was because of incorrect IDLE_TIME setting
不正确的空闲时间设置造成的dblink断开连接引起未处理分布式事务