Monday, September 26, 2011

Change oracle listener log file



Listener log files may grow very big in size and you may sometimes want to delete the existing log file to free up some space. When you try to delete the log file in windows, you will get file already in use message.

To solve this, you can change the listener log file using the below commands

lsnrctl

set log_file listener1.log

Where listener1.log is the new log file, now you can delete the old log file.

You can also turn off listener logging as below

lsnrctl

set log_status off

0 comments:

Post a Comment

 

ORA-BLOG. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com