Re: ORA-12541: TNS:no listener

From: Mark Townsend <markbtownsend_at_home.com>
Date: Sat, 22 Sep 2001 02:05:09 GMT
Message-ID: <B7D13FE4.14B31%markbtownsend@home.com>

in article ytOq7.1724$v6.248712_at_news.shore.net, Guang Mei at gmei_at_proteome.com wrote on 9/21/01 2:45 PM:

> Fatal NI connect error 12541, connecting to:
>
> (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=ns1.proteome)(CID=(PROGRAM=)
> (HO
> ST=rockport)(USER=oracle)))(ADDRESS=(PROTOCOL=TCP)(HOST=ns1)(PORT=1521)))
>
> VERSION INFORMATION:
> TNS for Solaris: Version 8.1.6.0.0 - Production
> TCP/IP NT Protocol Adapter for Solaris: Version 8.1.6.0.0 -
> Production
> Time: 21-SEP-2001 17:39:13
> Tracing not turned on.
> Tns error struct:
> nr err code: 0
> ns main err code: 12541
> TNS-12541: TNS:no listener
> ns secondary err code: 12560
> nt main err code: 511
> TNS-00511: No listener
> nt secondary err code: 146
> nt OS err code: 0
>
> ----------
> Any suggestions?

You are set up to connect back over TCP/IP. Start your listener - lsnrctl start

If it starts correctly - you should see a service name ns in the status list - and you still cannot connect, check the listener is listening on port 1521.
If it is, and you still have problems, try pinging ns1 - your host name looks strange - I would have expected ns1.proteome.com Received on Fri Sep 21 2001 - 21:05:09 CDT