Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Renaming / deleting listener.log and alert log

Renaming / deleting listener.log and alert log

From: Paul Vincent <Paul.Vincent_at_uce.ac.uk>
Date: Fri, 10 Jun 2005 08:35:05 +0100
Message-ID: <14C5F9616FF43F479F67E41A1DF4D94A76D47A@exchangeb.staff.uce.ac.uk>


OK folks - please help me out with this old chestnut:

When the listener log, and the database alert log, start to reach unwieldy sizes, it's time to either delete the log, or - better - rename it, so that Oracle will start a fresh one. But the question of whether this can be done "on the fly", whilst the listener or database (respectively) are still running, or whether you have to stop the listener or shutdown the database instance before doing so, seems to depend on which version of Oracle and which operating system are running.

So, by way of clarification, can anyone give a definitive answer to these questions:

Is it safe to delete or rename the listener log file whilst the listener is still running, for Oracle 8i under Windows 2000 Server? And how about deleting/renaming the database alert log file without shutting down the instance, under the same configuration (8i, Windows 2k)?

Same question for Oracle 9i under Win2k ?

Same question for Oracle 8i under Solaris?

Same question for Oracle 9i under Solaris?

If there's a clear consensus on these answers, this would be a handy FAQ answer!

Regards,

Paul

Paul Vincent
DBA
UCE Birmingham
paul.vincent_at_uce.ac.uk

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 10 2005 - 03:41:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US