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 IyerDBACCSS Team 684-3016
>>> theoracledba_at_lycos.com 05/29/01 01:15PM >>>lsnrctl
set log_file $ORACLE_HOME/network/log/listener1.logActually, 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_fileset|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-----><<A
href="mailto:ThaterW_at_telergy.net">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.netGet 250 color business cards for FREE!<A
href="http://businesscards.lycos.com/vp/fastpath/">http://businesscards.lycos.com/vp/fastpath/--
Please see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com-- Author: The
Oracle DBA INET: theoracledba_at_lycos.comFat 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_at_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).
Received on Tue May 29 2001 - 16:06:20 CDT
