Show Oracle Alert Log Location

select * from v$diag_info;

The Oracle alert log can be found in the same sub-directory as Default Trace File which usually ends in …/trace/alert_.log

Leave a Comment

Scroll to Top