Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: stopiing write to listener.log
Shibu,
To get the listener to stop logging immediately without having to bounce it:
>lsnrctl
set log_status = off
exit
Now to get that to stay forever set "logging_listener = off" in the listener.ora.
Now delete the log file & your done. For normal day to day operations the log file is absolutely useless. Actually I think the default log_status should be off.
Dick Goulet
____________________Reply Separator____________________ Author: "Shibu" <basher.shibu_at_acusis.com> Date: 2/7/2002 5:14 AM
Hi peter
I have thousands of connection in my db and listener.log is growing very fastly. I want to flush it manaually every time I want to either stop it or flush it automatically .My db is 8.1.7 on win2k Do u h ave any solution for this ?
regards,
shibu
Shibu,
What do you really want?
Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log
You could redivert this to /dev/null however this defeats the point.
You can rename it every day and archive off after 14 days.
User Failing to connect like
Microsoft Transaction Server
Look on the metalink
"Establish a grant to DBA_PENDING_TRANSACTIONS"
HTH
Peter
-----Message d'origine-----
De : Shibu [mailto:basher.shibu_at_acusis.com]
Envoyé : jeudi 7 février 2002 11:38
A : Multiple recipients of list ORACLE-L
Objet : stopiing write to listener.log
Hi
How Can i stop Oracle from writing to the file listener.log??
regards,
shibu
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi peter </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have thousands of connection in my
db and listener.log is growing very fastly. I want to
flush it manaually every time</FONT></DIV>
<DIV><FONT face=Arial size=2>I want to either stop it or flush it automatically
.My db is 8.1.7 on win2k</FONT></DIV>
<DIV><FONT face=Arial size=2>Do u h ave any solution for this ?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>regards,</FONT></DIV>
<DIV><FONT face=Arial size=2>shibu</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT:
#000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=peter.lomax_at_ftms.fr
href="mailto:peter.lomax_at_ftms.fr">peter.lomax_at_ftms.fr</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=ORACLE-L_at_fatcity.com
href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, February 07, 2002 5:28
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: stopiing write to
listener.log</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=843013411-07022002><FONT face=Arial color=#0000ff
size=2>Shibu,</FONT></SPAN></DIV>
<DIV><SPAN class=843013411-07022002><FONT face=Arial color=#0000ff size=2>What
do you really want?</FONT></SPAN></DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=843013411-07022002>Log messages written to
/u01/app/oracle/product/8.1.7/network/log/listener.log</SPAN></FONT></FONT></F
ONT></DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=843013411-07022002>You could redivert this to /dev/null however this
defeats the point.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=843013411-07022002>You can rename it every day and archive off after 14
days.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=843013411-07022002></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=843013411-07022002>User Failing to connect
like</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=843013411-07022002>Microsoft Transaction
Server</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=843013411-07022002>Look on the
metalink</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=843013411-07022002>"Establish a grant to
DBA_PENDING_TRANSACTIONS"</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN class=843013411-07022002>HTH</SPAN></FONT></FONT></FONT></DIV> <DIV><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPANclass=843013411-07022002>Peter</SPAN></FONT></FONT></FONT></DIV> <DIV><SPAN class=843013411-07022002></SPAN><FONT face=Tahoma size=2>-----Message d'origine-----<BR><B>De :</B> Shibu [mailto:basher.shibu_at_acusis.com]<BR><B>Envoyé :</B> jeudi 7 février 2002 11:38<BR><B>A :</B> Multiple recipients of list ORACLE-L<BR><B>Objet :</B> stopiing write to listener.log<BR><BR></DIV></FONT>
<DIV><FONT face=Arial size=2>Hi</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>How Can i stop Oracle from writing to the filelistener.log??</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>regards,</FONT></DIV> <DIV><FONT face=Arial
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet_at_vicr.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).Received on Thu Feb 07 2002 - 07:58:27 CST
![]() |
![]() |