Re: tns error

modify sqlnet.ora on any client
add/change

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

I dont have any of these entries in my sqlnet.ora file on the client what do I have to do to get these entries

BTW
I dont have 200 clients connecting to the database all the time just a few at a time and I have the OAS with a few users who use it for very basic purposes

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.

sybrandb_at_my-deja.com wrote:

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

--