Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP... ORA-12560 TNS:protocol adapter error
Tony,
check if the listerner is running:
1. cd ORACLE_HOME\bin
2. lsnrctl status <SID>
if the listner is not running, then startup the listener 1. lsnrctl start
if you are having problem starting up the listener then verify that there are no typo in your tnsnames.ora file
if your listerner is up and running, then try to connect via sqlplus if it is not successfull, then check if the instance is up 1. tnsping <sid>
if it is not up, then startup the instance.
if the instance is up and the listener is up, then you should contact oracle support
Let us know how it turns out.
Best of Luck.
Tony Adolph wrote:
> Hello all,
>
> 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.
Received on Sat Aug 26 2000 - 21:43:02 CDT