Re: Missing alert log in 10g

Na Thu, 10 Sep 2009 09:07:16 +0100, Chloe C napisao:

> 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

SHOW PARAMETER BACKGROUND_DUMP_DEST



--
http://mgogala.freehostia.com

[giteshtrivedi]

Hi,

BDUMP,CDUMP,UDUMP are depreciated in Oracle 11g. New home of ADDR is deployed named $ADR_HOME and default path is $ORACLE_HOME/diag/$ORACLE_SID. You can find out your alert.log from this location with .xml extension.