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)
Print Article