系统环境: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,可是我这里没这个文件啊,大侠们,帮帮我。
现象:在运行一几天后,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,可是我这里没这个文件啊,大侠们,帮帮我。
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