Name: Alert log check
Platform: Oracle
Category: Availability
Description: This check reads and looks for errors in the database alert log.
Long description: This check reads and looks for errors in the database alert log. Uses Oracle internal routines to read files. (Oracle 9i only).
Version: 2.6
Default schedule: 0,10,20,30,40,50 * * *
Requires engine install: Yes
Compatibility tag: [CDATA[.[type=‘instance’ & databasetype=‘oracle’]/.[hasengine=‘YES’ & (version like ’9%’) & _priv_read_v_parameter = ‘1’ & can_get_grant_create_any_directory=‘1’
Name Default value Description
alert log name alert_ORACLE_SID.log The name of the Oracle alert log.
alert log directory name DBW_DUMP_DEST The name of the directory object created with the DDL – “create directory”.
alert log error text ORA- Defines which strings (errors) the Check must look for. Values must be separated with commas (,).
alert log line HWM 1 Each time the Check read the alert log, it registers how many rows have been checked. The next time
alert log max lines 200000 If the alert log has more lines than the value of this parameter, then the Check terminates and
alert log max elapsed time 60 Define the maximum running time the Check can execute (values are in seconds). If the execution time reach
alert log error text allowed NULL Specifies the error strings which are excluded.
loop time 180 The number of seconds the “Alert log check” will continue to try to open the alert log file if an exception occurs during opening of the file. This parameter was introduced as a workaround when the alert log file is locked by other process.
pause time 20 The number of seconds the check will wait before trying to reopen the alert log file when an exception occurred during opening of that file.
max exception time 40 The maximum number of minutes the check will try to reopen the alert log file. If the check is not able to open the file for this amount of time (in minutes), it will return a warning.
last exception null The timestamp (hh24:mi when an exception occurred trying to open the alert log file. If null, the opening of the alert log file is successful.

← Alert log check (10g) / Alert log check (8i) →


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment