--

-- Read the Alert Logs on RAC via SQL

--

SET PAUSE ON

SET PAUSE 'Press Return to Continue'

SET PAGESIZE 60

SET LINESIZE 300

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)

              )

            )

         )

ORDER BY 

  inst_id, 

  originating_timestamp

/