RE: stopiing write to listener.log

From: <peter.lomax_at_ftms.fr>
Date: Thu, 07 Feb 2002 06:59:31 -0800
Message-ID: <F001.00408BEA.20020207064400@fatcity.com>

<FONT face=Arial color=#0000ff
size=2>Shibu,
OK so
I now understand a little better your need. Of
course there is listener OFF (logging_listener=off) As I
said this really does defeat the point.
<FONT face=Arial color=#0000ff
size=2> 
Their
are two approaches that spring to mind.
Log
Rotation or writing to a pipe.
Log
Rotation:
Every
x hours stop the listener, rename the file, start the listener
You
can then do stats on normal connections and save just the error and startups et al ...
<FONT face=Arial color=#0000ff
size=2>Writing to a pipe:
Would
mean that you create a pipe alert_SID.ora and have a process that would read from the pipe everything but normal connections. The
disadvantages are 
- that
you may not be able to do this on your NT box. - you
lose all your stats of cnxs
<FONT face=Arial color=#0000ff
size=2>Peter
<FONT face=Arial color=#0000ff
size=2> 
-----Message
d'origine-----De : Shibu
[mailto:basher.shibu_at_acusis.com]Envoyé : jeudi 7 février 2002 14:15À : Multiple recipients of list
ORACLE-LObjet : Re: stopiing write to
listener.log

  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
  <BLOCKQUOTE dir=ltr
  style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message -----
  <DIV
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
  <A title=peter.lomax_at_ftms.fr
  href="mailto:peter.lomax_at_ftms.fr">peter.lomax_at_ftms.fr To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L

    Sent: Thursday, February 07, 2002 5:28     PM
    Subject: RE: stopiing write to
    listener.log     

<FONT face=Arial color=#0000ff

    size=2>Shibu,
<FONT face=Arial color=#0000ff

    size=2>What do you really want?
<SPAN

    class=843013411-07022002>Log messages written to     /u01/app/oracle/product/8.1.7/network/log/listener.log
<SPAN

    class=843013411-07022002>You could redivert this to /dev/null however this     defeats the point.
<SPAN

    class=843013411-07022002>You can rename it every day and archive off after     14 days.
<SPAN

    class=843013411-07022002> 
<SPAN

    class=843013411-07022002>User Failing to connect     like
<SPAN

    class=843013411-07022002>Microsoft Transaction     Server
<SPAN

    class=843013411-07022002>Look on the     metalink
<SPAN

    class=843013411-07022002>"Establish a grant to     DBA_PENDING_TRANSACTIONS"
<SPAN

    class=843013411-07022002>HTH
<SPAN

    class=843013411-07022002>Peter
<FONT face=Tahoma

    size=2>-----Message d'origine-----De : Shibu     [mailto:basher.shibu_at_acusis.com]Envoyé : jeudi 7 février     2002 11:38À : Multiple recipients of list     ORACLE-LObjet : stopiing write to
    listener.log     

      Hi
       
      How Can i stop Oracle from writing to the 
      file listener.log??
       
      regards,
      <FONT face=Arial 

size=2>shibu Received on Thu Feb 07 2002 - 08:59:31 CST