-
제목
Receiving alarm messages for certain Oracle alert log errors -
설명
How to receive alerts for certain Oracle alert log errors?
This video is applicable for Foglight 5.6.11 and higher.
-
해결 방안
Video
The Alert Log administration screen allows configuring the retrieval and display settings for the Configuration > Alert Log panel. In addition, this screen allows defining default settings for invoking alarms based on the collected alerts.
Both the Match List and the Ignore List panes can be customized by adding, editing or removing alert logs. Each filter can be enabled or disabled separately by clicking Edit and selecting or clearing the Enabled check box. Alternatively, to enable or disable all of the filters, click the Enable All or Disable All button.
To manage the alert log alarms,
- go to the Database Dashboard and select an instance or multiple instances with the checkbox
- Click Administration
- On Global Administration page,
- Select "Alert Log" from the left hand side list
- Enable or Disable all will then turn on or off all of the alarms for Oracle errors.
NOTE: By default, alarms are invoked only for an alert log summary that includes messages whose level is Critical or higher:Set the state of the minimal severity for which summary alarms are invoked as: CriticalSet the state of the minimal severity for which alarms are invoked as: OFFNumber of rows to collect from logs: 500In order to receive individual alarms for each match, toggle "Set the state of the minimal severity for which alarms are invoked as" to the required minimum Severity level you wish to get Alarms and/or Email Notifications for.
From the match list you can find and select the filter name that matches your error (ORA-01114 should be datafile corruption), then click edit and check Enabled and confirm by clicking button set.
Make sure "Filter" is green if you'd like the filter to be enabled, then after that and save the changes using the "save changes" button.If you would like customizations to specific rules we could also engage our Professional Services Organization to assist you.