My Oracle Support Banner

使用SCAN IP连接时响应时间较慢 (Doc ID 2577579.1)

Last updated on AUGUST 21, 2019

适用于:

Oracle Database - Enterprise Edition - 版本 12.1.0.2 和更高版本
本文档所含信息适用于所有平台

症状

当通过DNS进行解析RACDataGuardtnsping服务响应慢:


>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!


文档内容
症状
更改
原因
解决方案

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.