Listener log check


Job details

Name: Listener log check
Platform: Oracle
Category: Availability
Description: This checks and reads errors from the database listener log. Using Oracle native code to read.
Long description: This checks and reads errors from the database listener log. Using Oracle native code to read. (Oracle 8i only)
Version: 1.5
Default schedule: 7,27,47 * * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘oracle’]/.[hasengine=‘YES’ & (version like ‘8%’) & can_get_grant_create_any_directory=‘1′]

Parameters

Name Default value Description
listener log name listener.log The name of the Listener log file.
listener log path ORACLE_HOME\network\log The path name of the Listener log file.
listener log error text TNS- Defines which strings (errors) the Check must look for. Values for this parameter must be
listener log line HWM 1 Each time the Check read the listener log, it registers how many rows have been checked.
listener log max lines 1 If the listener log has more lines than the value of this parameter, then the Check terminates
listener log max elapsed time 60 Define the maximum elaps time the Check can execute (values are in seconds). If the execution ‘
listener log error text allowed TNS-12500 Specifies the error strings which are excluded.

Job Summary

less ORACLE_HOME/network/log/listener.log

Job Configuration Details

Execution Details

This job uses an Oracle stored procedure to read and analyze the listener logs for predefined errors. If certain conditions are met (like exceeds max lines or execution time), a WARNING status is returned, otherwise, an OK status might be reported.

Report Generation

This job generates a report titled “Listener log,” which displays data collected during the log check. It includes:

Status on check information

Directory objects

Implementation Notes

The SQL implementation used in this job makes use of Oracle specific functionality to access and manage file system-based log files. The procedure checks for errors defined by the job parameters and respects the acknowledgment and high water mark lines to optimize log file read operations.

Dependencies and Execution

Dependencies include:
- Self-reference: Ensuring the check acknowledges its own output to maintain continuity.
- File Log objects: Relies on file log procedures and statuses that may be shared with other alert log checks.
- Cleanup: Failures in dependencies can trigger cleanup operations to ensure system stability.

Installation and Upkeep Details

- The procedure is created to dynamically adapt to various instances by using placeholders in names.
- It has settings that allow force installation and does not support express installation which implies manual review and setup is required.
- Alterations to the procedure require recompilation indicating periodic updates may be implemented to enhance its functionality or adapt to system changes.