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.
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 ..."Authentication failed error" displayed at the top of the Monitor snapshot page, but the monitor is up and collecting data.
Monitor snapshot details page shows the correct status and collecting data. But Error message is shown as "Authentication failed. Kindly verify username and password provided." Update the ERRORMSG in HostDetails table as "Data Collection ...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 ...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 ...Unable to add some Oracle Monitor(s) in linux machine
Problem: While trying to add Oracle monitor in linux machine it fails with following error message. ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found Cause: This is due to jar incompatibility while adding Oracle ...