From: sybrandb@my-deja.com Newsgroups: comp.databases.oracle.misc Subject: Re: tns error Date: Fri, 02 Feb 2001 10:27:28 GMT Organization: Deja.com Lines: 59 Message-ID: <95e22c$jjo$1@nnrp1.deja.com> References: <3A7A7F25.926FB16A@gre.ac.uk> NNTP-Posting-Host: 194.229.115.34 X-Article-Creation-Date: Fri Feb 02 10:27:28 2001 GMT X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT) X-Http-Proxy: 1.1 x53.deja.com:80 (Squid/1.1.22) for client 194.229.115.34 X-MyDeja-Info: XMYDJUIDsybrandb In article <3A7A7F25.926FB16A@gre.ac.uk>, Simon Cunningham 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 = trace_unique_client = true This will generate a sqlnet.trc or cli.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/