客户端第一次与 Oracle 创建连接时特别慢

[pengfei]

oracle 在华为云上, 连接公司内网, 不管是在开发机器还是和 oracle 在同一网段的 ecs 主机, 建立连接的时候都得等一会, 而且是可以连上的, 就是一次慢 排查很多地方

1. ping, tnsping 速度很快

C:\Users\Administrator>tnsping 10.12.20.13

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 19-9 月 -2019 21:07:53

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

已使用的参数文件:
D:\app\Administrator\product\11.2.0\network\admin\sqlnet.ora

已使用 EZCONNECT 适配器来解析别名
尝试连接 (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=10.12.20.13)(PORT=1521)))
OK (120 毫秒)

1. 监听日志 1M 左右并不是很大,监听文件直接配置的 ip 并配了三个端口

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS_LIST=
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.12.20.13)(PORT = 1521)(RATE_LIMIT=yes))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.12.20.13)(PORT = 1522)(RATE_LIMIT=yes))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.12.20.13)(PORT = 1523)))
    )
  )

1. 告警日志

Fatal NI connect error 12537, connecting to:
 (LOCAL=NO)

  VERSION INFORMATION:
	TNS for Linux: Version 11.2.0.1.0 - Production
	Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
	TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
  Time: 19-SEP-2019 19:44:48
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12537
    
TNS-12537: TNS:connection closed
    ns secondary err code: 12560
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
opiodr aborting process unknown ospid (31522) as a result of ORA-609

不知道怎么解决, 能连上就是慢, 大佬们支持下

[pengfei]

好像解决了, 把 dns 统统注释掉