Alert Log

 Problem Description : 

Location of the Alert log in Oracle

 Resolution : 

It can be found at /oracle/admin/prod/diag/rdbms/prod2/PROD/trace

You can query the following view to find the location of all files

To view the alert log with a text editor:

 Connect to the database with SQL*Plus or another query tool, such as SQL Developer.

 Query the V$DIAG_INFO view as shown in "Viewing ADR Locations with the V$DIAG_INFO View".

 To view the text-only alert log, without the XML tags, complete these steps:

 In the V$DIAG_INFO query results, note the path that corresponds to the Diag Trace entry, and change directory to that path.

 Open file alert_SID.log with a text editor.

 To view the XML-formatted alert log, complete these steps:

 In the V$DIAG_INFO query results, note the path that corresponds to the Diag Alert entry, and change directory to that path.

 Open the file log.xml with a text editor.

 Revision Date : 8/27/2012