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

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

This topic created in 2412 days ago, the information mentioned may be changed or developed.

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

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 毫秒)

监听日志 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)))
    )
  )

告警日志


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

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

1 replies

pengfei

Sep 19, 2019

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