RE: Start/Stop a Listener

From: Ruiz, Mary A (CAP, CDI) <Mary.Ruiz_at_gecapital.com>
Date: Wed, 18 Oct 2000 09:41:45 -0400
Message-Id: <10653.119639@fatcity.com>

I think I was confused because sometimes, I like to run lsnrctl and get a status on the listener. If you try renaming your listener.ora file,
and then do a status command in lsnrctl, Oracle gives you error message tns-01101: Could not find service name. That indicates to me that the lsnrctl command does look at the listener.ora file for some commands. So if you modify this file before stopping the listener, the status command may indicate a problem.

But before this discussion, I was unaware of the reload option. Thanks.

mar

-----Original Message-----
From: Rachel Carmichael
Sent: Tuesday, October 17, 2000 7:51 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Start/Stop a Listener

nope, you don't. The listener.ora file is read and loaded when the listener is started and then not read again until you either reload or stop and start

the listener. Just as with the init.ora file.

>From: "Ruiz, Mary A (CAP, CDI)" <Mary.Ruiz_at_gecapital.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Start/Stop a Listener
>Date: Tue, 17 Oct 2000 09:01:31 -0800
>
>Please someone correct me if I am wrong, I thought you need to stop the
>listener(s) before you modify the listener.ora file.
>
>Mary Ruiz / Atlanta GA
>
>
>-----Original Message-----
>Sent: Tuesday, October 17, 2000 11:36 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Guys and gals,
>
>We have a listener.ora file that has been updated to show an extra port for
>a connection. Now as I understand the listener has to be bounced for that
>change to take effect right?
>
>So.. if we need to bounce the listener, would that have any affects on a
>production database? if so is there any way to get around it?
>
>As always your help is greatly appreciated.
>
>Regards
>
>Mark
>
>Mark Leith
>=================
>Cool Tools UK Ltd
>+44 1905 330 281
>mark_at_cool-tools.co.uk <mailto:mark_at_cool-tools.co.uk>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ruiz, Mary A (CAP, CDI)
> INET: Mary.Ruiz_at_gecapital.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at http://profiles.msn.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: carmichr_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Wed Oct 18 2000 - 08:41:45 CDT