Oracle
How to resolve the "ORA-01017 : Invalid Username/Password; Logon denied" error in an Oracle monitor
In Applications Manager, users might encounter the following error while attempting to add or monitor the Oracle database. This error indicates an issue with authentication credentials or other related configuration settings. To troubleshoot this ...
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 ...
How to clear "Query Execution Timed Out" (or) "Socket Read Timed Out" error alerts during Oracle monitor data collection?
Applications Manager throws the Query timed out/Socket read timed out error in some scenarios as below: Socket read timed out due to this query group(s) : xxxxxxxx Error Message : java.sql.SQLRecoverableException: IO Error: Socket read timed out. ...
Unable to add some Oracle Monitor(s) in linux machine
Problem: While trying to add Oracle monitor in linux machine it fails with following error message. ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found Cause: This is due to jar incompatibility while adding Oracle ...
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 ...
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 do I monitor Oracle Alert Logs?
Alert Log monitoring in Applications Manager is disabled by default. Here is how you can enable monitoring of Alert Log statistics: Go to the Settings tab. Click Performance Polling under Discovery and Data Collection. Click on the Optimize Data ...
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 ...
The Oracle monitor is not working or is not collecting any data. What can I do?
Reason: If the Oracle monitor in ManageEngine Applications Manager is not collecting any data, the issue is most commonly caused by insufficient database privileges to execute the query by the Oracle user configured in the monitor. Solution: Go to ...
I am not able to add Oracle monitor, it says "Permission denied".
Reason: Applications Manager requires access to specific Oracle system views in order to collect database performance and availability metrics. If the configured Oracle user lacks sufficient privileges, the monitor cannot be added successfully and a ...
Oracle Server is running but when I try to add through Applications Manager it is saying "Service is not running".
Solution: Kindly do the following checks: 1) The "Connect String" given when you are connecting through the SQLPlus should be given as Database Name in Applications Manager. 2) Kindly check whether the "Database Name" that you have given is properly ...
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 ...
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 ...