连接监听速度慢，tnsping时间20毫秒

C:\Users\admin>sqlplus admin /admin@ora11g

SQL*Plus: Release 11.2.0.1.0 Production on 星期二 7月 31 09:28:49 2012

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

 

连接时间需要20秒左右，PLSQL前端输用户名密码登录都非常慢。

C:\Users\admin>tnsping  ora11g

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 31-7月 -2012 09:20:01

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

已使用的参数文件:
E:\Oracle11g\app\admin\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora

已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.11)(PORT = 1521))) (CONNECT_DATA = (
SERVICE_NAME = db1)))
OK (20 毫秒)

C:\Users\admin>tnsping ora11g

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 31-7月 -2012 09:20:08

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

已使用的参数文件:
E:\Oracle11g\app\admin\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora

已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.11)(PORT = 1521))) (CONNECT_DATA = (
SERVICE_NAME = db1)))
OK (0 毫秒)

C:\Users\admin>tnsping  ora11g

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 31-7月 -2012 09:20:02

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

已使用的参数文件:
E:\Oracle11g\app\admin\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora

已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.11)(PORT = 1521))) (CONNECT_DATA = (
SERVICE_NAME = db1)))
OK (10 毫秒)

 

解决办法：

[root@cdc1 ~]# more /etc/resolv.conf
nameserver 10.10.10.1

清空掉DNS后，恢复正常。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26839123/viewspace-739025/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26839123/viewspace-739025/