ORACLE ALERT.LOG VIEWER

​

​

Viewing System Log Data  alert.log Oracle DBMS without a physical connection to the DBMS server via ssh or rdp with the ability to filter data by various parameters

​

​

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 indicated in the field  "The number of lines (last)"

• 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