top of page
CerebroSQL

ORACLE ALERT.LOG VIEWER

View syslog data alert.logDBMSOraclewithout a physical connection to the DBMS server via ssh or rdp with the ability to filter data by various parameters

Alert log general

Working with a window

View database alert.log

Switch "Type filter"

  • Full data  - load all data from "v$diag_alert_ext"

  • Ora only  - select only lines containing error text

  • Select the last  - select the last N (the value is specified in the field  "The number of lines (last)") lines

  • Date between  - select data for a time interval

select component_id,

       host_address, 

       originating_timestamp,

       message_text 

  from v$diag_alert_ext 

 where component_id not like '%tnslsnr%'

order by originating_timestamp

bottom of page