Re: how to disable logging of listener?

Hi,

I know there's a setting to switch logging completely off, but I don't remember. I saw it here somewhere in a newsgroup, it's like TRACE_LEVEL_LISTENER = NONE or NULL or something like that.

Thomas.

Roman wrote:

> CT Canberra wrote in message <01be382b$f58a66f0$35140c0a_at_eagle>...
>
> >In your $ORACLE_HOME/network/admin/listener.ora file, try setting
> >TRACE_LEVEL_LISTENER to OFF.
> >Here's the appropriate line from my listener.ora:
> >TRACE_LEVEL_LISTENER = OFF
> >
> >Then stop and start the listener.
>
> This reduces only messages in the listener.trc file!
> This doesn't help much to our problem, because it does NOT reduce the amont
> of messages like
>
> 04-JAN-99 15:09:41 *
> (CONNECT_DATA=(SID=SERV)(CID=(PROGRAM=deps.exe)(HOST=HERCULES)(USER=SYSTEM))
> ) * (ADDRESS=(PROTOCOL=tcp)(HOST=115.59.48.130)(PORT=3645)) * establish *
> SERV * 0
>
> in the listener.log file. Since we have lot of background jobs reconnecting
> to the database all the time, this file grows rather quickly!
>
> Is there no switch in Oracle for this? Is there no other way than to sweep
> this log file with a cron job?
>
> Thanks,
> Roman
Received on Tue Jan 05 1999 - 02:01:15 CST