Nice one, although the pipe still sounds interesting. Peter -----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 14:56 À : Multiple recipients of list ORACLE-L Objet : 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" <[EMAIL PROTECTED]> 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 ----- Original Message ----- From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, February 07, 2002 5:28 PM Subject: RE: stopiing write to listener.log 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:[EMAIL PROTECTED]] 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 [EMAIL PROTECTED] href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A> </DIV> <DIV style="FONT: 10pt arial"><B>To:</B> <A [EMAIL PROTECTED] href="mailto:[EMAIL PROTECTED]">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><SPAN class=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:[EMAIL PROTECTED]]<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> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <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 file listener.log??</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></BLOCKQUOTE></BODY></HTML> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).