Re: tns error

In article <3A7A7F25.926FB16A_at_gre.ac.uk>,   Simon Cunningham <cs40_at_gre.ac.uk> wrote:
> Hello
>
> I have a win nt 4 server with 816 ent edition database. Now this
 seems
> strange and oracle help desk could not help me out so here goes......
>
> I could connect to my database fine for the past seven months and all
 of
> my 200 client machines can connect fine.
>
> I have just installed OAS 408 onto the same machine into a different
> directory all went well but alas when installing the OAS I didnt
> shutdown the database.
>
> Now when I try to connect to the database I get a message that could
 not
> resolve the service name ora-12154....
>
> I can connect at the server itself but not on any of my clients....
> Now I use the same Tnsnames.ora file throughout my network and the
 same
> on the server....
> I have the files all in the right directories and everything seems
 fine
> the listner is started in the services throught control panel
> settings...
>
> I am at a loss
>
> anyone give me some help would be good
>
>

modify sqlnet.ora on any client
add/change

trace_level_client = 16
trace_directory_client = <any directory>
trace_unique_client = true

This will generate a sqlnet<xx>.trc or cli<xx>.trc which will show you exactly which tnsnames.ora it is using. My recent experience tells me syntax errors in tnsnames.ora also result in 12154.

Word of advice:
Don't you think one single NT 4.0 server with Oracle server and OAS on it and 200 clients connecting to it, is going to collapse very soon?

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/