Re: Start/Stop a Listener

This is a test haven't received any today. Just checking...

Anjan

Rajesh Dayal wrote:

> 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-----
> Carmichael
> Sent: Wednesday, October 18, 2000 3:51 AM
> To: Multiple recipients of list ORACLE-L
>
> 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
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rajesh Dayal
> INET: Rajesh_at_ohitelecom.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 Fri Oct 20 2000 - 11:14:54 CDT