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).
