有一中心数据库:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
几个分中心:
1.Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for DEC OSF/1 AXP: Version 8.1.7.0.0 - Development
NLSRTL Version 3.4.1.0.0 - Production
2.Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
3.Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for Linux: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production在中心通过数据库链路查询相关信息,大部分时间可正常查询,偶尔出以下错误请高手解答:
ORA-02068: 以下严重错误源于 xxxxxx(数据库链路名)
ORA-03113: 通信通道的文件结束
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
几个分中心:
1.Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for DEC OSF/1 AXP: Version 8.1.7.0.0 - Development
NLSRTL Version 3.4.1.0.0 - Production
2.Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
3.Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for Linux: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production在中心通过数据库链路查询相关信息,大部分时间可正常查询,偶尔出以下错误请高手解答:
ORA-02068: 以下严重错误源于 xxxxxx(数据库链路名)
ORA-03113: 通信通道的文件结束
2 不要在8i, 9i(不同版本)间建dbLink
-- Oracle 内部错误
-- 防火墙的问题
-- 其它原因
Mon Nov 03 15:02:28 2003
DISTRIB TRAN ORAL.US.ORACLE.COM.cd8d9e03.9.41.59431
is local tran 9.41.59431 (hex=09.29.e827))
delete pending collecting tran, scn=991831158 (hex=0.3b1e2476)
Mon Nov 03 15:21:20 2003
Error 2068 trapped in 2PC on transaction 10.41.57734. Cleaning up.
Error stack returned to user:
ORA-02050: 事务处理10.41.57734已重算,某些远程 DBs 可能有问题
ORA-02068: 以下严重错误源于XXXXXXXX(链路名)
ORA-03113: 通信通道的文件结束
Mon Nov 03 15:21:20 2003
DISTRIB TRAN ORAL.US.ORACLE.COM.cd8d9e03.10.41.57734
is local tran 10.41.57734 (hex=0a.29.e186)
insert pending collecting tran, scn=993609531 (hex=0.3b39473b)
Mon Nov 03 15:57:55 2003
DISTRIB TRAN ORAL.US.ORACLE.COM.cd8d9e03.2.17.59845
is local tran 2.17.59845 (hex=02.11.e9c5))
delete pending collecting tran, scn=991832094 (hex=0.3b1e281e)
Mon Nov 03 16:05:41 2003
Error 2068 trapped in 2PC on transaction 9.31.59472. Cleaning up.
Error stack returned to user:
ORA-02050: 事务处理9.31.59472已重算,某些远程 DBs 可能有问题
ORA-02068: 以下严重错误源于XXXXXXXX(链路名)
ORA-03113: 通信通道的文件结束
Mon Nov 03 16:05:41 2003
DISTRIB TRAN ORAL.US.ORACLE.COM.cd8d9e03.9.31.59472SID都是ORACL是否有问题
dba_2pc_pending视图中没有数据
网络问题不大用ping命令试验延时在10ms左右很稳定
通过客户端用SQL*PLUS连接主服务器,大概闲置5分钟就会报:ora-03113错误