Re: Missing alert log in 10g
From: Gerard H. Pille <ghpille_at_hotmail.com>
Date: Thu, 10 Sep 2009 02:13:48 -0700 (PDT)
Message-ID: <2f053098-99b3-4de7-9388-225467c1288b_at_t2g2000yqn.googlegroups.com>
On 10 sep, 10:07, Chloe C <ch..._at_mcrowdd.plus.com> 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
Date: Thu, 10 Sep 2009 02:13:48 -0700 (PDT)
Message-ID: <2f053098-99b3-4de7-9388-225467c1288b_at_t2g2000yqn.googlegroups.com>
On 10 sep, 10:07, Chloe C <ch..._at_mcrowdd.plus.com> 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. Received on Thu Sep 10 2009 - 04:13:48 CDT