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
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!
Have you used the SQL-net Easy Config to generate your configuration files? If so, try using the TNSping facility to ping the instance. If you can't ping the instance you can't sign on, investigate why. Make sure you're going to the right place (check the address etc.), can you ping the server itself (if using IP)? Received on Mon Mar 16 1998 - 00:00:00 CST