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_at_fatcity.com [mailto:root_at_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_at_cool-tools.co.uk
------=_NextPart_000_000C_01C03826.960449B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3D"Century Gothic" size=3D2><SPAN=20
class=3D578363417-17102000>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.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3D"Century Gothic" size=3D2><SPAN=20
class=3D578363417-17102000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3D"Century Gothic" size=3D2><SPAN=20
class=3D578363417-17102000>otoh, you can use 'lsnrctl reload' for =
the=20
changes to take effect without a stop/start of =
listener.</SPAN></FONT></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20
[mailto:root_at_fatcity.com]<B>On Behalf Of </B>Mark =
Leith<BR><B>Sent:</B>=20
Tuesday, October 17, 2000 8:36 AM<BR><B>To:</B> Multiple recipients of =
list=20
ORACLE-L<BR><B>Subject:</B> Start/Stop a Listener<BR><BR></DIV></FONT>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D436312514-17102000>Guys =
and=20
gals,</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D436312514-17102000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D436312514-17102000>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? </SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D436312514-17102000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D436312514-17102000>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?</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D436312514-17102000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D436312514-17102000>As =
always your=20
help is greatly appreciated.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D436312514-17102000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D436312514-17102000>Regards</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D436312514-17102000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D436312514-17102000>Mark</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D436312514-17102000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0080ff size=3D2><EM>Mark Leith</EM></FONT></DIV>
<DIV><FONT color=3D#ff0000 face=3DArial =
size=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT></DIV>=
<DIV><FONT color=3D#0080ff size=3D2><STRONG>Cool Tools UK=20
Ltd</STRONG></FONT></DIV>
<DIV><FONT color=3D#0080ff face=3DArial size=3D2>+44 1905 330 =
281</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><A=20
=
href=3D"mailto:mark_at_cool-tools.co.uk">mark_at_cool-tools.co.uk</A></FONT></D=
Received on Tue Oct 17 2000 - 12:43:10 CDT
