远端数据库 ：Linux Advanced Server2.1 + Oracle8.1.6.0
Local DB：Local db( Windows ) + application
分布式数据库：Local DB 通过db link 连接到远端数据库
这种 Error 好像每隔一些时间发生一次， 可是仅仅在某个时候比较严重，导致application 执行有问题 。 Application 连接执行很少发生异常，但alert 中error 很多 。 即 application 出现这种异常，肯定有alert error log ； 但是有error alert log ， 不一定会出现application 执行异常 。
local host alert log：
--------------------------------------------------------------
Fri Jul 30 12:05:28 2004
Thread 1 advanced to log sequence 26973
Current log# 2 seq# 26973 mem# 0: D:\ORACLE\ORADATA\INTEL\REDO02A.LOG
Current log# 2 seq# 26973 mem# 1: F:\ICTDATA\REDO02B.LOG
Fri Jul 30 12:05:28 2004
ARC0: Beginning to archive log# 1 seq# 26972
ARC0: Completed archiving log# 1 seq# 26972
Fri Jul 30 12:13:23 2004
Errors in file d:\Oracle\admin\intel\bdump\intelRECO.TRC:
ORA-02068: following severe error from INTELDB
ORA-03113: end-of-file on communication channel
Fri Jul 30 12:13:23 2004
Errors in file d:\Oracle\admin\intel\bdump\intelRECO.TRC:
ORA-02068: following severe error from INTELDB
ORA-03113: end-of-file on communication channel
Fri Jul 30 12:13:23 2004
Errors in file d:\Oracle\admin\intel\bdump\intelRECO.TRC:
ORA-02068: following severe error from INTELDB
ORA-03113: end-of-file on communication channel
Fri Jul 30 12:13:23 2004
Errors in file d:\Oracle\admin\intel\bdump\intelRECO.TRC:
ORA-02068: following severe error from INTELDB
ORA-03113: end-of-file on communication channel
其中提到的intelRECO.TRC文件内容
----------------------------------------------------------------------------------------------------------
d:\Oracle\admin\intel\bdump\intelRECO.TRC部分内容：
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: intel
Redo thread mounted by this instance: 1
Oracle process number: 8
Windows thread id: 1752, image: ORACLE.EXE
ERROR, tran=1.18.157642, session#=1, ose=0:
ORA-02068: following severe error from INTELDB
ORA-03113: end-of-file on communication channel
Dump file d:\Oracle\admin\intel\bdump\intelRECO.TRC
Fri Jul 30 10:32:56 2004
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: intel
Redo thread mounted by this instance: 1
Oracle process number: 7
Windows thread id: 1924, image: ORACLE.EXE
*** SESSION ID
6.1) 2004-07-30 10:32:56.871
*** 2004-07-30 10:32:56.871
ERROR, tran=5.14.149930, session#=1, ose=0:
ORA-02068: following severe error from INTELDB
ORA-03113: end-of-file on communication channel
*** 2004-07-30 10:32:57.136
ERROR, tran=4.25.149887, session#=1, ose=0:
ORA-02068: following severe error from INTELDB
ORA-03113: end-of-file on communication channel
*** 2004-07-30 10:32:57.230
ERROR, tran=2.16.150710, session#=1, ose=0:
ORA-02068: following severe error from INTELDB
ORA-03113: end-of-file on communication channel
*** 2004-07-30 10:32:57.355
ERROR, tran=4.8.151051, session#=1, ose=0:
ORA-02068: following severe error from INTELDB
ORA-03113: end-of-file on communication channel
*** 2004-07-30 10:32:57.464
ERROR, tran=1.9.149089, session#=1, ose=0:
ORA-02068: following severe error from INTELDB
ORA-03113: end-of-file on communication channel
*** 2004-07-30 10:32:57.574
ERROR, tran=6.6.151876, session#=1, ose=0:
ORA-02068: following severe error from INTELDB
ORA-03113: end-of-file on communication channel
*** 2004-07-30 10:32:57.699
ERROR, tran=1.14.150084, session#=1, ose=0:
ORA-02068: following severe error from INTELDB
ORA-03113: end-of-file on communication channel
。。。。。。。。。。。
*** 2004-07-30 14:21:25.925
ERROR, tran=6.6.151876, session#=1, ose=0:
ORA-02068: following severe error from INTELDB
ORA-03113: end-of-file on communication channel
*** 2004-07-30 14:21:26.050
ERROR, tran=1.14.150084, session#=1, ose=0:
ORA-02068: following severe error from INTELDB
ORA-03113: end-of-file on communication channel
*** 2004-07-30 14:21:26.175
ERROR, tran=1.18.157642, session#=1, ose=0:
ORA-02068: following severe error from INTELDB
ORA-03113: end-of-file on communication channel
-----------------------------------------------------------------------------------
而远端数据库系统alert log 文件这段时间内没有问题 。
alert log --- normal
-----------------------------------------------------------------
Fri Jul 30 10:50:11 2004
Current log# 10 seq# 5449 mem# 0: /u01/redo10a.log
Current log# 10 seq# 5449 mem# 1: /u06/redo10b.log
Fri Jul 30 10:50:18 2004
ARC3: Completed archiving log# 9 seq# 5448
Fri Jul 30 11:18:45 2004
Thread 1 advanced to log sequence 5450
Current log# 11 seq# 5450 mem# 0: /u01/redo11a.log
Current log# 11 seq# 5450 mem# 1: /u06/redo11b.log
Fri Jul 30 11:18:45 2004
ARC1: Beginning to archive log# 10 seq# 5449
ARC1: Completed archiving log# 10 seq# 5449
Fri Jul 30 12:15:08 2004
Thread 1 advanced to log sequence 5451
Fri Jul 30 12:15:08 2004
ARC3: Beginning to archive log# 11 seq# 5450
Fri Jul 30 12:15:08 2004
Current log# 12 seq# 5451 mem# 0: /u01/redo12a.log
Current log# 12 seq# 5451 mem# 1: /u06/redo12b.log
Fri Jul 30 12:15:14 2004
ARC3: Completed archiving log# 11 seq# 5450
Fri Jul 30 12:56:48 2004
Thread 1 advanced to log sequence 5452
Current log# 13 seq# 5452 mem# 0: /u01/redo13a.log
Current log# 13 seq# 5452 mem# 1: /u06/redo13b.log
|
