RE: Start/Stop a Listener

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Wed, 18 Oct 2000 08:23:37 +0400
Message-Id: <10652.119587@fatcity.com>

Another part of Qn

>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?

        Normally it doesn't have any impact, except the fact that the users trying to establish a connection to your prodn database (after stopping listener) will have to wait till the listener is restarted.

HTH,
Rajesh
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rachel Carmichael
Sent: Wednesday, October 18, 2000 3:51 AM 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 Tue Oct 17 2000 - 23:23:37 CDT