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, change
Category="DBS" ShortName="Oracle" DisplayName="Oracle" Version="18"
to
Category="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?