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). |
- REP: writing to renamed Listener.log file The Oracle DBA
- Satish Iyer