Alert log check (java)


Job details

Name: Alert log check (java)
Platform: Oracle
Category: Availability
Description: This check reads and looks for errors in the database alert log. Uses embedded java to read files.
Long description: This check reads and looks for errors in the database alert log. Uses embedded java to read files.
Version: 2.7
Default schedule: 0,10,20,30,40,50 * * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘oracle’]/.[hasengine=‘YES’ & (version like ‘10.2%’) & enable_java = ‘1′ ]

Parameters

Name Default value Description
alertlog name AUTO The name of the Oracle alert log. If set to AUTO, we will try to figure out the alert log file name ourself.
alertlog directory name AUTO The name of the directory we are looking for the alert log in. If set to AUTO, we will try to figure out where the alert log file is located.
alertlog error text ORA- Defines which strings (errors) the Check must look for. Values must be separated with commas (,). Text is case and space sensitive, so “ ORA-, Error” is looking for “ ORA-” and “ Error”, different from “ORA-,Error” which looks for “ORA-” and “Error”.
alertlog line HWM 0 Each time the Check read the alert log, it registers how many rows have been checked. The next time
alertlog read lines 4000 Number of lines to maximum read on each run.
alertlog error text allowed Specifies the error strings which are excluded. Values must be separated with commas (,). Text is case and space sensitive, so “ ORA-, Error” is looking for “ ORA-” and “ Error”, different from “ORA-,Error” which looks for “ORA-” and “Error”. This list is filtering away errors found by “alertlog error text”, so if “ORA-” is searched for in “alertlog error text” parameter, and “ORA-600″ is in “alertlog error text allowed” parameter, then “ORA-600″ messages are not reported on.

Job Summary

Job Configuration

Implementation Details

Database Interactions

Alert Log Monitoring Logic

Error Handling

Report Generation

By continuously monitoring the alert logs and reporting specific issues, the dbWatch job helps in proactive maintenance and supports the administrative teams in ensuring optimal performance and stability of the database environments.