Oracle11g: Where’s My Alert Log?

Just a short blog entry about Oracle 11g. One of the first things that caught me by surprise with 11g, when I first started in the beta program, was that the default location for the alert log has moved. It is still placed under the traditional OFA structure, but not /u01/app/oracle/admin. There is a new directory called diag that resides in /u01/app/oracle as seen on one of my systems:


 $ pwd
 /u01/app/oracle/diag/rdbms/bench/bench1
 $ ls -l
 total 144
 drwxr-xr-x 2 oracle dba 4096 Jul 9 21:32 alert
 drwxr-xr-x 3 oracle dba 4096 Jul 8 11:11 cdump
 drwxr-xr-x 2 oracle dba 4096 Jul 9 04:02 hm
 drwxr-xr-x 9 oracle dba 4096 Jul 8 11:11 incident
 drwxr-xr-x 2 oracle dba 4096 Jul 9 04:02 incpkg
 drwxr-xr-x 2 oracle dba 4096 Jun 29 22:00 ir
 drwxr-xr-x 2 oracle dba 4096 Jul 10 08:59 lck
 drwxr-xr-x 2 oracle dba 4096 Jul 10 08:59 metadata
 drwxr-xr-x 2 oracle dba 4096 Jul 8 11:11 stage
 drwxr-xr-x 2 oracle dba 4096 Jul 8 11:11 sweep
 drwxr-xr-x 3 oracle dba 57344 Jul 10 09:02 trace
 $ cd trace
 $ pwd
 /u01/app/oracle/diag/rdbms/bench/bench1/trace
 $ ls -l alert*
 -rw-r----- 1 oracle dba 1098745 Jul 10 09:00 alert_bench1.log

In this case, my database is called bench and the first instance is bench1. To quickly locate alert logs associated with many different ORACLE_HOMEs simple execute the adrci command and then execute “show alert”

8 Responses to “Oracle11g: Where’s My Alert Log?”


  1. 1 Alex Fatkulin July 13, 2007 at 1:12 am

    I see they call this a new feature… Automatic Diagnostic Repository

  2. 2 Don Seiler July 15, 2007 at 12:54 am

    Then what’s in the “alert” directory?

  3. 3 Pavel Ruzicka July 16, 2007 at 8:01 pm

    You can find all the details in “Note:438148.1 – Finding alert.log file in 11g”. Detailed explanation. Interesting to see this note published before the actual 11g release date.

  4. 4 Syed Jaffar Hussain August 18, 2007 at 1:38 pm

    Kevin,

    Somtime back, I have blogged about the same at my blog.

    http://jaffardba.blogspot.com/search/label/11g

    Jaffar

  5. 5 oraclebrains December 18, 2007 at 5:30 pm

    Few days back I had problem in finding trace file.

    After some research I now think best way to find the path is to query the v$diag_info view.

    Rajs

  6. 6 Alex May 18, 2011 at 6:17 pm

    Guys.

    Do you have any idea if there is a way to change that location (way too many directories) to a more simple one like background_dump_dest?

    Thanks,
    Alex.

  7. 7 database support March 2, 2012 at 2:18 am

    Nice information. Is there anyway to disable xml alert.log using any parameter. Sometimes .xml is creating lots of problem to monitoring alert.log errors.


Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




DISCLAIMER

I work for Amazon Web Services. The opinions I share in this blog are my own. I'm *not* communicating as a spokesperson for Amazon. In other words, I work at Amazon, but this is my own opinion.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,972 other followers

Oracle ACE Program Status

Click It

website metrics

Fond Memories

Copyright

All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2015. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Kevin Closson and Kevin Closson's Blog: Platforms, Databases, and Storage with appropriate and specific direction to the original content.

%d bloggers like this: