create bAtch file to delete old listener log on windows

[hafeezkalsekar]

hi all,
plz comment
i am planing to make a batch file to delete old listener log file and old log file will be automatically zipped in same location.

[gopu_g]

What you are expecting

[mdvreddy]

listener logs does not occupy more disk space and other logs(??? Alert??). write a batch file and zip those and move another location and delete. however keep on eye on log files all the time as it is the place where you look for DB issues if any.

[hafeezkalsekar]

Hi Expert People ,

I Just Wanna Batch File Which Will Replace Old Listener Log With New , So I Can Schdule It And Hence Personal Interference Is Not Required.

[ebrian]

You can use forfiles to delete/move older files on Windows. However, you'll have to either shutdown the listener or find a utility that will allow you to delete/move an open file.

Forgot to mention, you do have an option to avoid shutting down the listener. You could run the following command to rename the listener.log file while the listener is running:

C:\> lsnrctl
LSNRCTL> SET LOG_FILE c:\oracle\network\log\new_listener.log

[hafeezkalsekar]

hi ebrain ,

i am aware of below step. but i want to create a batch file to automate the below task..
any idea. how