1) lsnrctl stop
RENAME %ORACLE_HOME%\NETWORK\LOG\LISTENER.LOG OLD.LOG
lsnrctl start
2) see the sample in network\admin\sample.
use trace_level=user (IMHO).
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -----Original Message-----
> From: Prakriteswar Santikary [SMTP:[EMAIL PROTECTED]]
> Sent: Thu, February 07, 2002 5:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: stopiing write to listener.log
>
> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 07, 2002 6:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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:[EMAIL PROTECTED]]
> Envoy� : jeudi 7 f�vrier 2002 14:15
> � : Multiple recipients of list ORACLE-L
> Objet : 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
>
> ----- Original Message -----
> From: [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>
> To: Multiple recipients of list ORACLE-L
> <mailto:[EMAIL PROTECTED]>
> 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
> � : 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
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> This e-mail was scanned by the eSafe Mail Gateway
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?���_�����? 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).
