数据库的sqlplus连接慢,tnsping延时比较大
[oracle@localhost admin]$ tnsping orcl_sd
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 12-JAN-2015 01:54:59Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.21.219)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl_sd)))
OK (18340 msec)
查看vim /etc/resolv.conf
nameserver 192.168.1.6
search localdomain
果断注释 nameserver 192.168.1.6
[oracle@localhost ~]$ tnsping orcl_sd
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 12-JAN-2015 02:15:10
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.21.219)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl_sd)))
OK (0 msec)
[oracle@localhost ~]$
一切正常