RE: Listener.log....writing to renamed file

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Tue, 29 May 2001 07:43:06 -0700
Message-ID: <F001.00311DE1.20010529073528@fatcity.com>

You
should bounce the listener.
 
"Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence <FONT
face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS" size=2>Fuelspot

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Li, Xiangli   [mailto:Xiangli.Li_at_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. <FONT face=Arial
  color=#0000ff size=2>Li   

    -----Original Message----- <FONT
    face=Arial size=1>From:   Brian
    MacLean [SMTP:bmaclean_at_vcommerce.com] <FONT face=Arial     size=1>Sent:   Thursday, May
    24, 2001 1:42 PM <FONT face=Arial

    size=1>To:     <FONT face=Arial 
    size=1>Multiple recipients of list ORACLE-L <FONT face=Arial 
    size=1>Subject:        <FONT 
    face=Arial size=1>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/ksh<FONT
    face=Arial>cat listener.log
>>listener.log.hist<FONT face=Arial

    size=2>ex listener.log <<EOF<FONT 
    face=Arial size=2>1,\$d<FONT face=Arial 
    size=2>wq<FONT face=Arial 
    size=2>EOF 

    Or if you wish to purge 90% of the
    file:
    #!/bin/ksh<FONT
    face=Arial>wc -l listener.log | read     v_lines junk<FONT face=Arial
    size=2>v_keep=$(($((${v_lines} * 10)) / 100))<FONT     face=Arial>v_purge=$((${v_lines} -
    ${v_keep}))ex
    listener.log <<EOF<FONT face=Arial

    size=2>1,${v_purge}d<FONT face=Arial 
    size=2>wq<FONT face=Arial 
    size=2>EOF 

    -----Original Message-----<FONT
    face=Arial>From: Thater, William [
    <<A

    href="mailto:ThaterW_at_telergy.net">mailto:ThaterW_at_telergy.net><FONT 
    face=Arial size=2>]<FONT face=Arial 
    size=2>Sent: Thursday, May 24, 2001 7:15 AM<FONT 
    face=Arial>To: Multiple recipients of 

    list ORACLE-L<FONT face=Arial
    size=2>Subject: Re: Listener.log....writing to renamed file<FONT     face=Arial>
    On Thu, 24 May 2001,Tirumala, Surendra scribbled     on the wall in glitter crayon:
    ->Hi List,<FONT
    face=Arial>->As a regular maintainance     work,I have moved the listener.log file to<FONT

    face=Arial><FONT face=Arial 
    size=2>->listener.log.old<FONT 
    face=Arial size=2>->and 'touch'ed the listener.log, expecting the logging 

    into this new file.<FONT face=Arial     size=2>->But I am observing the logging being done to listener.log.old,     instead.->I
    could not recall any such previous experience.<FONT     face=Arial>->FYI, I cannot do any
    'experiments' as far as this system is concerned as I<FONT     face=Arial>->have to deal
    with<FONT face=Arial
    size=2>->desupported HP-UX(10.01), Oracle (7.2.2.3).<FONT     face=Arial>->I have my logging being     done to default path($ORACLE_HOME/network/log), as<FONT     face=Arial>->no parameter settings in     listener.ora.<FONT face=Arial

    size=2>->Has anybody experienced this?<FONT 
    face=Arial>-><FONT 
    face=Arial>->TIA,<FONT 
    face=Arial>-><FONT 
    face=Arial>->Suren<FONT 
    face=Arial>->Oracle DBA<FONT 
    face=Arial>->Sony Electronics 

    Ltd.<FONT face=Arial
    size=2>-><FONT face=Arial
    size=2>->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.
    --<FONT
    face=Arial size=2>Bill
    Thater            
    Certifiable ORACLE DBA<FONT face=Arial     size=2>Telergy,
    Inc.           
    thaterw_at_telergy.net<FONT face=Arial

    size=2>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<FONT 

    face=Arial>You gotta program like you     don't need the money,<FONT face=Arial     size=2>You gotta compile like you'll never get hurt,<FONT     face=Arial>You gotta run like there's     nobody watching,<FONT face=Arial

    size=2>It's gotta come from the heart if you want it to work.<FONT 
    face=Arial><FONT face=Arial 
    size=2>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<FONT 
    face=Arial>No program done by an 

    undergrad will work after she graduates.     --Please see
    the official ORACLE-L FAQ: <FONT face=Arial color=#0000ff

    size=2><<A target=_blank 
    href="http://www.orafaq.com">http://www.orafaq.com><FONT 
    face=Arial>--<FONT face=Arial 
    size=2>Author: Thater, William<FONT 
    face=Arial size=2>  INET: ThaterW_at_telergy.net 
    

    Fat City Network Services    --
    (858) 538-5051  FAX: (858) 538-5051<FONT     face=Arial>San Diego,
    California        -- Public Internet     access / Mailing Lists<FONT face=Arial

    size=2>--------------------------------------------------------------------<FONT 

    face=Arial>To REMOVE yourself from this     mailing list, send an E-Mail message<FONT     face=Arial size=2>to: ListGuru_at_fatcity.com (note EXACT spelling of     'ListGuru') and in<FONT face=Arial
    size=2>the message BODY, include a line containing: UNSUB     ORACLE-L(or the
    name of mailing list you want to be removed from).  You may<FONT     face=Arial>also send the HELP command for     other information (like subscribing). Received on Tue May 29 2001 - 09:43:06 CDT