Where is my alert.log?

Oracle 11g is loaded with many new exciting features like Change Management, enhanced Diagnosis Capability, Storage management etc. But it also have some basic changes, in terms of log / trace locations. Specifically, people who are using old versions (8i/9i/10g) may find it little difficult to get there hands-on to these locations.

For example: alert.log file, which is the first point, any DBA will start the investigation, is now a XML file. Old text based alert.log can still be found, but will phase out in new releases. So it’s time to get use to these new locations.

This new hierarchy structure is aligned with new support workbench & features like incident management

A new parameter ‘diagnostic_dest’ is included, which will control the location of log & trace files.

The default value of this parameter is set as $ORACLE_BASE.

If ORACLE_BASE is set to /u01/app/oracle, we will see following hierarchy

$/u01/app/oracle/diag> ls -al

drwxrwxr-x 3 oracle oinstall 512 Mar 13 16:00 asm
drwxrwxr-x 4 oracle oinstall 512 Apr 16 14:29 clients
drwxrwxr-x 2 oracle oinstall 512 Mar 13 15:55 crs
drwxrwxr-x 2 oracle oinstall 512 Mar 13 15:55 diagtool
drwxrwxr-x 2 oracle oinstall 512 Mar 13 15:55 lsnrctl
drwxrwxr-x 2 oracle oinstall 512 Mar 13 15:55 netcman
drwxrwxr-x 2 oracle oinstall 512 Mar 13 15:55 ofm
drwxrwxr-x 3 oracle oinstall 512 Mar 13 16:22 rdbms
drwxrwxr-x 3 oracle oinstall 512 Mar 13 17:04 tnslsnr

Each component, now have different directory allocated in diagnostic_dest.

For example, to check anything related to rdbms, we’ll have to navigate as following

$ cd $ORACLE_BASE/diag/rdbms/DB_NAME/INSTANCE_NAME

If my database is created as devdb, I’ll land up in /u01/app/oracle/diag/rdbms/devdb/DEVDB

Which have following directory structure

drwxr-x— 2 oracle oinstall 512 Mar 13 16:22 alert
drwxr-x— 2 oracle oinstall 512 Mar 13 16:22 cdump
drwxr-x— 2 oracle oinstall 512 Mar 13 16:22 hm
drwxr-x— 4 oracle oinstall 512 Jun 26 02:19 incident
drwxr-x— 3 oracle oinstall 512 Jul 17 12:56 incpkg
drwxr-x— 2 oracle oinstall 512 Jun 26 02:08 ir
drwxr-x— 2 oracle oinstall 1536 Jun 26 02:24 lck
drwxr-x— 2 oracle oinstall 1536 Mar 13 16:22 metadata
drwxr-x— 2 oracle oinstall 512 Jun 26 02:19 stage
drwxr-x— 2 oracle oinstall 512 Jun 26 02:24 sweep
drwxr-x— 2 oracle oinstall 556544 Aug 6 13:46 trace

-> alert – New alert.log (XML format)
-> cdump – Core files
-> hm – Health monitor
-> incident – incident related information
-> incpkg – Incident package
-> ir – incident report
-> trace – user session trace files
This location information is stored in v$diag_info view

sql> select name, value from v$diag_info
/


Old trace file can be found under
==========================
/u01/app/oracle/diag/rdbms/devdb/DEVDB/trace> ls -al alert*
-rw-r—– 1 oracle oinstall 504996 Aug 6 11:00 alert_DEVDB.log

Advertisements
This entry was posted in Oracle 11g Enhancements and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

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