The Oracle Database Links are being reported as down even when no longer available. Why?
For Oracle Database Links, if data is not available for the current poll, this is the behavior exhibited by default:
- Data (including threshold) is retained
- Health is reported as down
To override this behavior, follow these steps:
Open AppManager_Home/working/conf/CustomMonitors/OracleDBServer.xml.
Search for RetainRowsOnDelete="YES" under OracleDBLinks section. Configure RetainRowsOnDelete="NO".
Decrement the version number found on top of XML file. For Example,
Category="DBS" ShortName="Oracle" DisplayName="Oracle" Version="18"
Category="DBS" ShortName="Oracle" DisplayName="Oracle" Version="17"
- Save the file and restart Applications Manager.
You need to replace AppManager_Home with actual directory path where AppManager is installed.
New to ADSelfService Plus?
Related Articles
Oracle Tablespace(s) are being reported as down even when they are no longer available. Why?
For Oracle Tablespace, if data is not available for the current poll, this is the behavior exhibited by default: Data (including threshold) is retained Health is reported as down To override this behavior, follow these steps: ...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 ...Instance based license for MSSQL and Oracle Monitors
In a single server, there can be multiple instances of Oracle/MSSQL database. Each instance is counted for licensing in Applications Manager. Example 1: In the above image, you can see that there are 3 instances of MS SQL DBs in a single server, ...While trying to discover Oracle Database server, it fails and prompts some message.
1) 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 whether the server is up and running fine. Solution 2: The Oracle server is ...All services are reported down, even if they are running.
Problem: All Services including Index Server was reported down by Applications Manager. But they are actually running. Solution: Default password for the SAP HANA user should be changed. JDBC connection to SAP HANA is not allowed while using default ...