AlertLogMonitor

Task Type: Database Monitor
Configurable: Yes
Host Dependent: Yes
Schedule Dependent: Yes

Description

The AlertLogMonitor parses Oracle alert logs and generates an alert when errors are found. During task execution each new line in the alert log is evaluated using a set of patterns (regular expressions) defined in TCSupportCenter; these are downloaded from TCSupportCenter when TCAgent starts. The type of alert generated when a match is found depends on the alert type defined for the matched pattern. For example, the following pattern definition is defined in TCSupportCenter:

Pattern Alert Type
^ORA-006 ALERT_LOG_0600

Lines in alert log starting with 'ORA-006' cause the task to generate an alert with type ALERT_LOG_0600. TCSupportCenter uses the alert type to determine the severity of the alert.

Configuration

The <AlertLogMonitorConfig> element is configured with the following attributes:

Attribute Required Description
ALERT_LOG Yes Defines the name (including path) of the alert log file.

The <AlertLogMonitorConfig> element may contain an <IgnoredPatterns> element which must contain at least one <Pattern> element. The <Pattern> element is configured with the following attributes:

Attribute Required Description
RE Yes Defines a pattern to ignore in the alert log file. The pattern must be a valid regular expression. Lines in the alert log containing a matching pattern are completely ignored and will never trigger an alert.

Example

<AlertLogMonitorConfig
 ALERT_LOG="/opt/oracle/admin/sid/bdump/alert_sid.log">
  <IgnoredPatterns>     
    <Pattern RE="space leak"/>
  </IgnoredPatterns>
</AlertLogMonitorConfig> 

In this example, any lines in the alert log file containing the string 'space leak' are ignored.

Your Source for Oracle Expertise