Re: Start/Stop a Listener

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Tue, 17 Oct 2000 16:15:29 GMT
Message-Id: <10652.119490@fatcity.com>

Mark,

1. 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 Received on Tue Oct 17 2000 - 11:15:29 CDT