Alert Log view

We can use view to read errors/warnings in alert log file.

RAC / Cloud RDS:

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- 1)
AND message_text like '%ORA-%')))
ORDER BY inst_id, originating_timestamp;

NON-RAC / Cloud RDS:

select inst_id,to_char(originating_timestamp) as originating_timestamp,message_text,host_address,to_char(normalized_timestamp) as normalized_timestamp from  v$diag_alert_ext where message_text like '%ORA-%' and originating_timestamp > sysdate-1/24 order by originating_timestamp desc;