Re: ORA-12560: TNS:protocol adapter error

I too had this problem and have resolved it with the help of a Sr.DBA on these news groups. I have forgtten his name, but not the solution. Win2k Server will start the services but does not startup, mount and open the database.

Make sure that the Listener and Oracle services are started then, From the Start Menu, go to The Oracle Database Administration menu. Launch DBAStudio. Connect to the database by logging in using system/manager but change normal to sysdba. Select the database and instance and then startup the database ( the dialogue in the right hand pane is quite intuitive). Close DBAStudio and you should be able to access the database through SqlPLus or svrmgrl.

Sorry if these instructions are a bit off, but the general ideas are there. I'm typing this from memory, as I don't have an Oracle database on Win2k available right now.

Good luck,

Geoff MacGowan

J. Fleck <fleckj__at_hotmail.com> wrote in message news:9u67vp$199b$1_at_scavenger.euro.net...
> Anant
>
> You are not the only one with this problem with WY2K. If you search on the
> internet you will find lots people with the same problem. Nobody with a
> solution. Most of the suggested solutions assume that you have can access
a
> database via sqlplus, but as you say this error occurs while trying to
> install the database.
>
> You may receive answers from "Senior DBA's" saying that it is your fault,
> because you have not read the documentation. If you ask where should I
look
> in the documentation, where is the subject discussed - a deadly silence.
>
> I would like to know what is the correct protocol (or incorrect protocol).
> Please " Senior Dba's" don't tell me everything just give me a hint. I am
> sure that my tsnames.ora, sqlnet,ora and listner.ora are incorrect but I
> don't know how to fix them possibly because they are generated by Oracle
and
> the error occurs before I even have a chance to fix them.
>
> Is there a small chance that under certain circumstances, I know what I am
> now going to say is heresy - is it possible that there is a bug in Oracle
> WY2K
>
> Regards
>
> Jim Fleck
> "Anant" <anantt_at_ittindia.com> wrote in message
> news:b816ff27.0111290247.36be7b0_at_posting.google.com...
> > Dear Sir
> > I am on Win 2000 . Attempting to install Oracle 8.1.7.
> > Ora-12560 occurs when I attempt to log onto svrmgr.
> > Plus the above mentioned errors when I let the assistant create the db.
> > Any assistances would be appreciated.
> > Thanks
> > Anant
> >
> > I am going to install the Oracle server for that
> > i have to run SERVERMGRL at that time it giving error.
> > D:\>SVRMGRL
> > Oracle Server Manager Release 3.1.7.0.0 - Production
> > Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
> > ORA-12560: TNS:protocol adapter error
> >
> > SVRMGR>
>
>
Received on Thu Nov 29 2001 - 19:08:33 CST