Re: ORA-12560: TNS:protocol adapter error

From: Trifon Anguelov <trifona_at_pacbell.net>
Date: Sun, 21 Apr 2002 17:21:48 GMT
Message-ID: <MyCw8.4182$iA7.1965835482@newssvr14.news.prodigy.com>

Mark,

You have to create database first and then to start the SQL*Plus. Without one you are trying to connect to non-existing one.

If you have more than one database on your machine then open command prompt: c:> set oracle_sid=<SID>
c:> sqlplusw

Also make sure that your OracleService<SID> is started before doing the above. The error could be seen if the service is not running.

Check the latest Oracle DBA forums:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

Hope that helps,

Trifon Anguelov
Senior Oracle DBA

http://www.dbaclick.com

---

---

"Mark Ashton" <mark.ashton_at_blueyonder.co.uk> wrote in message news:qeVv8.7561$hg2.445649_at_news-binary.blueyonder.co.uk...
> Hi,
>
> I am learning Oracle and have just installed Oracle 8i enterprise onto win
> 2000 advanced Server.
> When I launch SQL*plus and input the ID 'system/password' the above error
is
> returned (I have no databases set up yet).
> Any help is greatly apprciated...!
>
> Cheers
> Mark
>
>
Received on Sun Apr 21 2002 - 12:21:48 CDT