From cspence@FuelSpot.com Tue, 29 May 2001 07:43:06 -0700 From: Christopher Spence Date: Tue, 29 May 2001 07:43:06 -0700 Subject: RE: Listener.log....writing to renamed file Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Listener.log....writing to renamed file 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-----From: Li, Xiangli [mailto:Xiangli.Li@aig.com]Sent: Thursday, May 24, 2001 2:58 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Listener.log....writing to renamed file May I know how to clear the content of listener.log without restart listener on NT platform ? thanks. Li -----Original Message----- From:   Brian MacLean [SMTP:bmaclean@vcommerce.com] Sent:   Thursday, May 24, 2001 1:42 PM To:     Multiple recipients of list ORACLE-L Subject:        RE: Listener.log....writing to renamed file Reload doesn't close/reopen the file.  Here is a couple solutions   How's about a fast cat/clear solution: #!/bin/kshcat listener.log >>listener.log.histex listener.log <1,\$dwqEOF Or if you wish to purge 90% of the file: #!/bin/kshwc -l listener.log | read v_lines junkv_keep=$(($((${v_lines} * 10)) / 100))v_purge=$((${v_lines} - ${v_keep}))ex listener.log <1,${v_purge}dwqEOF -----Original Message-----From: Thater, William [ <mailto:ThaterW@telergy.net>]Sent: Thursday, May 24, 2001 7:15 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Listener.log....writing to renamed file 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 DBATelergy, Inc.            thaterw@telergy.net~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~You gotta program like you don't need the money,You gotta compile like you'll never get hurt,You gotta run like there's nobody watching,It's gotta come from the heart if you want it to work.~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~No program done by an undergrad will work after she graduates. --Please see the official ORACLE-L FAQ: <http://www.orafaq.com>--Author: Thater, William  INET: ThaterW@telergy.net Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).