The Oracle monitor is not working / The Oracle monitor is not collecting any data. What can I do?

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

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. 



      New to ADSelfService Plus?

      Start your free trial

        Resources

            • Related Articles

            • Real User Monitor (RUM) - Troubleshooting

              If the monitor has not polled data for long time. Follow below steps for troubleshooting Check prerequisites to done : Real User Monitor requires RUM Agent to be installed and mapped to Applications Manager. Refer the help page to know how to setup ...

            • 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 ...

            • How to get ISP data in Real User Monitor?

              By default, Real User Monitor does not show ISP data of end user. To get ISP data, you can make use of any third-party Geolocation API. Currently, RUM supports only APIs that return the response in JSON format. When you have purchased any Geolocation ...