Where is alert log file in oracle

In case that you cannot query the database, you can still find the location of alert log at OS-level. Almost all UNIX and Linux have find command, so using it to find some files is a very common way to do it. As we can see, the file was found. Sometimes, using locate command will be faster than find to find the path of alert log file. In some databases, the alert logs are big, maybe too big to make room for other files.

Both these log files are stored inside the ADR home. Within the ADR home directory are subdirectories where the database instance stores diagnostic data. XML formatted alert.

To get the log. Text formatted alert. To view the text-only alert. With 11g ,Oracle provides a way to look the alert log file from the database also. We can find the alert log location using below also. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page.

All rights reserved by Burleson. Search BC Oracle Sites. Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.