Re: TNS: could not resolve service name

Use TNSPING to check connectivity. It's in Oracle_HOME/bin and take one parameter - Service_Name (or, if you prefer, the key into the TNSNAMES.ORA file). Great for troubleshooting messed up Oracle networking.

/H

George Ye wrote:

> If the database is not on your local machine, you must specify a
> service name, i.e. ORCL. And, the service name must be defined in NET 8
> config, which contains the address of the database server machine, port
> number(default), database instance name, etc.
>
> If the problem is still there, you'd better check whether the server
> listener works correctly.
>
> Hope helpful.
> >
> > I run sqlplus scott/tiger, and I got an error message as:
> > ERROR:
> > ORA-12154: TNS: could not resolve service name.
> > Do I miss something?
> > Thanks for any help.
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Nov 18 2000 - 18:29:11 CST