Skip to Content (Press Enter)
2011-06-15 10-51-22
Joop Stringer
55Views
6Comments
ORA-12154: TNS:could not resolve the connect identifier specified
Question
Oracle
We face a lot of timeouts in servicestudio (and running the application as well)
When checking the event log on the server, there are a lot of ORA messages:
ORA-12154: TNS:could not resolve the connect identifier specified
Anybody any suggestions what it might be and what might be the solution ?

This is what I found so far:
https://stackoverflow.com/questions/20361325/this-is-error-ora-12154-tnscould-not-resolve-the-connect-identifier-specified
https://ora-12154.ora-code.com/
https://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm
0
0
27 May 2014
Copy Link
2016-04-21 20-09-55
J.
 
MVP
check out https://stackoverflow.com/questions/7957955/ora-12154-could-not-resolve-the-connect-identifier-specified
and are you using a proxy by any chance? that can screw things up :/
0
0
27 May 2014
Copy Link
2011-06-15 10-51-22
Joop Stringer
Statler (lol) don;t know if we're using proxy, have to find out.
And the stackoverflow link ... I already posted it :-))
0
0
27 May 2014
Copy Link
2013-11-21 00-40-55
Curt Raddatz
This may have nothing to do with anything but thought I would mention it.  Your server should have a tnsnames.ora file in the \ORACLE\product\11.2.0\client_1\network\admin directory  (version could be different).  For reasons that I have not figured out yet that file gets replaced on occassion on my system with the original version of the file, which kills all my custom connections.  Maybe your problem is similar but you should at least check that file.
0
0
27 May 2014
Copy Link
2011-06-15 10-51-22
Joop Stringer
They have the tnsnames.ora in the folder C:\oracle\ora64\product\11.2.0\client_1\network\admin
and looks ok ...

# tnsnames.ora Network Configuration File: \\Nnw12182dat04\tns_central\tnsnames.ora
# Generated by Oracle configuration tools.
 
# auxiliary
 
# Quality assurance databases
 
# TNSNAMES.ORA 10.1.7.3
# Author: Manon Jager
# Version control
# 20120919 New
# 20121024 Add DBACAT
#   20121102 Add OSDV610 
# Development databases
 
OSQA610 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.7.3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = OSQA610)
    )
  )
 
DBACAT =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.7)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = DBACAT)
    )
  )
 
OSQA600 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.7.3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = OSQA600)
    )
  )
 
ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )
 
OSDV620 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.7.3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = OSDV620)
    )
  )
  
OSDV610 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.7.3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = OSDV610)
    )
  )
 
OSDV600 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.7.3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = OSDV600)
    )
  )

0
0
04 Jun 2014
Copy Link
2011-06-15 10-51-22
Joop Stringer
Errors we saw this morning are like this from OutSystems Log Service:

Error openning connection to the database: Oracle.DataAccess.Client.OracleException ORA-12154: TNS:could not resolve the connect identifier specified    at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
   at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
   at Oracle.DataAccess.Client.OracleConnection.Open()
   at OutSystems.HubEdition.LogService.DBLogServer.GetOracleConnection(DbConnectionInfo connectionInfo)
Cleaning the connection pools.
 
   at OutSystems.HubEdition.LogService.DBLogServer.GetOracleConnection(DbConnectionInfo connectionInfo)
   at #Xye.#Nze.#cze(List`1 msgList)
   at #Xye.#eze.#u.#pAe()
   at OutSystems.HubEdition.ServerCommon.SandboxUtils.ExecuteForAllSandboxes(Action action)
   at #Xye.#eze.#S8d()
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()
 
0
0
04 Jun 2014
Copy Link
2011-06-15 10-51-22
Joop Stringer
See also my post in this topic on ORA-03113 errors:
https://www.outsystems.com/forums/discussion/2865/how-to-reestablish-an-oracle-connection-after-a-network-failure/

0
0
04 Jun 2014
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.