[20200218]无ENABLE=BROKEN在连接串中3.txt

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

[20200218]无ENABLE=BROKEN在连接串中3.txt --//上午测试在连接串中加入与不加入ENABLE=BROKEN的情况，测试有点乱，我下午换1个角度测试： 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: 20 2.测试连接串无ENABLE=BROKEN的情况: $ rlwrap sqlplus scott/book@"(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=book)(SERVER = DEDICATED))(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))" SCOTT@book> @ spid SID SERIAL# PROCESS SERVER SPID PID P_SERIAL# C50 ---------- ---------- ------------------------ --------- ------ ------- ---------- -------------------------------------------------- 3 903 51215 DEDICATED 51217 24 47 alter system kill session '3,903' immediate; --//可以从这里确定sqlplus进程号=51215(对应显示PROCESS）,oraclebook进程号=51217(对应显示SPID). $ seq 1000 | xargs -IQ bash -c "netstat -npo 2>/dev/null | egrep '51217|51215'| egrep 'oraclebook|sqlplus' ;sleep 1" --//当前连接正常的情况下 tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (0.61/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (9.60/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (8.58/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (7.56/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (6.53/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (5.51/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (4.49/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (3.47/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (2.45/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (1.42/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (0.41/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (9.40/0/0) --//注意最后1列。服务器进程对应的是keepalive，而客户端进程对应的是off。 # iptables -I INPUT 1 -p tcp --dport 6342 -j REJECT tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (0.07/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (9.06/0/1) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (8.03/0/1) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (7.01/0/1) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (5.99/0/1) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (4.97/0/1) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (3.94/0/1) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (2.92/0/1) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (1.90/0/1) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (0.88/0/1) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (9.87/0/2) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (8.85/0/2) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (7.83/0/2) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (6.80/0/2) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (5.78/0/2) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (4.76/0/2) ... tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (9.47/0/4) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (8.45/0/4) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (7.42/0/4) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (6.40/0/4) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (5.38/0/4) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (4.36/0/4) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (3.34/0/4) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (2.31/0/4) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (1.29/0/4) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:1521 127.0.0.1:6342 ESTABLISHED 51217/oraclebook keepalive (0.27/0/4) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) tcp 0 0 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus off (0.00/0/0) --//探测4次，每次10秒。oraclebook对应进程号51217消失5。 --//在客户端执行sql语句： SCOTT@book> select sysdate from dual ; --//服务器进程已经不再了。挂起!! tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (0.10/0/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (0.29/2/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (0.88/3/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (3.10/4/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (2.07/4/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (1.05/4/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (0.03/4/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (5.48/5/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (4.46/5/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (3.43/5/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (2.41/5/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (1.39/5/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (0.37/5/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (12.29/6/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (11.27/6/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (10.24/6/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (9.22/6/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (8.20/6/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (7.18/6/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (6.16/6/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (5.13/6/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (4.11/6/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (3.09/6/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (2.07/6/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (1.04/6/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (0.02/6/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (24.87/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (23.85/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (22.82/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (21.80/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (20.78/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (19.76/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (18.73/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (17.71/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (16.69/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (15.67/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (14.64/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (13.62/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (12.60/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (11.58/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (10.57/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (9.54/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (8.52/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (7.50/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (6.48/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (5.46/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (4.43/7/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (3.41/7/0) ..... tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (51.09/8/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (50.07/8/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (49.05/8/0) .. tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (0.00/8/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (102.58/9/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (101.56/9/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (100.53/9/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (99.51/9/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (98.49/9/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (97.47/9/0) ... tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (0.38/9/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (119.60/10/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (118.57/10/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (117.55/10/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (116.53/10/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (115.51/10/0) ... tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (1.04/10/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (0.02/10/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (119.30/11/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (118.28/11/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (117.26/11/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (116.24/11/0) ... tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (0.75/11/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (18446744073.44/11/0) ->不知道什么回事。 tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (119.01/12/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (117.99/12/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (116.97/12/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (115.95/12/0) ... tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (0.46/12/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (119.74/13/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (118.72/13/0) ... tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (1.86/13/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (0.84/13/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (18446744073.52/13/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (119.09/14/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (118.07/14/0) ... tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (2.59/14/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (1.57/14/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (0.56/14/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (119.84/15/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (118.82/15/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (117.80/15/0) ... tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (9.46/15/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (8.44/15/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (7.42/15/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (6.40/15/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (5.37/15/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (4.35/15/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (3.33/15/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (2.31/15/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (1.28/15/0) tcp 0 306 127.0.0.1:6342 127.0.0.1:1521 ESTABLISHED 51215/sqlplus on (0.26/15/0) ^C --//可以发现在连接串无ENABLE=BROKEN情况下，服务进程中断的情况下，要探测15次，开始时间间隔很短，最后时间间隔增加到120秒。 SCOTT@book> select sysdate from dual ; select sysdate from dual * ERROR at line 1: ORA-03113: end-of-file on communication channel Process ID: 51217 Session ID: 3 Serial number: 903 总结：可以看出在连接串中加入ENABLE=BROKEN是不错的选择。写一篇测试使用ENABLE=BROKEN的情况，不然写的有点长。

编辑推荐：

返回列表

[20200218]无ENABLE=BROKEN在连接串中3.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：支持手写笔、第三方安卓应用

最新软件资讯

热文推荐

天极热推