How to receive alerts for certain Oracle alert log errors?
This video is applicable for Foglight 5.6.11 and higher.
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,
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.
The following is how you setup actions for email for the Oracle agents:
You must have the Mail Server Setting set so that emails can be sent. Information on the Global Administration area can be found in the "Managing Oracle Database Systems User Guide" here.
If you would like customizations to specific rules we could also engage our Professional Services Organization to assist you.