My Oracle Support Banner

GSM-40148: Database Task Failed:database, Status 4, Message:ORA-12170: TNS: Connect timeout occurred (Doc ID 3061003.1)

Last updated on NOVEMBER 28, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.24.0.0.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.

Symptoms

 From GSM: alert_GSM.log, Getting TNS timeout errors accessing one specific database. When run the sync database command for this database it fails with timeout.  

 Deleted the entries from gsmadmin_internal.gsm_requests and bounced the primary GSM to free up the pending requests. This does not solve the issue with the connection timeout.

Changes

 Unnecessary database links being used for GDS configurations causing TNS errors during 'gdsctl' operations.

Cause

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
Symptoms
Changes
Cause
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.