Re: TNS: No Listener

Go to your listener console and type 'status' - makre sure you have an instance running for the SID you are trying to connect to. If not, try a 'reload' and check again. If you do not see a handler, you need to edit your listener.ora to handle the SID (check your docs). If it is there, check your stack:

1. Ping the machine - if this fails here you have a non-oracle network issue
2. tnsping80 the SID - if this fails check your listener and tns config also make sure you are connecting using the right port and IP if you have multiple HW adapters
3. try to connect via sqlplus - if it fails at this point it is usually something very easy (misspelled SID, etc.).

Let me know if you get any specific messages.

-Lou

victorhugo_at_lycos.com (Victor Hugo Bogiano) wrote in message news:<dff885a9.0202080552.3e02f65a_at_posting.google.com>...
> Hi,
>
> I'm using O.S. Windows 98 and Oracle 8.0.5.0.0.
>
> This error happens on connection:
>
> - Oracle SQL Plus 8.0:
> TNS: no listener
>
> I tried to compare the TNSNAMES.ORA entry with the appropriate
> LISTENER.ORA, but didn't work. I have all services configured and in
> some machines it works. I tried also to reinstall oracle and it didn't
> work. Only reinstalling the Windows it works, but later happens the
> same problem. I think there're problems with some windows DLLs, but I
> don't know which is.
>
> Any clue is welcome!
>
> Thanks,
>
> Victor.
Received on Fri Feb 08 2002 - 18:56:19 CST