Re: Missing alert log in 10g

From: Gerard H. Pille <>
Date: Thu, 10 Sep 2009 02:13:48 -0700 (PDT)
Message-ID: <>

On 10 sep, 10:07, Chloe C <> wrote:
> Hi
> A wierd problem. Our database is working quite happily under
> Windows, but I can't find the alert log. There is a log in the
> background_dump_dest location, but that hasn't been updated since
> mid-July (and there haven't been any trc files written either), and
> the $ORACLE_HOME/rdbms/trace is empty. The system has certainly been
> restarted since mid_July.
> I did a search of the entire drive for *alert* files updated in the
> previous week, but nothing.
> Any ideas as to where to look next?
> Chloe

Log in to your database with sqlplus and execute:

show parameter dump

Should tell you where to look, so you don't have to search. Just noticed in 11g that is uses a log.xml in an alert directory. Received on Thu Sep 10 2009 - 04:13:48 CDT

Original text of this message