Path of the alertlog file in Oracle Database 11gR2

How to view the alert log of the database.

alertlog file is meant to track the database when the database has started and shutdown and if there is any discrepancies are present in the database,all information are present in the alert log file.

Path of the alertlog file..

Steps are:  1. Connect to Oracle Database viz SYS or SYSTEM user.
                  2. Encounter the command " show parameter background"  or "show parameter dump"
                  3. Go to the path present beside "background_dump_dest"
                  4. search for alert_DEV_log file by ls -lrt *alert*.log
                  5. View the file for error of information.  use ..   view *alert*.log file


Above steps are demonstrate below attaching snaps.

1. Connect to Oracle Database as SYS or SYSTEM user.










2.  Encounter the command " show parameter background"  or "show parameter dump"


3. Step 3.4, 5



4. open the log file and check what you looking for


Press ESC :q!  and press enter--> to come to command prompt with out altering anything to the log file.