The Oracle monitor is not working or is not collecting any data. What can I do?
Reason:
If the Oracle monitor in ManageEngine Applications Manager is not collecting any data, the issue is most commonly caused by insufficient database privileges to execute the query by the Oracle user configured in the monitor.
Solution:
Go to <Applications Manager Home>/logs/OracleMonitor directory and check if you have an error print in oraclemonitorErr.txt / oraclemonitorErr.txt.1 / oraclemonitorErr.txt.2 ... files:
SYS_ERR: java.sql.SQLException: ORA-00942: table or view does not exist
SYS_ERR: java.sql.SQLException: ORA-00942: table or view does not exist
If you see the above error, connect to the Oracle database using the same credentials provided in Applications Manager and execute the below query and check the output:
select VERSION, STARTUP_TIME from v$instance
If you receive the same error (ORA-00942: table or view does not exist), it means Oracle user provided in Applications Manager does not have access to the table or view and you will need to have the owner of the table/view. Refer https://desk.zoho.com/portal/manageengine/kb/articles/i-tried-adding-oracle-monitor-not-able-to-add-it-says-permission-denied for providing required privileges.
If you receive the same error (ORA-00942: table or view does not exist), it means Oracle user provided in Applications Manager does not have access to the table or view and you will need to have the owner of the table/view. Refer https://desk.zoho.com/portal/manageengine/kb/articles/i-tried-adding-oracle-monitor-not-able-to-add-it-says-permission-denied for providing required privileges.
New to ADSelfService Plus?
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 ...Self monitor Applications Manager using Real User Monitoring
We can monitor the Applications Manager using Real User Monitoring with a Java Script injection and this can be used to measure the Applications Manager's performance continuously. All you need is to install and setup the Real User Monitoring (RUM) ...Self monitor Applications Manager using APM Insight Java Agent
Applications Manager is built with Java, hence we can monitor it using APM Insight Java Agent to measure it's performance continuously, which can be very much useful. Setting up APM Insight Java Agent Follow the below steps to download and set up the ...How to configure Output Settings for Script Monitor?
Below are the details on how to configure Script Monitor Output Settings and expected output format, Output Configuration: Expected Output File Format: In the output file, Scalar data should be separated by scalar delimiter, here name, cpu, javaHeap ...DNS Monitor - Troubleshooting
Common DNS Monitor Errors and Troubleshooting Guide 1. Host Not Found Description: The DNS server was unable to locate the requested lookup address. Possible Causes: This may happen if the hostname is incorrect, the domain does not exist, or there is ...