| 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’ |
| Parameters |
|
|
| 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 dd.mm.yyyy) 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) →
Post your comment on this topic.