Log Files

Oracle's alert log
/u01/app/oracle/admin/orcl/bdump/alert_orcl.log


Show Alert Log Location
select value from v$parameter
where name like '%dump_dest';


http://www.adp-gmbh.ch/ora/concepts/alert_log.html