oracle 在华为云上, 连接公司内网, 不管是在开发机器还是和 oracle 在同一网段的 ecs 主机, 建立连接的时候都得等一会, 而且是可以连上的, 就是一次慢 排查很多地方
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 毫秒)
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 pengfei OP 好像解决了, 把 dns 统统注释掉 |