Message-Id: <10652.119528@fatcity.com> From: "Jai B. Sanker" Date: Tue, 17 Oct 2000 10:43:10 -0700 Subject: RE: Start/Stop a Listener This is a multi-part message in MIME format. ------=_NextPart_000_000C_01C03826.960449B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit stop/start the listener does not terminate existing connections. it will only affect process that request new connection(s) with the database during the bounce. otoh, you can use 'lsnrctl reload' for the changes to take effect without a stop/start of listener. -----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Mark Leith Sent: Tuesday, October 17, 2000 8:36 AM To: Multiple recipients of list ORACLE-L Subject: Start/Stop a Listener 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@cool-tools.co.uk ------=_NextPart_000_000C_01C03826.960449B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
stop/start the listener does not = terminate=20 existing connections. it will only affect process that request new = connection(s)=20 with the database during the bounce.
 
otoh,  you can use 'lsnrctl reload' for = the=20 changes to take effect without a stop/start of = listener.
-----Original Message-----
From: root@fatcity.com=20 [mailto:root@fatcity.com]On Behalf Of Mark = Leith
Sent:=20 Tuesday, October 17, 2000 8:36 AM
To: Multiple recipients of = list=20 ORACLE-L
Subject: Start/Stop a Listener

Guys = and=20 gals,
 
We = have a=20 listener.ora file that has been updated to show an extra port for=20 a connection. Now as I understand the listener has to be bounced = for that=20 change to take effect right?
 
So.. = if we need to=20 bounce the listener, would that have any affects on a production=20 database? if so is there any way to get around it?
 
As = always your=20 help is greatly appreciated.
 
Regards
 
Mark
 
Mark Leith
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=
Cool Tools UK=20 Ltd
+44 1905 330 = 281
mark@cool-tools.co.uk