My Oracle Support Banner

Reducing Client Connection Delays When DNS Is Unresponsive (Doc ID 1449843.1)

Last updated on JULY 06, 2021

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
JDBC - Version 11.2.0.4.0 to 12.1.0.2.0 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Goal

In Oracle RAC clients frequently use DNS to resolve a scan name to one of three scan listener IP addresses.

Scan address setup in DNS


In situations where the primary nameserver is down, to perform maintenance for example, client connectivity and any operation involving resolution of the scan name may experience a delay. The delay is at the OS level since the DNS query must timeout and then failover to the secondary or backup nameserver.

There are multiple areas that can be tuned to mitigate client connection delays when a nameserver is down. These tips and solutions are also helpful in non-RAC environments.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

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