重庆思庄Oracle、Redhat认证学习论坛

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

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





欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2