Re: ora-12154 and no trace

comments embedded.

Hth,

Sybrand Bakker, Oracle DBA

"Ed Stevens" <Ed.Stevens_at_nmm.nissan-usa.com> wrote in message news:8n1g41$vg1$1_at_nnrp1.deja.com...
> I started out with one puzzler, then ran into another on the way to
> trying to solve the first.
>
> Both client and server machines are NT 4, sp4.

which are known to provide sever problems in combination with Oracle, as Microsux overhauled the T CP/IP stack.
>
> First puzzler: Several developers report getting an ORA-12154 when
> they try to connect with SQL*Plus, yet have no problem connecting with
> other tools, such as PowerBuilder, or the applications they are writing.

They must be using two different tnsnames.ora

>
> Second puzzler: I was planning on generating two trace files, so went
> to the client's SQLNET.ORA file, set trace_level_client = 16, and
> trace_directory_client = c:\orant\net80\trace. Then tried to connect
> with SQL*Plus. Got the 12154, but no trace file! Searched the entire
> C: drive for it, but no joy.
>

This proves sqlnet is *not* using the sqlnet.ora you edited and there is another sqlnet.ora floating around or you have your tns_admin variable set to a different sqlnet.ora

> And now another curiosity -- on my own machine, when I deliberately
> enter an invalid connect string to generate a 12154, I get a 12203
> instead!
>

Again most likely it is not using the configuration files you expect it to use.
>
> --
> Ed Stevens
> (Opinions are not necessarily those of my employer)
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Aug 11 2000 - 00:00:00 CDT