Re: HELP... ORA-12560 TNS:protocol adapter error

Check also if your listener is working correctly : lsntrctl status. Maybe it didn't start after the boot.
This command will give you the services running and when you'll look in the file tnsnames.ora you 'll be able to see if the right services are configurated
The tns error doesn' t mean that your database is corrupted. It simply means that you dont't manage to reach it. It is a network error

"Walter T Rejuney" <BlueSax_at_Unforgetable.com> a écrit dans le message news: 39B5C00C.81DCFA6E_at_Unforgetable.com...
> > > I have just migrated to 8.1.5 on NT4. All seemed ok, I hade analyzed
> > > the schemas and checked a few tables and all looked good. That was
> > > yesterday though, today I can't even connect to the database. If I try
> > > "sqlplus internal" or any other user I get "ORA-12560 TNS:protocol
> > > adapter error". I tried svrmgrl and get the same, via the listener I
> > > also get the error. I have rebooted (in true NT style) and nothing
> > > changes. I get no errors in any trace or log file.
> > >
> > > What's gone wrong folks, any ideas?
> > >
> > > Regards
> > > Tony
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
>
> Apparently the biggest cause for the 12560 error is that ORACLE_SID is not
 set in
> the environment.
>
> Try entering
>
> set ORACLE_SID=xxxx
>
> (where xxxx is the name of your sid) prior to starting svrmgrl or sqlplus.
>
> Alternatively, check your registry and make sure that ORACLE_SID is
 properly defined
> there.
>
> If you have Oracle support you can use your CSI to create a MetaLink
 account on the
> Oracle support site. Then just search for 12560 and you'll probably come
 up with a
> couple hundred articles with different variations on this problem.
 Unfortunately
> there is no one fix that will solve every possible scenario.
>
>
Received on Fri Sep 08 2000 - 11:22:56 CDT