can i safely delete listener.log ?? will it recreate back?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: can i safely delete listener.log ?? will it recreate back?

Hybrid View

  1. #1
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456

    can i safely delete listener.log ?? will it recreate back?

    hi,
    As I am unable to find further info on the above topic..was wondering if i could seek some advice here?

    If i delete the listener.log will it recreate back? reason for deleting it's because it's accumulating in size

    thank-u in advance

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Sure, you can. In case of Windows OS, stop linstener first.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  3. #3
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    yup ok. But Can't I just delete that file so that it'll recreate itself again like Alert.log ??

  4. #4
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    The os will not allow it to be deleted as it will be in use when the listener is up, so just

    1. stop listener
    2. delete/rename file
    3. start listener

    HTH.

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by ggnanaraj
    The os will not allow it to be deleted as it will be in use when the listener is up, so just

    1. stop listener
    2. delete/rename file
    3. start listener

    HTH.
    That is the best way to do it because even if you delete the LISTENER.LOG, the file will be recreated only after stopping and starting the listener.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by julian
    That is the best way to do it because even if you delete the LISTENER.LOG, the file will be recreated only after stopping and starting the listener.
    The best way (IMHO) to do it is to leave the listener up and
    1. stop logging (lsnrctl set log_status off)
    2. del/mv file
    3. start logging (lsnrctl set log_status on)
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by marist89
    The best way (IMHO) to do it is to leave the listener up and
    1. stop logging (lsnrctl set log_status off)
    2. del/mv file
    3. start logging (lsnrctl set log_status on)
    Bestest indeed
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width