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 can configure this behavior directly from the UI:
- Navigate to Settings → Performance Polling → Optimize Data Collection → Oracle → Oracle DB Links
- Enable the Delete entry if it is not discovered 1 consecutive polls option.
For versions below 173800
Follow the steps given below to override this behavior:
- Open the AppManager_Home/working/conf/CustomMonitors/OracleDBServer.xml directory. Replace AppManager_Home with the actual directory path of Applications Manager.
- Locate the <OracleDBLinks> section and update RetainRowsOnDelete="YES" to RetainRowsOnDelete="NO".
- Decrement the version number found on top of XML file.
- Save the file and restart Applications Manager.
For example: Change Version="18" to Version="17"New to ADSelfService Plus?
Related Articles
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 ...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 ...Oracle Database Server Discovery Fails with an Error Message
Error: Failed. Oracle Server is down. Error Message: IO Error: The Network Adapter could not establish the connection Solution 1: The Oracle server is down, please ensure that the server is up and running. Solution 2: The Oracle server is not ...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 ...Database Query Monitor FAQ
How to fix an "Unable to find the Primary Key for tablename" error displayed after adding a query monitor? After adding a Database Query Monitor, users must select and update a Primary Key for each table. The primary key can be a single column or a ...