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

Thank you Kenneth and zeb for answering my question!

Kenneth nailed the problem. orcl doesn't exist on my machine, it's called something else.

The problem is I didn't and still doesn't know what ORACLE_SID represents. Is there any online resource or good book you can recommend on Oracle system variables?

Thanks,
Eric

<Kenneth Koenraadt> wrote in message
news:4016cde8.5599071_at_news.inet.tele.dk...
> Hi Eric,
>
> I assume you are logged on to the database host. oracle_sid=<SID> is
> only working on the host, as it bypasses Net8.
>
> Either
> 1) you have the service "Oracleservice<SID>" stopped
> or
> 2) you have no database server "orcl" on your host.
>
> go to Settings->Control Panel->Administrative Tools->Services. Look up
> a service called "OracleServiceorcl". If that is not present , 2) is
> the problem. Then you either need to create a new database with name
> "orcl" or connect to another Oracle database service present on the
> list. A service named "Oracleservicexxx" translates to oracle_sid=xxx
> on the command line.
>
> If the service is present, but not started, it's 1). Start it, and
> everything is fine.
>
> - Kenneth Koenraadt
>
>
> On Tue, 27 Jan 2004 15:00:10 -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!
> >
> >Eric
> >
> >
> >
>
Received on Tue Jan 27 2004 - 16:02:55 CST