“Opinions expressed are solely my own and do not express the views or opinions of my employer.”
Some database administrators have a hard time finding the alert log file in systems that they are not familiar with. Therefore, I decided to share two simple techniques to find the alert log file regardless of whether you know the system. Thus, the first technique is to check the alert log being connected to the SQL prompt using the x$dbgalertext view that brings the current information of the alert log. Therefore, this SQL follow as below:
SQL>set linesize 160 pagesize 200
col RECORD_ID for 9999999 head ID
col ORIGINATING_TIMESTAMP for a20 head Date
col MESSAGE_TEXT for a120 head Message
select
record_id,
to_char(originating_timestamp,'DD.MM.YYYY HH24:MI:SS'),
message_text
from
x$dbgalertext where originating_timestamp > sysdate-2;
Another form to find the alert log file is to go to the directory where the file is located. After, open it with some editor such as “vi,” for instance in Linux systems or “notepad” for Windows systems. To be able to find the location, you can use the following SQL query below:
SQL> SET PAGES 9999 SET LINES 9999 COLUMN name FORMAT A25 COLUMN value FORMAT A65 SELECT name, value FROM v$diag_info; NAME VALUE Diag Enabled TRUE ADR Base /u01/app/oracle ADR Home /u01/app/oracle/diag/rdbms/techdatabasket/techdatabasket1 Diag Trace /u01/app/oracle/diag/rdbms/techdatabasket/techdatabasket1/trace Diag Alert /u01/app/oracle/diag/rdbms/techdatabasket/techdatabasket1/alert Diag Incident /u01/app/oracle/diag/rdbms/techdatabasket/techdatabasket1/incident Diag Cdump /u01/app/oracle/admin/techdatabasket/cdump Health Monitor /u01/app/oracle/diag/rdbms/techdatabasket/techdatabasket1/hm Default Trace File /u01/app/oracle/diag/rdbms/techdatabasket/techdatabasket1/trace/techdatabasket1_ora_32298.trc Active Problem Count 15 Active Incident Count 486 ORACLE_HOME /u01/app/oracle/19.3.0/db 12 rows selected.
I hope this post helps you!
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.
… [Trackback]
[…] Read More here on that Topic: techdatabasket.com/2022/02/21/finding-the-alert-log-file-anywhere/ […]
… [Trackback]
[…] Read More to that Topic: techdatabasket.com/2022/02/21/finding-the-alert-log-file-anywhere/ […]
… [Trackback]
[…] Find More Info here to that Topic: techdatabasket.com/2022/02/21/finding-the-alert-log-file-anywhere/ […]
… [Trackback]
[…] Find More to that Topic: techdatabasket.com/2022/02/21/finding-the-alert-log-file-anywhere/ […]
… [Trackback]
[…] Read More Info here on that Topic: techdatabasket.com/2022/02/21/finding-the-alert-log-file-anywhere/ […]
… [Trackback]
[…] Read More Information here to that Topic: techdatabasket.com/2022/02/21/finding-the-alert-log-file-anywhere/ […]
… [Trackback]
[…] There you will find 25241 more Info to that Topic: techdatabasket.com/2022/02/21/finding-the-alert-log-file-anywhere/ […]
… [Trackback]
[…] Find More Info here on that Topic: techdatabasket.com/2022/02/21/finding-the-alert-log-file-anywhere/ […]