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 / stderr.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
Real User Monitor (RUM) - Troubleshooting
If the monitor has not polled data for a long time, follow the steps below for troubleshooting: Step 1: Check prerequisites to be done Real User Monitor requires the RUM Agent to be installed and mapped to the Applications Manager. Refer the help ...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 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 ...APM Insight monitor is UP, but monitor page doesn't show any data
Possible Causes The APM Insight monitor status corresponds to the respective agent folder pointed Java Application status i.e., as long as the Application server is running, the monitor status will be UP. 1. No Transactions Recorded: It is possible ...