How do I monitor Oracle Alert Logs?
Alert Log monitoring in Applications Manager is not enabled by default. Here is how you can enable monitoring of Alert Log statistics:
- Go to the Admin tab.
- Click Performance Polling under Discovery and Data Collection.
- Under Performance Data Collection, click on the Optimize Data Collection tab.
- Select Oracle from the Monitor Type drop-down menu.
- Select Oracle Alert Log from the metric drop-down menu.
- Select how you wish to configure the Alert Log Statistics:
- By Monitor Type - This will be the default polling status, for any new monitor added. All the monitors of this type will have the default polling status, until any exclusive customization is performed. You can choose between three different polling settings: Never collect data, Collect data at every poll and Collect data at customized time interval. Changing the polling status of 'Monitor Type', will also change any configuration done for its 'Monitors'.
- By Monitors - Use this option to change the polling status of a particular monitor(s).
Please check that you have followed the prerequisites mentioned in this link when configuring the monitor.
FAQ: I enabled monitoring of Alert Log statistics but no data is being displayed in the Alert Log tab.
We show only recent alert logs (last 30 minutes of alerts) in every poll. To view alerts generated for past 24 hours, click View Alert Log History.
Oracle DB Alert log monitoring is supported for version Oracle 11g and above only.
Related Articles
How to import certificates for monitoring Oracle database with SSL authentication?
For users using Applications Manager version 14250 and below: One-way SSL: (Client authentication disabled) 1. Open the command prompt using 'Run as administrator' option and navigate to the Applications Manager installation directory. 2. Import your ...How to clear "Query Execution Timed Out" error alerts during Oracle monitor data collection?
Applications Manager throws the query timed out error in some scenarios as below: Query execution timed out due to this query group(s) : xxxxxxxx Error Message : java.sql.SQLRecoverableException: IO Error: Socket read timed out. (OR) Query ...The Oracle monitor is not working / The Oracle monitor is not collecting any data. What can I do?
Reason 1 - This could be because the Oracle user provided in Applications Manager does not have the necessary permission to run the query Go to <AppManager/logs> directory and check if you have an error print in stderr.txt / stderr.txt.1 / ...Troubleshooting URL Monitor
Here are few of the common errors you may come across in URL monitor, we have mentioned the steps you can follow to troubleshoot them. General troubleshooting for URL monitor Ensure that the URL is accessible from the server in which Applications ...When I add a new Oracle Monitor, the monitor is added successfully but I see two Oracle Monitors added in the web client for the same Oracle server.
Reason: When you add a Oracle Monitor, Applications Manager discovers the Oracle database server and adds a Oracle Monitor. Additionally, it also adds another Monitor for the particular instance of the Oracle database that you have configured. By ...