[20200219]strace跟踪设置ENABLE=BROKEN的情况(网络的情况).txt

来源：这里教程网时间：2026-03-03 15:03:24 作者：

[20200219]strace跟踪设置ENABLE=BROKEN的情况(网络的情况).txt --//前面的测试都是在本地服务端进行，使用lo接口。测试真实网络的情况： 1.环境： SCOTT@book> @ ver1 PORT_STRING VERSION BANNER ------------------------------ -------------- -------------------------------------------------------------------------------- x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production # echo /proc/sys/net/ipv4/tcp_keepalive* | xargs -n 1 strings -1 -f /proc/sys/net/ipv4/tcp_keepalive_intvl: 10 /proc/sys/net/ipv4/tcp_keepalive_probes: 4 /proc/sys/net/ipv4/tcp_keepalive_time: 33 $ grep SQLNET.EXPIRE_TIME $ORACLE_HOME/network/admin/sqlnet.ora # SQLNET.EXPIRE_TIME = 1 --//客户端： # echo /proc/sys/net/ipv4/tcp_keepalive* | xargs -n 1 strings -1 -f /proc/sys/net/ipv4/tcp_keepalive_intvl: 15 /proc/sys/net/ipv4/tcp_keepalive_probes: 4 /proc/sys/net/ipv4/tcp_keepalive_time: 56 $ grep -i expire sqlnet.ora #SQLNET.EXPIRE_TIME = 1 2.测试： --//在客户端执行： $ strace -f -r -T -e trace=socket,setsockopt sqlplus scott/book@"(DESCRIPTION=(ENABLE=BROKEN)(CONNECT_DATA=(SERVICE_NAME=book)(SERVER = DEDICATED))(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.78)(PORT=1521)))" 0.000000 socket(PF_INET6, SOCK_DGRAM, IPPROTO_IP) = 6 <0.000236> 0.001417 socket(PF_FILE, SOCK_STREAM, 0) = 6 <0.000143> 0.000447 socket(PF_FILE, SOCK_STREAM, 0) = 6 <0.000149> SQL*Plus: Release 11.2.0.4.0 Production on Wed Feb 19 11:00:19 2020 Copyright (c) 1982, 2013, Oracle. All rights reserved. 0.021572 socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 9 <0.000179> 0.000346 setsockopt(9, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0 <0.000137> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 0.000863 setsockopt(9, SOL_TCP, TCP_NODELAY, [1], 4) = 0 <0.000142> 0.054498 setsockopt(9, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0 <0.000149> 0.010003 socket(PF_NETLINK, SOCK_RAW, 0) = 10 <0.000211> 0.000690 socket(PF_FILE, SOCK_STREAM, 0) = 10 <0.000148> 0.000437 socket(PF_FILE, SOCK_STREAM, 0) = 10 <0.000149> 0.001555 socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 10 <0.000032> SCOTT@book> @ spid SID SERIAL# PROCESS SERVER SPID PID P_SERIAL# C50 ---------- ---------- ------------------------ --------- ------ ------- ---------- -------------------------------------------------- 3 1435 14573 DEDICATED 10567 24 217 alter system kill session '3,1435' immediate; --//在服务端执行： # ps -ef | grep tnslsn[r] oracle 47619 1 0 Jan15 ? 00:01:04 /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/tnslsnr LISTENER -inherit $ strace -f -r -T -e trace=socket,setsockopt -p 47619 Process 47619 attached with 3 threads - interrupt to quit [pid 47620] 0.000000 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000037> [pid 47619] 3.741731 setsockopt(13, SOL_TCP, TCP_NODELAY, [1], 4) = 0 <0.000020> Process 10566 attached Process 47619 suspended Process 10567 attached Process 47619 resumed Process 10566 detached [pid 47619] 0.002848 --- SIGCHLD (Child exited) @ 0 (0) --- [pid 10567] 0.035160 socket(PF_INET6, SOCK_DGRAM, IPPROTO_IP) = 6 <0.000027> [pid 10567] 0.007805 socket(PF_FILE, SOCK_STREAM, 0) = 4 <0.000025> [pid 10567] 0.000210 socket(PF_FILE, SOCK_STREAM, 0) = 4 <0.000019> [pid 10567] 0.006365 setsockopt(13, SOL_TCP, TCP_NODELAY, [1], 4) = 0 <0.000025> [pid 10567] 0.001532 setsockopt(13, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0 <0.000023> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [pid 47620] 1.207357 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000027> [pid 47620] 5.000959 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000029> [pid 47620] 5.001582 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000026> [pid 47620] 5.001408 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000031> [pid 47620] 5.002872 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000026> [pid 47620] 5.000991 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000027> [pid 47620] 5.001649 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000027> [pid 47620] 5.001450 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000038> ^CProcess 47619 detached Process 47620 detached Process 47621 detached Process 10567 detached --//可以看出服务端与客户端都执行了setsockopt(13, SOL_SOCKET, SO_KEEPALIVE, [1], 4). 3.看看连接情况以及各自keepalive设置是多少？ --//在客户端执行： $ seq 100 | xargs -iQ bash -c "netstat -npo 2>/dev/null | grep 14573|ts.awk;sleep 0.99" --//rh 4.3版本，xargs -i参数是小写。 [2020-02-19 11:04:06] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (0.46/0/0) [2020-02-19 11:04:07] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (14.41/0/0) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [2020-02-19 11:04:08] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (13.37/0/0) [2020-02-19 11:04:09] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (12.32/0/0) [2020-02-19 11:04:10] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (11.28/0/0) [2020-02-19 11:04:12] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (10.23/0/0) [2020-02-19 11:04:13] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (9.19/0/0) [2020-02-19 11:04:14] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (8.14/0/0) [2020-02-19 11:04:15] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (7.10/0/0) [2020-02-19 11:04:16] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (6.05/0/0) [2020-02-19 11:04:17] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (5.01/0/0) [2020-02-19 11:04:18] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (3.96/0/0) [2020-02-19 11:04:19] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (2.92/0/0) [2020-02-19 11:04:20] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (1.87/0/0) [2020-02-19 11:04:21] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (0.83/0/0) [2020-02-19 11:04:22] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (40.78/0/0) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [2020-02-19 11:04:23] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (39.73/0/0) [2020-02-19 11:04:24] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (38.69/0/0) [2020-02-19 11:04:25] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (37.64/0/0) [2020-02-19 11:04:26] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (36.60/0/0) [2020-02-19 11:04:27] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (35.55/0/0) [2020-02-19 11:04:28] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (34.51/0/0) [2020-02-19 11:04:29] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (33.46/0/0) [2020-02-19 11:04:30] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (32.42/0/0) [2020-02-19 11:04:31] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (31.37/0/0) [2020-02-19 11:04:32] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (30.33/0/0) [2020-02-19 11:04:33] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (29.28/0/0) [2020-02-19 11:04:35] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (28.24/0/0) [2020-02-19 11:04:36] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (27.19/0/0) [2020-02-19 11:04:37] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (26.15/0/0) [2020-02-19 11:04:38] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (25.10/0/0) [2020-02-19 11:04:39] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (24.06/0/0) [2020-02-19 11:04:40] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (23.01/0/0) [2020-02-19 11:04:41] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (21.97/0/0) [2020-02-19 11:04:42] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (20.92/0/0) [2020-02-19 11:04:43] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (19.88/0/0) [2020-02-19 11:04:44] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (18.84/0/0) [2020-02-19 11:04:45] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (17.79/0/0) [2020-02-19 11:04:46] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (16.75/0/0) [2020-02-19 11:04:47] tcp 0 0 192.168.100.40:37596 192.168.100.78:1521 ESTABLISHED 14573/sqlplus keepalive (15.70/0/0) --//也是分2部分，41+15 = 56秒. --//在服务端执行： $ seq 100 | xargs -IQ bash -c "netstat -npo 2>/dev/null | grep 10567|ts.awk;sleep 1" [2020-02-19 11:06:36] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (0.41/0/0) [2020-02-19 11:06:37] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (22.39/0/0) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [2020-02-19 11:06:38] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (21.37/0/0) [2020-02-19 11:06:39] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (20.35/0/0) [2020-02-19 11:06:40] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (19.32/0/0) [2020-02-19 11:06:41] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (18.30/0/0) [2020-02-19 11:06:42] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (17.28/0/0) [2020-02-19 11:06:43] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (16.26/0/0) [2020-02-19 11:06:44] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (15.23/0/0) [2020-02-19 11:06:45] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (14.21/0/0) [2020-02-19 11:06:46] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (13.19/0/0) [2020-02-19 11:06:47] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (12.17/0/0) [2020-02-19 11:06:48] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (11.15/0/0) [2020-02-19 11:06:49] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (10.12/0/0) [2020-02-19 11:06:50] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (9.10/0/0) [2020-02-19 11:06:51] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (8.08/0/0) [2020-02-19 11:06:52] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (7.06/0/0) [2020-02-19 11:06:53] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (6.04/0/0) [2020-02-19 11:06:54] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (5.01/0/0) [2020-02-19 11:06:55] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (3.99/0/0) [2020-02-19 11:06:56] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (2.97/0/0) [2020-02-19 11:06:57] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (1.95/0/0) [2020-02-19 11:06:58] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (0.92/0/0) [2020-02-19 11:06:59] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (9.92/0/0) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [2020-02-19 11:07:00] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (8.89/0/0) [2020-02-19 11:07:01] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (7.87/0/0) [2020-02-19 11:07:02] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (6.85/0/0) [2020-02-19 11:07:03] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (5.83/0/0) [2020-02-19 11:07:04] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (4.81/0/0) [2020-02-19 11:07:05] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (3.78/0/0) [2020-02-19 11:07:06] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (2.76/0/0) [2020-02-19 11:07:07] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (1.74/0/0) [2020-02-19 11:07:08] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (0.72/0/0) [2020-02-19 11:07:09] tcp 0 0 192.168.100.78:1521 192.168.100.40:37596 ESTABLISHED 10567/oraclebook keepalive (22.70/0/0) --//10+23 = 33. --//噢，终于明白为什么分成2部分，1部分的设置来源于内核参数/proc/sys/net/ipv4/tcp_keepalive_intvl。 --//服务端/proc/sys/net/ipv4/tcp_keepalive_intvl=10,而客户端/proc/sys/net/ipv4/tcp_keepalive_intvl=15. --//可以看出setsockopt(N, SOL_SOCKET, SO_KEEPALIVE, [1], 4) ,SO_KEEPALIVE参数来自各自主机的内核参数tcp_keepalive_time。 --//如果设置SQLNET.EXPIRE_TIME 参数，一部分就是6，不知道为什么？ 3.另外我还测试： --//客户端修改SQLNET.EXPIRE_TIME = 1的情况： $ grep -i expire sqlnet.ora SQLNET.EXPIRE_TIME = 1 --//结果一样，不会使用这个参数，而是使用内核参数。 4.补充使用tcpdump验证看看: --//从客户端登录: $ sqlplus scott/book@"(DESCRIPTION=(ENABLE=BROKEN)(CONNECT_DATA=(SERVICE_NAME=book)(SERVER = DEDICATED))(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.78)(PORT=1521)))" SCOTT@book> @ spid SID SERIAL# PROCESS SERVER SPID PID P_SERIAL# C50 ---------- ---------- ------------------------ --------- ------ ------- ---------- -------------------------------------------------- 3 1589 19194 DEDICATED 13338 24 11 alter system kill session '3,1589' immediate; --//注:不执行任何命令. --//客户端执行： $ netstat -npo 2>/dev/null | grep 19194 tcp 0 0 192.168.100.40:40891 192.168.100.78:1521 ESTABLISHED 19194/sqlplus keepalive (20.73/0/0) --//服务端执行： # netstat -npo 2>/dev/null | grep 13338 tcp 0 0 192.168.100.78:1521 192.168.100.40:40891 ESTABLISHED 13338/oraclebook keepalive (13.46/0/0) # tcpdump -vvnni eth0 dst port 40891 tcpdump: listening on eth0, link-type EN10MB (Ethernet), capture size 96 bytes ... 15:37:50.126104 IP (tos 0x0, ttl 64, id 18244, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.78.1521 > 192.168.100.40.40891: ., cksum 0x49ee (incorrect (-> 0xc606), 1:1(0) ack 1 win 331 <nop,nop,timestamp 713638269 2533232674> 15:37:57.424253 IP (tos 0x0, ttl 64, id 18245, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.78.1521 > 192.168.100.40.40891: ., cksum 0x49ee (incorrect (-> 0xa984), 0:0(0) ack 1 win 331 <nop,nop,timestamp 713645568 2533232674> ~~~~~ 15:38:30.448234 IP (tos 0x0, ttl 64, id 18246, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.78.1521 > 192.168.100.40.40891: ., cksum 0x49ee (incorrect (-> 0xa782), 0:0(0) ack 1 win 331 <nop,nop,timestamp 713678592 2533265699> ~~~~ 15:38:46.124136 IP (tos 0x0, ttl 64, id 18247, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.78.1521 > 192.168.100.40.40891: ., cksum 0x49ee (incorrect (-> 0xe943), 1:1(0) ack 1 win 331 <nop,nop,timestamp 713694267 2533298725> 15:39:03.472187 IP (tos 0x0, ttl 64, id 18248, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.78.1521 > 192.168.100.40.40891: ., cksum 0x49ee (incorrect (-> 0xa57f), 0:0(0) ack 1 win 331 <nop,nop,timestamp 713711616 2533298725> ~~~ 15:39:36.496545 IP (tos 0x0, ttl 64, id 18249, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.78.1521 > 192.168.100.40.40891: ., cksum 0x49ee (incorrect (-> 0xa37d), 0:0(0) ack 1 win 331 <nop,nop,timestamp 713744640 2533331750> ~~~~~ 15:39:42.122073 IP (tos 0x0, ttl 64, id 18250, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.78.1521 > 192.168.100.40.40891: ., cksum 0x49ee (incorrect (-> 0x0c82), 1:1(0) ack 1 win 331 <nop,nop,timestamp 713750265 2533364775> 15:40:09.520757 IP (tos 0x0, ttl 64, id 20500, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.40.40891 > 192.168.100.78.1521: ., cksum 0x8c3d (correct), 0:0(0) ack 1 win 145 <nop,nop,timestamp 2533397797 713750265> ~~~~~ 15:40:38.138192 IP (tos 0x0, ttl 64, id 20502, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.40.40891 > 192.168.100.78.1521: ., cksum 0x1c82 (correct), 4294967295:4294967295(0) ack 1 win 145 <nop,nop,timestamp 2533426401 713750265> 15:40:42.545344 IP (tos 0x0, ttl 64, id 20504, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.40.40891 > 192.168.100.78.1521: ., cksum 0x307a (correct), 0:0(0) ack 1 win 145 <nop,nop,timestamp 2533430806 713806282> ~~~~~~ 15:41:15.568301 IP (tos 0x0, ttl 64, id 20506, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.40.40891 > 192.168.100.78.1521: ., cksum 0xaf80 (correct), 0:0(0) ack 1 win 145 <nop,nop,timestamp 2533463823 713806282> ~~~~~~~ 15:41:34.147020 IP (tos 0x0, ttl 64, id 20508, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.40.40891 > 192.168.100.78.1521: ., cksum 0x66ee (correct), 4294967295:4294967295(0) ack 1 win 145 <nop,nop,timestamp 2533482402 713806282> 15:41:48.592753 IP (tos 0x0, ttl 64, id 20510, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.40.40891 > 192.168.100.78.1521: ., cksum 0x53b5 (correct), 0:0(0) ack 1 win 145 <nop,nop,timestamp 2533496849 713862290> ~~~~~~~ 15:42:21.616468 IP (tos 0x0, ttl 64, id 20512, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.40.40891 > 192.168.100.78.1521: ., cksum 0xd2b3 (correct), 0:0(0) ack 1 win 145 <nop,nop,timestamp 2533529874 713862290> --//注意看下划线的行，时间的间隔33秒。其它出现的情况是客户端发出的探测包。比如时间：15:38:46.124136。对比下面的输出就很清洗了。 --// 15:38:46.124136 ,15:39:42.122073 相差56秒。 # tcpdump -vvnni eth0 src port 40891 tcpdump: listening on eth0, link-type EN10MB (Ethernet), capture size 96 bytes 15:38:30.448364 IP (tos 0x0, ttl 64, id 20490, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.40.40891 > 192.168.100.78.1521: ., cksum 0xc4bc (correct), 2813590524:2813590524(0) ack 2927188646 win 145 <nop,nop,timestamp 2533298725 713638269> 15:38:46.123988 IP (tos 0x0, ttl 64, id 20492, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.40.40891 > 192.168.100.78.1521: ., cksum 0x8781 (correct), 4294967295:4294967295(0) ack 1 win 145 <nop,nop,timestamp 2533314401 713638269> ~~~~~~~~ 15:39:03.472312 IP (tos 0x0, ttl 64, id 20494, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.40.40891 > 192.168.100.78.1521: ., cksum 0x68fc (correct), 0:0(0) ack 1 win 145 <nop,nop,timestamp 2533331750 713694267> 15:39:36.496655 IP (tos 0x0, ttl 64, id 20496, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.40.40891 > 192.168.100.78.1521: ., cksum 0xe7fa (correct), 0:0(0) ack 1 win 145 <nop,nop,timestamp 2533364775 713694267> 15:39:42.122031 IP (tos 0x0, ttl 64, id 20498, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.40.40891 > 192.168.100.78.1521: ., cksum 0xd201 (correct), 4294967295:4294967295(0) ack 1 win 145 <nop,nop,timestamp 2533370401 713694267> ~~~~~~~~ 15:40:09.520757 IP (tos 0x0, ttl 64, id 20500, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.40.40891 > 192.168.100.78.1521: ., cksum 0x8c3d (correct), 0:0(0) ack 1 win 145 <nop,nop,timestamp 2533397797 713750265> 15:40:38.138192 IP (tos 0x0, ttl 64, id 20502, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.40.40891 > 192.168.100.78.1521: ., cksum 0x1c82 (correct), 4294967295:4294967295(0) ack 1 win 145 <nop,nop,timestamp 2533426401 713750265> ~~~~~~~~~ 15:40:42.545344 IP (tos 0x0, ttl 64, id 20504, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.40.40891 > 192.168.100.78.1521: ., cksum 0x307a (correct), 0:0(0) ack 1 win 145 <nop,nop,timestamp 2533430806 713806282> 15:41:15.568301 IP (tos 0x0, ttl 64, id 20506, offset 0, flags [DF], proto: TCP (6), length: 52) 192.168.100.40.40891 > 192.168.100.78.1521: ., cksum 0xaf80 (correct), 0:0(0) ack 1 win 145 <nop,nop,timestamp 2533463823 713806282> --//注意看下划线的行，时间的间隔56秒。 5.总结： --//11g下建议设置相关内核参数，不建议选择增加 sqlnet.ora文件的 SQLNET.EXPIRE_TIME参数。 # echo /proc/sys/net/ipv4/tcp_keepalive* | xargs -n 1 strings -1 -f /proc/sys/net/ipv4/tcp_keepalive_intvl: 10 /proc/sys/net/ipv4/tcp_keepalive_probes: 4 /proc/sys/net/ipv4/tcp_keepalive_time: 600 --//12c选择修改SQLNET.EXPIRE_TIME = 10 --//数据库连接串建议加入(ENABLE=BROKEN)。注意客户端相关内核参数也要修改合适,实际上就是使用内核相关参数检测TCP KEEPALIVE套接 --//字选项来检查连接是否仍然可用。 --//我建议如下: # echo /proc/sys/net/ipv4/tcp_keepalive* | xargs -n 1 strings -1 -f /proc/sys/net/ipv4/tcp_keepalive_intvl: 10 /proc/sys/net/ipv4/tcp_keepalive_probes: 4 /proc/sys/net/ipv4/tcp_keepalive_time: 600 --//不知道windows的这些参数如何修改注册表,有时间看看。 --//另外不必担心这些包对网络性能的影响，现在的网络完全可以承受，还不如重点放在优化业务流程以及sql语句。 6.ts.awk脚本： $ cat /usr/local/bin/ts.awk # /bin/bash gawk '{ print strftime("[%Y-%m-%d %H:%M:%S]"), $0 }'

编辑推荐：

返回列表

[20200219]strace跟踪设置ENABLE=BROKEN的情况(网络的情况).txt

编辑推荐：

相关推荐

excel表格怎样在数字前输入0

excel表格里怎么替换数据

excel表格里面如何插入圆形

excel表格里怎么添加表格数据透视表

excel表格中怎么添加线边框

excel表格里怎样设置条件自动排序

excel表格例怎样导入数据库

Excel表格如何设置数据排序

excel表格里怎么选择性粘贴快捷键

excel表格怎么插入分隔符号

excel表格怎么设置多行多列数据内容排序

Excel表格如何设置行和列相互转换

excel表格连接公式怎么使用

excel表格怎样链接到cad中

雷神推出 MIX PRO II 迷你主机：基于 Ultra 200H，玻璃上盖 + ARGB 灯效

制造商 Musnap 推出彩色墨水屏电纸书 Ocean C：支持手写笔、第三方安卓应用

最新软件资讯

热文推荐

天极热推