Re: how to disable logging of listener?

From: Roman <Roman.Schoenbeck_at_hmi.ch>
Date: Tue, 5 Jan 1999 08:58:28 +0100
Message-ID: <76sgmu$jeh$1@news.eunet.ch>

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 - 01:58:28 CST