监听连接缓慢

来源：互联网发布：java注册时邮箱验证编辑：程序博客网时间：2024/06/08 15:59

今天一个数据库的监听连接特别慢， tnsping一下，响应也是很慢，但是通过sqlplus /as sysdba 连接特别快

C:\Users\Administrator>tnsping newbos
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 29-8月 -
2014 16:36:33
Copyright (c) 1997, 2010, Oracle. All rights reserved.

已使用的参数文件:
D:\app\Administrator\product\11.2.0\client_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10
.129.40)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = newbos)))
OK (14600 毫秒)

初步怀疑，是不是日志太大，导致监听连接缓慢，去把日志清理了一下，发现tnsping 还是很慢，一般网上比较多的就是 /etc/hosts 或者 /etc/resolv.conf 文件中参数配置错误等等问题，

对 /etc/hosts 文件进行检查，发现没有问题，参数配置正确。

查看 /etc/resolv.conf

aix_power_db:/home/oracle$cat /etc/resolv.conf
nameserver 10.10.126.5
domain zjs
nameserver 10.10.126.25

不确定参数，不知道那个能参数不正确

truss -fea sqlplus boswll/"mima"@NEWBOS 注释/etc/resolv.conf中个别参数命令来测试哪些是正确的。

没有注释前

16056484: 44826755: gethostname(0x0FFFFFFFFFFF5394, 4088) = 0
16056484: 44826755: appgetrlimit(7, 0x0FFFFFFFFFFF6628) = 0
16056484: 44826755: __libc_sbrk(0x0000000000020020) = 0x00000001102BD920
16056484: 44826755: socket(2, 1, 0) = 7
16056484: 44826755: kfcntl(7, F_GETFL, 0x0000000000000000) = 2
16056484: 44826755: kfcntl(7, F_SETFL, 0x0000000000000006) = 0
16056484: 44826755: kioctl(7, -2147195266, 0x0FFFFFFFFFFF1398, 0x0000000000000000) = 0
16056484: 44826755: getsockopt(7, 65535, 4104, 0x0FFFFFFFFFFF1F64, 0x0FFFFFFFFFFF1F60) = 0
16056484: 44826755: connext(7, 0x00000001102D66D0, 16) = 0
16056484: 44826755: kfcntl(7, F_GETFL, 0x0000000000000000) = 6
16056484: 44826755: kfcntl(7, F_SETFL, 0x0000000000000002) = 0
16056484: 44826755: kioctl(7, -2147195266, 0x0FFFFFFFFFFF1398, 0x0000000000000000) = 0
16056484: 44826755: ngetsockname(7, 0x0FFFFFFFFFFF29A8, 0x0FFFFFFFFFFF2050) = 0
16056484: 44826755: getsockopt(7, 65535, 4097, 0x0FFFFFFFFFFF2FF4, 0x0FFFFFFFFFFF2FF0) = 0
16056484: 44826755: getsockopt(7, 65535, 4098, 0x0FFFFFFFFFFF2FF4, 0x0FFFFFFFFFFF2FF0) = 0
16056484: 44826755: setsockopt(7, 6, 1, 0x0FFFFFFFFFFF2FFC, 4) = 0
16056484: 44826755: kfcntl(7, F_SETFD, 0x0000000000000001) = 0
16056484: 44826755: sigprocmask(2, 0x09001000A04E1AC8, 0x0FFFFFFFFFFF3A60) = 0
16056484: 44826755: _sigaction(13, 0x0FFFFFFFFFFF3B90, 0x0FFFFFFFFFFF3BE8) = 0
16056484: 44826755: thread_setmystate(0x0FFFFFFFFFFF3650, 0x0000000000000000) = 0
16056484: 44826755: __libc_sbrk(0x0000000000010020) = 0x00000001102DD940
16056484: 44826755: kwrite(7, "\0 001\0\0\001 :01 ,".., 235) = 235
16056484: 44826755: kread(7, "\0\0\0\0\0\0\0\0\0\0\0\0".., 8208) (sleeping...)

在此处停止，一直等待很久，才会继续输出日志，后来注释掉前面两个立马问题解决，看来还是参数填写不正确

0 0