RE: stopiing write to listener.log

From: Prakriteswar Santikary <prakriteswar.santikary_at_pointinfo.com>
Date: Thu, 07 Feb 2002 07:45:14 -0800
Message-ID: <F001.00408D30.20020207070832@fatcity.com>

Peter,

How do
you set the 'Log Rotation' ? From command line utility 'lsnrctl' or is there any parameter for listener.ora ? Another thing: How do I track the exact SQLs being sent to the Oracle server ? I remember somebody on this list gave some hints in this direction. I just don't remember now the parameter name that I have to set in the listener.ora (some levl=16 or something like that ?) 
thanks
Santi

-----Original Message-----From: peter.lomax_at_ftms.fr [mailto:peter.lomax_at_ftms.fr]Sent: Thursday, February 07, 2002 6:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: stopiing write to listener.log
 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. 
 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 ...
 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
 Peter
 
 -----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 - 09:45:14 CST