今天centos上新装oracle11g r2版本 后发现用plsql登陆非常慢,jdbc登陆也很慢,但登入后处理增删改查都不慢
分析了下原因可能是当时装系统时设置了dns,而且装oracle的监听中直接配置的别名,可能解析时出问题了,修改后重启监听速度杠杠的快
修改内容如下
vi /etc/resolv.conf
# Generated by NetworkManager#nameserver 192.168.137.1vi /opt/oracle/app/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
ORCL =
(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.15)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)