Re: ERROR: ORA-12560: TNS:protocol adapter error

On Tue, 27 Jan 2004 15:01:59 -0500, "Eric" <ericd__at_hotmail.com> wrote:

>Hi,
>
>I tried setting up the SQL*Plus environment as suggested here:
>
>http://www.orafaq.org/faqplus.htm#USE
>
>I typed in
>
>Click on "Start" -> "Run" and enter "cmd"
>C:> set ORACLE_SID=orcl
>C:> sqlplus scott/tiger
>
>
>and the output I got was this:
>
>ERROR:
>ORA-12560: TNS:protocol adapter error
>
>What is the problem? And how to resolve this?
>
>Thanks in advance!
>

If Kenneth Koenraad suggestions do not work, you must be using Microsux Terminal Server. In Microsux Terminal Server the strategy outlined above doesn't work c/o Microsux. You need to
set local=<tns servicename>
prior to firing up sqlpluse

But actually your problem is you didn't search on Google and posted the same old boring question yet again.

>Eric
>

--
Sybrand Bakker, Senior Oracle DBA