Re: ORA-12541: TNS:no listener

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 22 Sep 2001 00:49:37 +0200
Message-ID: <tqo27lede42v7a@news.demon.nl>

"Guang Mei" <gmei_at_proteome.com> wrote in message news:ytOq7.1724$v6.248712_at_news.shore.net...
> Hi,
>
> I am puzzled by this error.
>
> I have installed oracle 816 (EE Edition) on a Sun box and created an
> instance called "NS1". And I started the listener. BTW, ORACLE_SID etc env
> are all set in .profile.
>
> I have no problem using svrmgrl connecting to NS1
> I have no problem using sqlplus from my dell desk top PC connecting to
NS1.
> I tried $ORACLE_HOME/bin/netasst and test the connection to NS1, no
problem.
>
> But when I use sqlplus on the Sun box.
>
> If I do
>
> sqlplus ns1_user/passw
>
> It connects to NS1 fine (ORACLE_SID etc env are all set in .profile)
>
> But if I try
>
> sqlplus ns1_user/passw_at_NS1
>
> then I got :
>
> SQL*Plus: Release 8.1.6.0.0 - Production on Fri Sep 21 17:14:57 2001
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-12541: TNS:no listener
>
> ---
>
> So I thought the problem is tnsname.ora file.
>
> here is the entry in that file:
> ----
> NS1=
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host=10.203.10.27)(Port= 1521))
> (CONNECT_DATA = (SID = NS1))
> )
>
> ----------
> Looking at sqlnet.log file gave me some clue, but not enough for me to
know
> where to change:
>
> 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?
>
> TIA.
>
> Guang
>
>

Look very close

> NS1=
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host=10.203.10.27)(Port= 1521))

------------------->>>>>     (CONNECT_DATA = (SID = NS1))

> )
>
> ----------
> Looking at sqlnet.log file gave me some clue, but not enough for me to
know
> where to change:
>
> 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)))
>

You're using sid in tnsnames.ora and service_name in listener.ora

They are incompatible, and should match. Either use sid on both sides (not recommended as that syntax is pre-8i and will disappear) or service_name is on both sides.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Fri Sep 21 2001 - 17:49:37 CDT