Site search

Categories

Archives

Tags





The GNU/Linux Advanced Administration

Free Linux Manuals !


A Newbie's Getting Started Guide to Linux

-- FREE --
IT Magazine
Subscriptions

Oracle Magazine Oracle Magazine Contains technology strategy articles, sample code, tips, Oracle and partner news, how-to articles for developers and DBAs

WebSite Magazine WebSite Magazine Practical advice, helpful tools and insights for website owners

Dr Dobb's Journal Dr Dobb's Journal enables coders to write the most efficient programs and help in daily programming quandaries

DM Review DM Review is recognized as the premier business intelligence, analytics and data warehousing publication
Various other Free IT magazine subscriptions
NoAdware Free Trial

NoAdware Remove
harmful
adware,
spyware,
trojans,
dialers
and worms!
- Featured ebook -

Database Normalization
by Alf Pedersen

Database Normalization ebook Understand and master how to normalize a database using methods richly documented with graphical ERD and server diagram examples

RSS
XML RSS
What is this?
AddThis Feed Button

Social
Bookmarking


Get rid of large listener.log file while the listener is still running.

Your listener.log file can get quite large if you do not make it part of your housekeeping scripts, and renaming it while the listener is running is not a good idea.

Here is the method to follow to clean it up while your listener is still running.

Log into your listener from the command prompt (make sure your Oracle environment is set to that of where the listener is started from, the commands below assume there is only one (default)  listener running ) :

$lsnrctl

..

LSNRCTL>  set log_status off
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
LISTENER parameter “log_status” set to OFF
The command completed successfully

(Now go delete/rename $ORACLE_HOME/network/log/listener.log to something else in another OS session )
LSNRCTL> set log_status on
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
LISTENER parameter “log_status” set to ON
The command completed successfully
LSNRCTL> quit