Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> REP: writing to renamed Listener.log file

REP: writing to renamed Listener.log file

From: The Oracle DBA <theoracledba_at_lycos.com>
Date: Tue, 29 May 2001 12:28:23 -0700
Message-ID: <F001.00312770.20010529121528@fatcity.com>

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:ThaterW_at_telergy.net> >]
>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. thaterw_at_telergy.net

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: theoracledba_at_lycos.com

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: ListGuru_at_fatcity.com (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).
Received on Tue May 29 2001 - 14:28:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US