oracle enable broken,[20200219]strace跟踪设置ENABLE=BROKEN的情况.txt

最新推荐文章于 2021-04-15 18:41:46 发布
最新推荐文章于 2021-04-15 18:41:46 发布
阅读量366 收藏
点赞数
文章标签： oracle enable broken

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

--//使用strace跟踪设置ENABLE=BROKEN的情况.

--//开始我以为使用strace-f跟踪sqlplus+连接串，就可以获得服务端与客户端进程的相关信息，实际上错了，

--//服务端端程序通过监听进程tnslsnr派生出来的，跟踪要跟踪2个进程。

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

$ grep SQLNET.EXPIRE_TIME $ORACLE_HOME/network/admin/sqlnet.ora

# SQLNET.EXPIRE_TIME = 1

--//如果不使用连接串，看到的结果如下：

$ strace -f -r -T   -e trace=socket,setsockopt sqlplus  scott/book

0.000000 socket(PF_INET6, SOCK_DGRAM, IPPROTO_IP) = 6 <0.000030>

SQL*Plus: Release 11.2.0.4.0 Production on Wed Feb 19 08:58:49 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

0.017259 socket(PF_FILE, SOCK_STREAM, 0) = 7 <0.000024>

0.000219 socket(PF_FILE, SOCK_STREAM, 0) = 7 <0.000018>

Process 2729 attached

[pid  2729]      0.039015 socket(PF_INET6, SOCK_DGRAM, IPPROTO_IP) = 6 <0.000027>

[pid  2729]      0.004379 socket(PF_FILE, SOCK_STREAM, 0) = 6 <0.000022>

[pid  2729]      0.000204 socket(PF_FILE, SOCK_STREAM, 0) = 6 <0.000019>

[pid  2728]      0.017508 socket(PF_NETLINK, SOCK_RAW, 0) = 7 <0.000033>

[pid  2728]      0.000445 socket(PF_FILE, SOCK_STREAM, 0) = 7 <0.000022>

[pid  2728]      0.000201 socket(PF_FILE, SOCK_STREAM, 0) = 7 <0.000018>

SCOTT@book> @ spid

SID    SERIAL# PROCESS                  SERVER    SPID       PID  P_SERIAL# C50

---------- ---------- ------------------------ --------- ------ ------- ---------- --------------------------------------------------

3       1397 2728                     DEDICATED 2729        24        199 alter system kill session '3,1397' immediate;

--//你可以看到strace的前面有pid信息，与下面@spid的显示一致。

2.跟踪测试:

$ 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

--//tnslsnr进程=47619

$ 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.000027>

[pid 47620]      5.001175 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000026>

[pid 47620]      5.000811 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000027>

[pid 47619]      4.102688 setsockopt(13, SOL_TCP, TCP_NODELAY, [1], 4) = 0 <0.000025>

Process 2770 attached

Process 47619 suspended

Process 2771 attached

Process 47619 resumed

Process 2770 detached

[pid 47619]      0.002904 --- SIGCHLD (Child exited) @ 0 (0) ---

[pid  2771]      0.037125 socket(PF_INET6, SOCK_DGRAM, IPPROTO_IP) = 6 <0.000030>

[pid  2771]      0.008047 socket(PF_FILE, SOCK_STREAM, 0) = 4 <0.000025>

[pid  2771]      0.000228 socket(PF_FILE, SOCK_STREAM, 0) = 4 <0.000018>

[pid  2771]      0.006937 setsockopt(13, SOL_TCP, TCP_NODELAY, [1], 4) = 0 <0.000025>

[pid  2771]      0.001632 setsockopt(13, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0 <0.000039>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[pid 47620]      0.841315 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000030>

[pid 47620]      5.000698 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000028>

[pid 47620]      5.001081 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000026>

^CProcess 47619 detached

Process 47620 detached

Process 47621 detached

Process 2771 detached

$ 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=localhost)(PORT=1521)))"

0.000000 socket(PF_INET6, SOCK_DGRAM, IPPROTO_IP) = 6 <0.000031>

SQL*Plus: Release 11.2.0.4.0 Production on Wed Feb 19 09:01:53 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

0.016914 socket(PF_FILE, SOCK_STREAM, 0) = 7 <0.000026>

0.000244 socket(PF_FILE, SOCK_STREAM, 0) = 7 <0.000022>

0.004022 socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 7 <0.000031>

0.000150 setsockopt(7, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0 <0.000018>

0.001047 setsockopt(7, SOL_TCP, TCP_NODELAY, [1], 4) = 0 <0.000022>

0.056857 setsockopt(7, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0 <0.000030>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

0.025672 socket(PF_NETLINK, SOCK_RAW, 0) = 8 <0.000032>

0.000530 socket(PF_FILE, SOCK_STREAM, 0) = 8 <0.000027>

0.000259 socket(PF_FILE, SOCK_STREAM, 0) = 8 <0.000025>

SCOTT@book> @ spid

SID    SERIAL# PROCESS                  SERVER    SPID       PID  P_SERIAL# C50

---------- ---------- ------------------------ --------- ------ ------- ---------- --------------------------------------------------

3       1401 2769                     DEDICATED 2771        24        201 alter system kill session '3,1401' immediate;

--//服务端进程号=2771，客户端进程号=2769.

$ ls -l /proc/2769/fd

total 0

lrwx------ 1 oracle oinstall 64 2020-02-19 09:01:53 0 -> /dev/pts/1

lrwx------ 1 oracle oinstall 64 2020-02-19 09:04:26 1 -> /dev/pts/1

lrwx------ 1 oracle oinstall 64 2020-02-19 09:04:26 2 -> /dev/pts/1

lr-x------ 1 oracle oinstall 64 2020-02-19 09:04:26 3 -> /u01/app/oracle/product/11.2.0.4/dbhome_1/sqlplus/mesg/sp1us.msb

lr-x------ 1 oracle oinstall 64 2020-02-19 09:04:26 4 -> /u01/app/oracle/product/11.2.0.4/dbhome_1/sqlplus/mesg/sp2us.msb

lr-x------ 1 oracle oinstall 64 2020-02-19 09:04:26 5 -> /u01/app/oracle/product/11.2.0.4/dbhome_1/sqlplus/mesg/cpyus.msb

lr-x------ 1 oracle oinstall 64 2020-02-19 09:04:26 6 -> /u01/app/oracle/product/11.2.0.4/dbhome_1/rdbms/mesg/ocius.msb

lrwx------ 1 oracle oinstall 64 2020-02-19 09:04:26 7 -> socket:[3017954]

--//文件句柄7对应socket。

$ ls -l /proc/2771/fd

total 0

lr-x------ 1 oracle oinstall 64 2020-02-19 09:04:57 0 -> /dev/null

l-wx------ 1 oracle oinstall 64 2020-02-19 09:04:57 1 -> /dev/null

lrwx------ 1 oracle oinstall 64 2020-02-19 09:04:57 13 -> socket:[2907877

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

l-wx------ 1 oracle oinstall 64 2020-02-19 09:04:57 2 -> /dev/null

lr-x------ 1 oracle oinstall 64 2020-02-19 09:04:57 3 -> /dev/null

lr-x------ 1 oracle oinstall 64 2020-02-19 09:04:57 4 -> /u01/app/oracle/product/11.2.0.4/dbhome_1/rdbms/mesg/oraus.msb

lr-x------ 1 oracle oinstall 64 2020-02-19 09:04:57 5 -> /proc/2771/fd

lr-x------ 1 oracle oinstall 64 2020-02-19 09:04:57 6 -> /dev/zero

$ netstat -npo | egrep "2769|2771" 2>/dev/null

tcp        0      0 127.0.0.1:18535             127.0.0.1:1521              ESTABLISHED 2769/sqlplus        keepalive (8.68/0/0)

tcp        0      0 127.0.0.1:1521              127.0.0.1:18535             ESTABLISHED 2771/oraclebook     keepalive (8.68/0/0)

# lsof -p 2769,2771 -P -n | grep 127.0.0.1

sqlplus 2769 oracle    7u  IPv4 3017954       0t0       TCP 127.0.0.1:18535->127.0.0.1:1521 (ESTABLISHED)

oracle  2771 oracle   13u  IPv4 2907877       0t0       TCP 127.0.0.1:1521->127.0.0.1:18535 (ESTABLISHED)

--//完全能对上。

--//你可以发现在登录时，服务端与客户端执行都有setsockopt(N, SOL_SOCKET, SO_KEEPALIVE, [1], 4)信息。

3.再来看看不设置ENABLE=BROKEN的情况：

$ strace -f -r -T   -e trace=socket,setsockopt sqlplus  scott/book@"(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=book)(SERVER = DEDICATED))(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))"

0.000000 socket(PF_INET6, SOCK_DGRAM, IPPROTO_IP) = 6 <0.000032>

SQL*Plus: Release 11.2.0.4.0 Production on Wed Feb 19 10:11:42 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

0.020282 socket(PF_FILE, SOCK_STREAM, 0) = 7 <0.000031>

0.000300 socket(PF_FILE, SOCK_STREAM, 0) = 7 <0.000025>

0.004632 socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 7 <0.000034>

0.000853 setsockopt(7, SOL_TCP, TCP_NODELAY, [1], 4) = 0 <0.000033>

0.083796 socket(PF_NETLINK, SOCK_RAW, 0) = 8 <0.000035>

0.000468 socket(PF_FILE, SOCK_STREAM, 0) = 8 <0.000030>

0.000230 socket(PF_FILE, SOCK_STREAM, 0) = 8 <0.000032>

SCOTT@book> @ spid

SID    SERIAL# PROCESS                  SERVER    SPID       PID  P_SERIAL# C50

---------- ---------- ------------------------ --------- ------ ------- ---------- --------------------------------------------------

3       1421 9580                     DEDICATED 9582        24        210 alter system kill session '3,1421' immediate;

--//客户端没有执行setsockopt(N, SOL_SOCKET, SO_KEEPALIVE, [1], 4)设置。

$ strace -f -r -T   -e trace=socket,setsockopt -p 47619

Process 47619 attached with 3 threads - interrupt to quit

[pid 47619]      0.000000 setsockopt(13, SOL_TCP, TCP_NODELAY, [1], 4) = 0 <0.000021>

Process 9581 attached

Process 47619 suspended

Process 9582 attached

Process 47619 resumed

Process 9581 detached

[pid 47619]      0.002729 --- SIGCHLD (Child exited) @ 0 (0) ---

[pid  9582]      0.039506 socket(PF_INET6, SOCK_DGRAM, IPPROTO_IP) = 6 <0.000035>

[pid  9582]      0.009075 socket(PF_FILE, SOCK_STREAM, 0) = 4 <0.000031>

[pid  9582]      0.000279 socket(PF_FILE, SOCK_STREAM, 0) = 4 <0.000024>

[pid  9582]      0.007223 setsockopt(13, SOL_TCP, TCP_NODELAY, [1], 4) = 0 <0.000026>

[pid 47620]      2.556869 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000029>

[pid 47620]      5.000824 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000064>

^CProcess 47619 detached

Process 47620 detached

Process 47621 detached

Process 9582 detached

--//服务端没有执行setsockopt(N, SOL_SOCKET, SO_KEEPALIVE, [1], 4)设置。

$ netstat -npo 2>/dev/null | egrep "9580|9582"

tcp        0      0 127.0.0.1:1521              127.0.0.1:19381             ESTABLISHED 9582/oraclebook     off (0.00/0/0)

tcp      120      0 127.0.0.1:19381             127.0.0.1:1521              ESTABLISHED 9580/sqlplus        off (0.00/0/0)

4.修改sqlnet.ora呢？

$ grep SQLNET.EXPIRE_TIME $ORACLE_HOME/network/admin/sqlnet.ora

SQLNET.EXPIRE_TIME = 1

--//我以前提到过如果设置SQLNET.EXPIRE_TIME，这个参数优先。

$ 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=localhost)(PORT=1521)))"

0.000000 socket(PF_INET6, SOCK_DGRAM, IPPROTO_IP) = 6 <0.000033>

SQL*Plus: Release 11.2.0.4.0 Production on Wed Feb 19 09:16:57 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

0.016931 socket(PF_FILE, SOCK_STREAM, 0) = 7 <0.000024>

0.000223 socket(PF_FILE, SOCK_STREAM, 0) = 7 <0.000019>

0.004058 socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 7 <0.000030>

0.000094 setsockopt(7, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0 <0.000018>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

0.001108 setsockopt(7, SOL_TCP, TCP_NODELAY, [1], 4) = 0 <0.000130>

0.060822 setsockopt(7, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0 <0.000047>

0.009481 socket(PF_NETLINK, SOCK_RAW, 0) = 8 <0.000034>

0.000464 socket(PF_FILE, SOCK_STREAM, 0) = 8 <0.000026>

0.000221 socket(PF_FILE, SOCK_STREAM, 0) = 8 <0.000023>

$ 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.000026>

[pid 47619]      2.550287 setsockopt(13, SOL_TCP, TCP_NODELAY, [1], 4) = 0 <0.000022>

Process 3014 attached

Process 47619 suspended

Process 3015 attached

Process 47619 resumed

Process 3014 detached

[pid 47619]      0.003110 --- SIGCHLD (Child exited) @ 0 (0) ---

[pid  3015]      0.040166 socket(PF_INET6, SOCK_DGRAM, IPPROTO_IP) = 6 <0.000035>

[pid  3015]      0.008989 socket(PF_FILE, SOCK_STREAM, 0) = 4 <0.000032>

[pid  3015]      0.000270 socket(PF_FILE, SOCK_STREAM, 0) = 4 <0.000025>

[pid  3015]      0.007105 setsockopt(13, SOL_TCP, TCP_NODELAY, [1], 4) = 0 <0.000026>

[pid 47620]      2.390704 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000032>

[pid 47620]      5.000647 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13 <0.000026>

^CProcess 47619 detached

Process 47620 detached

Process 47621 detached

Process 3015 detached

SCOTT@book> @ spid

SID    SERIAL# PROCESS                  SERVER    SPID       PID  P_SERIAL# C50

---------- ---------- ------------------------ --------- ------ ------- ---------- --------------------------------------------------

3       1413 3013                     DEDICATED 3015        24        206 alter system kill session '3,1413' immediate;

$ netstat -npo  | egrep " 3013| 3015"

(Not all processes could be identified, non-owned process info

will not be shown, you would have to be root to see it all.)

tcp        0      0 127.0.0.1:1521              127.0.0.1:18720             ESTABLISHED 3015/oraclebook     off (0.00/0/0)

tcp        0      0 127.0.0.1:18720             127.0.0.1:1521              ESTABLISHED 3013/sqlplus        keepalive (2.38/0/0)

--//你可以发现在11g下使用ENABLE=BROKEN，sqlnetora设置SQLNET.EXPIRE_TIME=1的情况下，客户端执行setsockopt(7, SOL_SOCKET, SO_KEEPALIVE, [1], 4)。

--//而服务端没有(后一列显示off)。

--//也就是11g设置SQLNET.EXPIRE_TIME,使用DCD探测没有使用TCP KEEPALIVE套接字选项来检查连接是否仍然可用。

--//实际上12c改变这种情况，12c会利用SQLNET.EXPIRE_TIME设置，使用DCD探测现在将使用TCP KEEPALIVE套接字选项来检查连接是否仍然可用。

--//测试18c的情况:

# grep -i SQLNET.EXPIRE_TIME /u01/app/oracle/product/18.0.0/db_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: 75

/proc/sys/net/ipv4/tcp_keepalive_probes: 9

/proc/sys/net/ipv4/tcp_keepalive_time: 7200

--//这是缺省设置。

SYS@192.168.x.x:1521/orclcdb> select BANNER from v$version;

BANNER

---------------------------------------------------------------------------

Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

SYS@192.168.x.x:1521/orclcdb> @ spid

SID    SERIAL# PROCESS    SERVER     SPID   PID  P_SERIAL# C50

---------- ---------- ---------- ---------- ------ --- ---------- --------------------------------------------------

282      45262 6796:7500  DEDICATED  24503   70       6487 alter system kill session '282,45262' immediate;

# netstat -npo  | grep 24503

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (27.72/0/0)

--//这台服务器竟然使用tcp6.

# seq 1000 | xargs -IQ bash -c "netstat -npo 2>/dev/null | egrep 'ESTABLISHED 24503'| egrep 'oracleorclcdb|sqlplus' ;sleep 0.999"

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (13.75/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (12.65/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (11.54/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (10.42/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (9.31/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (8.19/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (7.09/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (5.98/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (4.88/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (3.76/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (2.65/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (1.55/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (0.44/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (5.35/0/0)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (4.24/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (3.14/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (2.02/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (0.92/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (53.94/0/0)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (52.82/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (51.74/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (50.63/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (49.52/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (48.41/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (47.30/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (46.19/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (45.08/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (43.98/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (42.87/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (41.77/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (40.65/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (39.53/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (38.42/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (37.32/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (36.22/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (35.11/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (34.00/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:52938      ESTABLISHED 24503/oracleorclcdb  keepalive (32.89/0/0)

^C

--//SQLNET.EXPIRE_TIME=1，相当于60秒。很奇怪netstat看到的分2部分，一部分是6->0,另一部分54－>0 .加起来是6+54=60秒。

--//很奇怪的现象,注意看下划线部分。

--//我设置SQLNET.EXPIRE_TIME=2，看到的情况如下：

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:54086      ESTABLISHED 28143/oracleorclcdb  keepalive (5.41/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:54086      ESTABLISHED 28143/oracleorclcdb  keepalive (4.42/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:54086      ESTABLISHED 28143/oracleorclcdb  keepalive (3.41/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:54086      ESTABLISHED 28143/oracleorclcdb  keepalive (2.41/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:54086      ESTABLISHED 28143/oracleorclcdb  keepalive (1.41/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:54086      ESTABLISHED 28143/oracleorclcdb  keepalive (0.41/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:54086      ESTABLISHED 28143/oracleorclcdb  keepalive (113.72/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:54086      ESTABLISHED 28143/oracleorclcdb  keepalive (112.73/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:54086      ESTABLISHED 28143/oracleorclcdb  keepalive (111.73/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:54086      ESTABLISHED 28143/oracleorclcdb  keepalive (110.73/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:54086      ESTABLISHED 28143/oracleorclcdb  keepalive (109.74/0/0)

tcp6       0      0 192.168.x.x:1521        192.168.yy.y:54086      ESTABLISHED 28143/oracleorclcdb  keepalive (108.74/0/0)

--// 114+6 = 120.

莎漠
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle ENABLE=BROKEN
sinbada118的博客
11-18 1120
如果一个空闲的DB连接，在防火墙设置的TCP超时时间内没有活动，就会被防火墙切断连接。 为了防止DB连接被切断，其中一个方法就是在连接描述里加上ENABLE=BROKEN，比如： jdbc:oracle:thin:@(DESCRIPTION=(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=myhost))(CONNECT_DATA=(SID=orcl))) ...
oracle enable broken,[20200220]关于SQLNET.EXPIRE_TIME and ENABLE=BROKEN的总结.txt
weixin_39539684的博客
04-13 469
[20200220]关于SQLNET.EXPIRE_TIME and ENABLE=BROKEN的总结.txt--//昨天做了大量关于SQLNET.EXPIRE_TIME and ENABLE=BROKEN的测试，晚上再仔细看，测试做的有点乱。--//做一些总结：1. 12c之前设置SQLNET.EXPIRE_TIME在sqlnet.ora文件中,DCD判断链接并不使用TCP keep-alive...
oracle enable broken,使用带有即时客户端的cx\u Oracle的任意选择失败
weixin_39827585的博客
04-13 199
我试图使用cx\u ORACLE从oracle12c数据库中选择数据，但得到了一个异常：“cx_Oracle.OperationalError错误：ORA-03113：通信信道上的文件结束”。你知道吗我的查询在使用Pycharm时表现良好(jdbc:甲骨文：瘦驱动程序)。但是，在python3.6中使用cx\u Oracle时，除非我将in子句中的id数从500减少到大约250，否则查询将失败。这...
tnsnames.ora配置小结
snakeqi的专栏
01-14 4476
listener.ora、 tnsnames.ora和sqlnet.ora这3个文件是关系oracle网络配置的3个主要文件，其中listener.ora是和数据库服务器端相关，而tnsnames.ora和sqlnet.ora这2个文件不仅仅关系到服务器端，主要的还是和客户端关系紧密。检查客户端oracle网络的时候可以先检查sqlnet.ora文件：# SQLNET.ORA Network
Oracle 10g 创 建 物 理 备 用 数 据 库 (Broken) - Linux, Unix
Watson的专栏
06-21 1224
Oracle 10g 创 建 物 理 备 用 数 据 库 (Broken) - Linux, Unix 参考文档: http://download.oracle.com/docs/cd/B12037_01/server.101/b10822/dgmgrl.htm Oracle版本: 10.2.0.1.0, 10.2.0.2.0, 10.2.0.4.0 OS版本: RedhatAS4u8,
Microsoft.SqlServer.Diagnostics.STrace.zip
06-04
未能加载文件或程序集“Microsoft.SqlServer.Diagnostics.STrace, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91”或它的某一个依赖项。系统找不到指定的文件。 (Microsoft.SqlServer.Dmf) ...
Microsoft.SqlServer.Diagnostics.STrace.dll
03-01
未能加载文件或程序集“Microsoft.SqlServer.Diagnostics.STrace, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91” 或它的某一个依赖项。系统找不到指定的文件。 (Microsoft.SqlServer.Dmf)
SqlServer.Diagnostics.STrace.dll
05-04
“Microsoft.SqlServer.Management.Dmf.PolicyStore”的...找对版本将Microsoft.SqlServer.Diagnostics.STrace.dll复制到C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE这个目录 即可。
免安装strace strace.zip
07-20
免安装strace [root@vmtca-2003 strace-5.1]# ldd strace linux-vdso.so.1 (0x00007ffc14ffb000) librt.so.1 => /lib64/librt.so.1 (0x00007fe620539000) libc.so.6 => /lib64/libc.so.6 (0x00007fe620174000) ...
oracle keep alive,[20200220]windows设置keepalive参数.txt
weixin_39965673的博客
04-15 733
[20200220]windows设置keepalive参数.txt--//昨天测试了ENABLE=BROKEN在连接串中，可以发现在客户端启用了TCP keep-alive feature特性。而缺省tcp_keepalive_time设置--//7200秒，时间有点长。许多客户端或者中间服务器使用的是windows系统，如何修改注册表呢？--//检索找到如下链接：http://www.cppb...
oracle failovermode,Oracle Failover - TAF 透明应用切换
weixin_29977617的博客
04-04 817
failover =(DESCRIPTION =(enable=broken)(LOAD_BALANCE = yes)(ADDRESS = (PROTOCOL = TCP)(HOST = hprac-22)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = hprac-23)(PORT = 1521))(ADDRESS = (PROTOCOL = TC...
Oracle 数据库连接池
weixin_33835690的博客
10-11 357
jdbc:oracle:thin:@(DESCRIPTION=(failover=on)(enable=broken)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.110.120.10)(PORT=1521))(LOAD_BALANCE=yes))(CONNECT_DATA=(SERVICE_NAME=DBName)(failover_mode=(t...
jdbc oracle 负载均衡,JDBC/RAC 负载均衡小结
weixin_35884854的博客
04-09 470
JDBC/RAC 负载均衡小结中文社区 (MOSC)中间件 (MOSC)0 RepliesLast updated on February 16, 2015This question is Not Answered.下面是这几天大概看了一下相关的jdbc driver的代码做的一个简单的总结。[Environment]RAC URL:jdbc:oracle:thin...
[Oracle] RAC 之 - HA
runfeel
06-14 114
RAC的HA是它的一大卖点，Oracle也常那它来宣传，但实际上，RAC称不上真正的HA，因为它是share-disk的架构，只能做到实例级的HA。RAC实例级HA的技术基础是Failover，它是指集群中任何一个节点的故障都不会影响用户的正常使用，之前连接在故障节点上的用户会被自动转移到健康节点，这样的切换对用户来说是透明的。 RAC的Failover可以细分为以下3种： 1）Client-...
未公开的Oracle数据库秘密
DBA Tips
05-10 1330
第一部分　初始化参数 　　第1章　在文档中部分说明的参数　2 　　1.1　AUDIT_SYSLOG_LEVEL　2 　　1.1.1　syslog设备　2 　　1.1.2　审计简介　3 　　1.1.3　使用AUDIT_SYSLOG_LEVEL参数　4 　　1.1.4　审计非特权用户　5 　　1.1.5　小结　6 　　1.2　PGA_AGGREGATE_
comment to Oracle中dblink所产生远程会话的一些表现
aaaaaa的专栏
10-31 674
1 comment to Oracle中dblink所产生远程会话的一些表现 How To Remove a Dead Connection to the Target Database Through DBlink After a Network Connection Failure Applies to: Oracle Net Services – Version: 8.
oracle tnsnames.ora配置详解
盏茶作酒的博客
07-09 5468
tnsnames.ora是连接oracle的重要配置文件 在这个文件中主要由以下内容 text= ##这个text名字可以自己随意编写，将会先实现pl/sql登录界面数据库选项 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = text) ##这个text是...
Oracle解决ora-12514 问题
飞龙YF的博客
04-12 451
找到oracle安装目录如：C:\app\yfan\product\11.2.0\client_2 找到一下文件： \product\11.2.0\client_2\network\admin\tnsnames.oRA 内容： PNET_ITG = (DESCRIPTION = (SDU = 32768) (enable = broken) (LOA...
strace 跟踪进程退出
最新发布
11-03
strace是一个在Linux系统中用来跟踪进程的工具。它可以用来监控进程执行期间的系统调用和信号处理，以及进程的退出情况。 通过strace命令加上进程的PID，我们可以获取到该进程执行期间的系统调用信息。而当进程退出...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值