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


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


set log_status off


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