Oracle
How to clear "Query Execution Timed Out" error alerts during Oracle monitor data collection?
Applications Manager throws the query timed out error in some scenarios as below: Query execution timed out due to this query group(s) : xxxxxxxx Error Message : java.sql.SQLRecoverableException: IO Error: Socket read timed out. (OR) Query ...
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 ...
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: ...
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 ...
How do I monitor Oracle Alert Logs?
Alert Log monitoring in Applications Manager is not enabled by default. Here is how you can enable monitoring of Alert Log statistics: Go to the Admin tab. Click Performance Polling under Discovery and Data Collection. Under Performance 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 / The Oracle monitor is not collecting any data. What can I do?
Reason 1 - This could be because the Oracle user provided in Applications Manager does not have the necessary permission to run the query Go to <AppManager/logs> directory and check if you have an error print in stderr.txt / stderr.txt.1 / ...
I am not able to add Oracle monitor, it says "Permission denied".
Reason: The required privileges are missing. Solution: For creating new Oracle database monitor, you should have: 1. Admin privileges. 2. Minimum User privileges ->user with CONNECT and SELECT_CATALOG_ROLE roles. Some might try changing the SYS as ...
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 ...
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 ...