I'd like to add a comments to this, you should do a "reload" instead of
stopping and restarting if you are running MTS, otherwise you will run into
problems with your dispatcher's information being dropped from the listener.
Tom Tyson
- Rachel Carmichael <carmichr_at_hotmail.com> wrote:
> Mark,
>
> a) you can do:
>
> lsnrctl <listenername> reload
>
> which will reload the listener.ora file without shutting down the listener.
>
> b) if you shutdown the listener it does NOT affect existing connections but
> no one can make a new connection until you restart the listener
>
> Rachel
>
>
> >From: "Mark Leith" <mark_at_cool-tools.co.uk>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Start/Stop a Listener
> >Date: Tue, 17 Oct 2000 07:35:32 -0800
> >
> >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
> >
>
> _________________________________________________________________________
> 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).
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
Received on Tue Oct 17 2000 - 15:14:22 CDT
