使用SCAN IP连接时响应时间较慢
(Doc ID 2577579.1)
Last updated on AUGUST 21, 2019
适用于:
Oracle Database - Enterprise Edition - 版本 12.1.0.2 和更高版本本文档所含信息适用于所有平台
症状
当通过DNS进行解析RAC和DataGuard时tnsping服务响应慢:
>tnsping "(DESCRIPTION_LIST= (LOAD_BALANCE=off) (FAILOVER=on) (DESCRIPTION=(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=xxx-scan.us.xxxx.com)(PORT=port)))(CONNECT_DATA=(SERVICE_NAME=xxxx,us.oracle.com)))
> (DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=xxx-scan.us.xxx.com)(PORT=port)))(CONNECT_DATA=(SERVICE_NAME=xxxx,us.oracle.com))))" 22
TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 20-MRZ-2019 10:27:28
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Connection attempt with (DESCRIPTION_LIST= (LOAD_BALANCE=off) (FAILOVER=on) (DESCRIPTION=(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=xxx-scan.us.xxx.com)(PORT=port)))(CONNECT_DATA=(SERVICE_NAME=xxxx,us.xxxx.com)))
OK (0 ms)
OK (10 ms)
OK (5000 ms) <<<<<<<<<<<<<<<<<<
OK (10 ms)
5000 ms 是非常高的值.
更改
没有
原因
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
文档内容
| 症状 |
| 更改 |
| 原因 |
| 解决方案 |