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

> > 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 Tue Sep 05 2000 - 22:54:52 CDT