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

From: Laurenz Albe <>
Date: 16 Oct 2008 08:12:20 GMT
Message-ID: <>

beta <> wrote:
> The /opt is a mistake, here is my new environment setup - I have only
> one tnsname.ora

> ##### tnsname.ora

Sorry to interfere with a triviality, but the kind of error you get is usually due to trivialities.

Is the file really called "tnsname.ora"? That would be the problem then, because the file must be called tnsnames.ora

I would enable client tracing in sqlnet.ora (parameters TRACE_LEVEL_CLIENT and TRACE_DIRECTORY_CLIENT). That would tell you in great detail where the problem is.

Laurenz Albe Received on Thu Oct 16 2008 - 03:12:20 CDT

Original text of this message