Re: TNS:could not resolve service name ERROR

From: Nigel Rudgyard <nigel_at_rudgyard.demon.co.uk.nospam>
Date: 1998/03/16
Message-ID: <890077288.612.0.nnrp-07.c1ed0cd9@news.demon.co.uk>#1/1

What is the value of ORA_SID ? Does such an instance exist ? Are you sure that you have set up TNSNAMES.ORA, etc. are correct ? Is the listener running. Try stopping and restarting it, and see if any errors are reported. Finally, try using the '@' syntax to connect to your databases.

Bob Duncan wrote in message <01bd5033$a34e1700$2aa8a8c0_at_rduncan>...
>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!
Received on Mon Mar 16 1998 - 00:00:00 CST

Re: TNS:could not resolve service name ERROR - HELP