I have set up monitoring of an Oracle database. The 'Tablespace Details' and 'Tablespace Status' areas show no data or error.
Solution: You can execute the TABLESPACE STATUS query in your Oracle and check the data.
- Go to <Appmanager/working/conf/application> directory.
- Then open the <Oracle.xml> file and check for the string "TABLESPACESTATUS".
- Below that you will find the queries for getting the Table Space Status statistics.
- Execute those queries in the Oracle Server and send the output.
- Also, send us the logs from the Applications Manager. Refer the following link for sending logs: https://desk.zoho.com/portal/manageengine/kb/articles/where-do-i-find-the-log-files-that-i-need-to-send-to-technical-support-team-for-analysis
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 ...Error message while performing database backup of Applications Manager
While performing a database backup operation of Applications Manager build with Pgsql backend, you may encounter the following error, especially when your database size has grown bigger with a large number of tables. pg_dump: WARNING: out of shared ...While trying to discover Oracle Database server, it fails and prompts with some message.
Reason 1: Service is not running. Solution: The Oracle server is down or the Oracle server is not accessible from the Applications Manager machine. Try to open a socket to the Oracle machine by executing the following command from the machine in ...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 ...Azure SQL Database - FAQ
1. Why have we removed the Diagnostic Settings dependency in Azure SQL Database monitor? Till APM v15240: Azure SQL Database was using Diagnostic Settings to perform data collection. Prerequisites had to be fulfilled to turn on Diagnostic Settings ...