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断开连接引起未处理分布式事务

解决方法是：
将空闲时间设置为不限制
如：ALTER PROFILE <profile_name> LIMIT IDLE_TIME UNLIMITED