Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12560: TNS:protocol adapter error
Doesn't the installer walk you through making a default toy database
virtually automatically any more?
Mark, early on in running ORAINST, it ought to ask you about that (unless, as I say, they've changed that bit); if you're just setting up for a tutorial type thing, let the installer create it and set things up for you.
As everyone's said so far, you can't log in to a database you do not have. Also, if you're just learning Oracle, it's best to let the installer do most defaults it wants to do and not go and experiment.
Before proceeding, you ought to run the installer to DEINSTALL whatever you have installed, and begin anew; Oracle used to forget to clean up the registry properly, and leave bits and pieces around in directories, so you might want to check for little landmines before you run the installer again
RSH.
"Trifon Anguelov" <trifona_at_pacbell.net> wrote in message
news:MyCw8.4182$iA7.1965835482_at_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
>
> --------------------------------------------------------------------------
--Received on Mon Apr 22 2002 - 12:30:44 CDT
> ---------------------------------------
> "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
> >
> >
>
>