Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
You can query errors in Alert.log by sql query. You can use the following queries for this.
The following query returns with 20 rows.
1 | SQL> select message_text from X$DBGALERTEXT where rownum <= 20; |
or
1 2 3 4 5 6 7 8 9 | SQL> SELECT inst_id, originating_timestamp, MESSAGE_TEXT FROM TABLE ( gv$ ( CURSOR ( SELECT inst_id, originating_timestamp, MESSAGE_TEXT FROM v$diag_alert_ext WHERE originating_timestamp > (SYSDATE - 2) AND MESSAGE_TEXT LIKE '%ORA-%'))) ORDER BY inst_id, originating_timestamp; |
