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

From: Robertson Lee - lerobe <lerobe_at_acxiom.co.uk>
Date: Thu, 07 Feb 2002 06:20:05 -0800
Message-ID: <F001.00408AF6.20020207061328@fatcity.com>

erm..... to Shibu.

I forgot the smiley. It was only a joke !!!

-----Original Message-----
Sent: 07 February 2002 13:56
To: Multiple recipients of list ORACLE-L

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

Original Message ----- From: peter.lomax_at_ftms.fr 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: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

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;d

b 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>&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> </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: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>
  <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).


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robertson Lee - lerobe
  INET: lerobe_at_acxiom.co.uk

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 - 08:20:05 CST