Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: stopiing write to listener.log

RE: Re[2]: stopiing write to listener.log

From: <peter.lomax_at_ftms.fr>
Date: Thu, 07 Feb 2002 07:04:22 -0800
Message-ID: <F001.00408C2D.20020207064403@fatcity.com> 






Nice one,


although the pipe still sounds interesting.
Peter



-----Message d'origine-----


De : dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
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" <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>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>I have thousands of connection in my&nbsp; 


db&nbsp;and&nbsp; listener.log is growing very fastly. I&nbsp; want&nbsp; to



flush it manaually&nbsp; 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>&nbsp;</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>&nbsp;</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&nbsp;:</B> Shibu 
  [mailto:basher.shibu_at_acusis.com]<BR><B>Envoyé&nbsp;:</B> jeudi 7 février
2002 


  11:38<BR><B>A&nbsp;:</B> Multiple recipients of list 
  ORACLE-L<BR><B>Objet&nbsp;:</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>&nbsp;</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>&nbsp;</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: 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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: peter.lomax_at_ftms.fr

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 - 09:04:22 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US