Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TNS:could not resolve service name ERROR - HELP
In article <351513A7.E4DDCEDD_at_thrush.com>,
Mahmoud Tighiouart <mt_at_thrush.com> wrote:
>
>
> Bob Duncan wrote:
>
> > I'm trying to connect to Oracle 7.3 using SQL Plus and I get the following
> > error:
> > ERROR: ORA-12154: TNS:could not resolve service name
> >
> > I then get a login which I enter and then I get the following error:
> > ERROR: ORA-03121 No interface device connected - function not performed
> >
> > Any ideas?
> > Thanks!
>
> depending of sqlnet version, you might want to put in your tnsnames.ora file the
> IP
> address of the server you're trying to connect to instead of the host name if your
> client
> is configured for resolving names to ip using a DNS.
>
>
If you only have that one application configured you might check to make sure you have not some how deleted TNSNAMES.ORA or changed it via editing. Also the location of it and the fact that there is just one version of that file on your machine is important. Good luck.
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Mar 24 1998 - 00:00:00 CST