Oracle Error Connecting to Database (TNS Connect Timeout)

Tags ORA-12170

Issue/Question

Receiving an error

Error: The ODBC driver reported the following diagnostics [Oracle][ODBC][Ora] Ora-12170: TNS: Connect timeout occurred

Error: ORA-12505: TNS:Listener does not currently know the SID given in connect descriptor

Environment

  • PL/SQL Developer  or  software creating ODBC connection to Oracle
  • Oracle database

Cause

Probable TNSNAMES.ORA issue

Resolution

  1.  Please contact the Service Desk with the following information: 
    1. Capture of the error message
    2. Which environment you are attempting to connect to (PROD, TEST, etc)

Details

Article ID: 5623
Created
Thu 10/8/20 3:40 PM
Modified
Wed 3/10/21 4:25 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated