Why are Oracle Tablespace(s) being reported as down even when they are no longer available?
If data is not available for the current poll in the Oracle Tablespace monitor, this is the behavior exhibited by default:
- Data (including threshold) is retained
- Health is reported as down
For Applications Manager version 173800 and above
- Go to Settings → Performance Polling → Optimize Data Collection → Oracle → TableSpace Statistics
- Enable the Delete entry if it is not discovered 1 consecutive polls checkbox.
For Applications Manager versions below 173800
To override this behavior, follow the steps given below:
- Open AppManager_Home/working/conf/CustomMonitors/OracleDBServer.xml.
- Locate the Tablespace section and change the configuration from RetainRowsOnDelete="YES" to RetainRowsOnDelete="NO".
- Decrement the version number present at the top of the XML file.
For example, changeCategory="DBS" ShortName="Oracle" DisplayName="Oracle" Version="18"toCategory="DBS" ShortName="Oracle" DisplayName="Oracle" Version="17"
- Save the file and restart Applications Manager.
Replace AppManager_Home with the actual directory path where Applications Manager is installed.
New to ADSelfService Plus?
Related Articles
Why are Oracle Database Links being reported as down even when they are no longer available?
By default, if data for the Oracle Database Links is not available during the current poll, Applications Manager behaves as follows: Existing data (including thresholds) is retained Health status is reported as Down For versions 173800 and above You ...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 ...Discrepancy with Oracle DB Tablespace information shown in Applications Manager
By default, Oracle DB Tablespace statistics is calculated along with its auto-extensible size in Applications Manager. If you want to calculate Tablespace statistics without considering the Auto Extend option, navigate to Settings -> Performance ...Monitoring Oracle standby databases in Applications Manager
Do we support Oracle Standby Database monitoring? Yes, we do. How to connect to the Standby/Standalone Oracle database which is in MOUNTED mode? To connect to an Oracle database in STANDBY MOUNTED or normal MOUNTED mode, you must use the sysdba user ...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 ...