Recycling the listener..

From: nirav <shivam71_at_gmail.com>
Date: 8 Aug 2005 00:13:02 -0700
Message-ID: <1123485182.453361.275260@g14g2000cwa.googlegroups.com>

Hi Experts,

I have oracle 9.2.0.6 on Solaris 8. My listener log file has grown to 15 mb. I needto recycle the listener but not sure of its steps:

Are they as follows:
1) Stop the listener.
2) rename the listener log file to the name of the backup file (thus the file is renamed)
3) Start the listener.

Is this correct?- I mean after restarting does the server CREATE the log file and start writing to it?

Also I read about the other alternative which does not require stopping the listener:

it is :

% lsnrctl set log_status off
% mv listener.log listener.old
% lsnrctl set log_status on

Are both techniques correct? We have j2ee based project talking to oracle database with app. server etc involved. Is it possible to get some connection error if I do it online? Should I have first the app. servers stopped before I do this?

Pl. advice..
Nirav Received on Mon Aug 08 2005 - 02:13:02 CDT