How to find alert file location in Oracle

There are many ways to find alert file location but i have simplified some ways and pasted below:

SQL>show parameter dump;


SQL>show parameter background_dump_dest;


SQL>show parameter diag;


SQL>select value from v$diag_info where name='Diag Trace';


From server level you can fire below command:

$ locate alert_dbname
Please share If you like..Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInShare on Yummly

Leave a Reply

Your email address will not be published. Required fields are marked *

Fariddin Shaikh's Oracle DBA Blog © 2016 Being DBA
Go Back