加急，加急，加急！！！，监听出错，TNS-12547，TNS-12560，TNS-00517

Question

系统环境：Oracle7.3+SCO Unix，只有四五个终端连接数据库服务器。终端是window下运行。
现象：在运行一几天后，tcp_listener.log日志出现下面现象，然后监听基本死了，但是如果已经连着的终端还能正常使用，这时候只要一退出就再也连不上了。只有把监听进程杀了，重启监听就可以了，可是过一段时间又出现这个问题了。TNS-12547: TNS:lost contact
 TNS-12560: TNS:protocol adapter error
  TNS-00517: Lost contact
   SCO System V/386 Error: 108: Connection reset by peer着急啊，好几天了，还没找到问题，网上有文档说是listener.log超过2G，可是我这里没这个文件啊，大侠们，帮帮我。

Answer 1

去$ORACLE_HOME/network/log目录下找listener.log文件看

Answer 2

TNSLSNR for SCO System V/386: Version 2.3.3.0.0 - Production on 10-SEP-05 13:21:00Copyright (c) Oracle Corporation 1994.  All rights reserved.System parameter file is /etc/listener.ora
Log messages written to /diskarray/oracle7/network/log/tcp_listener.log
Trace information written to /diskarray/oracle7/network/trace/tcp_listener.trc
Trace level is currently 0Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=100.100.100.7)(PORT=1521))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
10-SEP-05 13:21:00 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=eastair1)(USER=oracle7))(COMMAND=status)(ARGUMENTS=64)(SERVICE=tcp_listener)(VERSION=36712448)) * status * 0
10-SEP-05 13:21:20 * (CONNECT_DATA=(SID=wg73)(CID=(PROGRAM=DMHS.exe)(HOST=Windows NT PC)(USER=zb2))) * (ADDRESS=(PROTOCOL=tcp)(HOST=100.100.100.21)(PORT=1222)) * establish * wg73 * 0
10-SEP-05 15:20:12 * (CONNECT_DATA=(SID=wg73)(CID=(PROGRAM=DMHS.exe)(HOST=Windows NT PC)(USER=zb2))) * (ADDRESS=(PROTOCOL=tcp)(HOST=100.100.100.21)(PORT=1224)) * establish * wg73 * 0
11-SEP-05 01:14:07 * (CONNECT_DATA=(SID=wg73)(CID=(PROGRAM=DMHS.exe)(HOST=Windows NT PC)(USER=zb2))) * (ADDRESS=(PROTOCOL=tcp)(HOST=100.100.100.21)(PORT=1226)) * establish * wg73 * 0
11-SEP-05 03:24:26 * (CONNECT_DATA=(SID=wg73)(CID=(PROGRAM=DMHS.exe)(HOST=Windows NT PC)(USER=zb1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=100.100.100.23)(PORT=1089)) * establish * wg73 * 0
11-SEP-05 03:49:46 * (CONNECT_DATA=(SID=wg73)(CID=(PROGRAM=DMHS.exe)(HOST=Windows NT PC)(USER=zb2))) * (ADDRESS=(PROTOCOL=tcp)(HOST=100.100.100.21)(PORT=1228)) * establish * wg73 * 0
11-SEP-05 04:23:13 * (CONNECT_DATA=(SID=WG73)(CID=(PROGRAM=)(HOST=eastair1)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=100.100.100.7)(PORT=3522)) * establish * WG73 * 0
12-SEP-05 00:31:50 * (CONNECT_DATA=(SID=wg73)(CID=(PROGRAM=DMHS.exe)(HOST=Windows NT PC)(USER=zb1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=100.100.100.23)(PORT=1093)) * establish * wg73 * 0
12-SEP-05 00:36:41 * (CONNECT_DATA=(SID=wg73)(CID=(PROGRAM=DMHS.exe)(HOST=Windows NT PC)(USER=zb1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=100.100.100.23)(PORT=1095)) * establish * wg73 * 0
12-SEP-05 00:38:10 * (CONNECT_DATA=(SID=wg73)(CID=(PROGRAM=DMHS.exe)(HOST=Windows NT PC)(USER=zb1))) * (ADDRESS=(PROTOCOL=tcp)(HOST=100.100.100.23)(PORT=1097)) * establish * wg73 * 0
12-SEP-05 01:43:22 * (CONNECT_DATA=(SID=wg73)(CID=(PROGRAM=DMHS.exe)(HOST=Windows NT PC)(USER=zb2))) * (ADDRESS=(PROTOCOL=tcp)(HOST=100.100.100.21)(PORT=1230)) * establish * wg73 * 0

Answer 3

这是出错前的一段listener.log日志，看不出什么东东啊