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
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
已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.11)(PORT = 1521))) (CONNECT_DATA = (
SERVICE_NAME = db1)))
OK (0 毫秒)
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
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
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
nameserver 10.10.10.1
清空掉DNS后，恢复正常。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26839123/viewspace-739025/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
统计信息的备份恢复
请登录后发表评论
登录
全部评论
