ORA-12154: TNS:could not resolve the connect identifier specified

ORA-12154: TNS:could not resolve the connect identifier specified

  
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:
http://stackoverflow.com/questions/20361325/this-is-error-ora-12154-tnscould-not-resolve-the-connect-identifier-specified
http://ora-12154.ora-code.com/
http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm
check out http://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 :/
Statler (lol) don;t know if we're using proxy, have to find out.
And the stackoverflow link ... I already posted it :-))
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.
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)
    )
  )

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()
 
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/