RE: SIMPLE QUESTION

Actually, like most everything else, it depends on platform and version. OpenVMS, for example, will not recreate the file. In this case, you must:

1. lsnrctl set log_file temp_name
2. rename $ORACLE_HOME/network/log/listener.log to something else.
3. lsnrctl set log_file listener (no ".log"!)

This should work for Oracle 8.x. Not sure about other versions.

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

Disclaimer: I'm an idiot, but the difference between me and other idiots is that I know I'm an idiot.

> -----Original Message-----
> From: Sherman, Paul R. [mailto:PSherman_at_elcom.com]
> Sent: Wednesday, May 01, 2002 12:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: SIMPLE QUESTION
>
>
> Hamid,
>
> Move it to alert_log.yymmdd if you need to save it, else
> remove it. The file
> will be auto-created by Oracle the next time it writes to it.
>
> Thank you,
>
> Paul Sherman
> DBA Elcom, Inc.
> voice - 781-501-4143 (direct #)
> fax - 781-278-8341 (secure)
> email - psherman_at_elcom.com
>
>
> -----Original Message-----
> Sent: Wednesday, May 01, 2002 1:18 PM
> To: Multiple recipients of list ORACLE-L
>
>
> HI AGAIN,
>
> JUST WANT TO CHECK WITH YOU GUYS, MY LISTENER.LOG IS GETTING
> BIG I TRY TO
> RENAME IT THEN CREATE A NEW LISTENER.LOG BUT STILL THE OLD
> ONE IS USING BY
> ORACLE.
> HOW CAN I TRUNCATE THE LISTENER.LOG OR CAN I JUST SIMPLY
> DELETE IT OR NOT?
> THANKS FOR HELP.
>
>
>
>
> Hamid Alavi

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).