Search notes:

Oracle: alert log

The alert log stores database messages (also error messages) in chronological order. Messages that go to the alert log file include
The alert log is stored in the Automatic Diagnostic Repository (ADR).

Locating the alert log

The alert log file is found in the directory that is returned with the following query: 
select
   value
from
   v$diag_info
where
   name = 'Diag Trace';

Showing the contents of the alert log

ADRCI

With ADRCI, the content of the alert log file is opened in an editor: 
$ adrci
…
adrci> show alert
In order to change the editor in which the alert log is displayed, set editor must be used: 
adrci> set editor gvim

Via X$DBGALERTEXT

The content of the alert log file is also exposed in the x$dbgalertext view.

Writing to the alert log

It is possible to write a message to the alert log with the dbms_system.ksdwrt() function

See also

The attention log which was introduced with 21c.
Event 10035 write SQL parse failures to the alert log.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1788531968, '216.73.217.21', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/architecture/database/system-files/Automatic-Diagnostic-Repository/alert-log/index(84): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78