Re: REP: writing to renamed Listener.log file

[Satish Iyer]

Well, bouncing the listener is not needed. We do the same at our place here    lsnrctl set log_file $ORACLE_HOME/network/log/listener1.log         mv      $ORACLE_HOME/network/log/listener.log \                 $ORACLE_HOME/network/log/listener.log.$QUALIFIER         lsnrctl set log_file $ORACLE_HOME/network/log/listener.log   where $QUALIFIER is the date stamp.   Satish Iyer DBA CCSS Team 684-3016   >>> [EMAIL PROTECTED] 05/29/01 01:15PM >>>lsnrctl set log_file $ORACLE_HOME/network/log/listener1.log Actually, I just talked to Worldwide Support about this issue. They recommend using the set log_file command to rename the file to another file name ("templisten.log" for example)- for the life of the listener session. After that, you can reset/delete/purge the listener.log file safely. Then bounce the listener and it will begin writing to listener.log file again. LSNRCTL> help set log_file set|show log_{ } [<value>]: set|show log parameters of current listener On Tue, 29 May 2001 07:35:27  Christopher Spence wrote: >You should bounce the listener. > > >"Walking on water and developing software from a specification are easy if >both are frozen." > >Christopher R. Spence >Oracle DBA >Fuelspot > >-----Original Message----- >Sent: Thursday, May 24, 2001 2:58 PM >To: Multiple recipients of list ORACLE-L > > > >May I know how to clear the content of listener.log without restart listener >on NT platform ? > >thanks. >Li > >    -----Original Message----- >Sent:   Thursday, May 24, 2001 1:42 PM >To:     Multiple recipients of list ORACLE-L > >    Reload doesn't close/reopen the file.  Here is a couple solutions   > >    How's about a fast cat/clear solution: > >    #!/bin/ksh >cat listener.log >>listener.log.hist >ex listener.log <<EOF >1,\$d >wq >EOF > >    Or if you wish to purge 90% of the file: > >    #!/bin/ksh >wc -l listener.log | read v_lines junk >v_keep=$(($((${v_lines} * 10)) / 100)) >v_purge=$((${v_lines} - ${v_keep})) >ex listener.log <<EOF >1,${v_purge}d >wq >EOF > > >    -----Original Message----- ><mailto:[EMAIL PROTECTED]> >] >Sent: Thursday, May 24, 2001 7:15 AM >To: Multiple recipients of list ORACLE-L > > >    On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in >glitter crayon: > >    ->Hi List, >->As a regular maintainance work,I have moved the listener.log file to >->listener.log.old >->and 'touch'ed the listener.log, expecting the logging into this new file. >->But I am observing the logging being done to listener.log.old, instead. >->I could not recall any such previous experience. >->FYI, I cannot do any 'experiments' as far as this system is concerned as I >->have to deal with >->desupported HP-UX(10.01), Oracle (7.2.2.3). >->I have my logging being done to default path($ORACLE_HOME/network/log), as >->no parameter settings in listener.ora. >->Has anybody experienced this? >-> >->TIA, >-> >->Suren >->Oracle DBA >->Sony Electronics Ltd. >-> >-> >The file handle listener is using is still pointed at the old file.  To fix >this you need to stop and start the listener.  This will not affect anybody >who is already connected.  I'm not sure if a reload will do the same thing. > >    -- >Bill Thater             Certifiable ORACLE DBA >Telergy, Inc.            [EMAIL PROTECTED] Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA   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).