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

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 - 15:01:45 CST