Re: NEWBIE: Error tnsnames.ora?

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Tue, 11 May 2004 20:36:48 -0400
Message-ID: <112167349856.20040511203648@gennick.com>

Tuesday, May 11, 2004, 5:10:26 PM, Carlos Jose Guerrieri (carlos.guerrieri_at_realize-it.com) wrote: CJG> but when i type the following
CJG> command: lsnrctls stop i get the follwing error message.

CJG> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ab-mac)(PORT=1521)))
CJG> TNS-12541: TNS:no listener
CJG>  TNS-12560: TNS:protocol adapter error
CJG>   TNS-00511: No listener
CJG>    MacOS X Server Error: 61: Connection refused

...

Is your listener running to begin with? If your listener is already stopped, then attempting to stop it again will give you a message such as the one above.

If you gave your listener a name other than the default of LISTENER, then you'll need to issue a command such as:

    lsnrctl stop NAME

To check on the name, look at the contents of $ORACLE_HOME/network/admin/listener.ora. If you see entries such "LISTENER =" and "SID_LIST_LISTENER =", then your listener is named LISTENER. If you see
SID_LIST_SOMETHING_ELSE, then your listener is named SOMETHING_ELSE. Best regards,

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com

Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://five.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request_at_gennick.com and include the word "subscribe" in either the subject or body.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue May 11 2004 - 19:34:28 CDT