Re: Missing alert log in 10g

On 10 sep, 10:07, Chloe C wrote:
> Hi
>
> A wierd problem. Our 10.2.0.4 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.