Slow Response Time When connecting using SCAN IP (Doc ID 2525873.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Observed slow response with tnsping when the scan entry for the RAC and DataGuard servers via dns produce long tnsping times :

>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,<domain>)))
> (DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=xxx-scan.<domain>)(PORT=port)))(CONNECT_DATA=(SERVICE_NAME=xxxx,<domain>))))" 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.<domain>)(PORT=port)))(CONNECT_DATA=(SERVICE_NAME=xxxx,<domain>)))

OK (0 ms)
OK (10 ms)
OK (5000 ms)           <<<<<<<<<<<<<<<<<<
OK (10 ms)

5000 ms is very high value.

Changes

None

Cause

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