Oracle probe generating False Alarm

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

In one server oracle probe is generating false connection failure alarm. When we got the alarm immediate we check the connection and found connections are established but alarm stays in alarm window and not auto cleared.

Environment

Release : 9.0.2

Component : UIM - ORACLE

oracle v5.45

robot v9.20HF7

Cause

- The oracle probe for AIX is tested and supported on AIX v7.1 but not 7.2.

Resolution

Please try this:

1. open the oracle probe in raw configure mode
2. go to connections
3. on the affected connections () add a key/value as below
4. timeout = 20 secs
(an example of this key is visible in sample_conn connection)
5. Increase loglevel to 5 and logsize to 30000
6. Please monitor this issue until you can see a new occurrence.

Please check:

oracle Preconfiguration Requirements
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/monitoring/bigdata-databases-and-storage/oracle-oracle-database-monitoring/oracle-preconfiguration-requirements.html

also:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/monitoring/bigdata-databases-and-storage/oracle-oracle-database-monitoring/oracle-troubleshooting.html

If you're monitoring Oracle instances, we require the local tnsnames.ora file for the oracle client the probe is using have the entries for the instances that need to be monitored.

Check the section on controller environment variables, add and configure them.

ORACLE_HOME
ORACLE_BASE
ORACLE_SID
PATH (should include the ORACLE bin directory.)
TNS_ADMIN
LD_LIBRARY_PATH
AIX requires the LIBPATH as well. oracle probe version 4.71 does not support AIX 6 and 7. You need 4.90 or higher.

Check which version of Oracle you are monitoring, if its Oracle 12c,

There is a known memory leak issue in Oracle libraries that occurs on Oracle 12c. This information is documented in probe release notes:
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/monitoring/bigdata-databases-and-storage/oracle-oracle-database-monitoring/oracle-oracle-database-monitoring-release-notes.html

Unfortunately, there is nothing we can do at probe level to fix this. The solution we always recommend is to use the Oracle client 11g.
See also-> https://knowledge.broadcom.com/external/article?articleId=4263 

Note that we do not support 32-bit oracle clients on a 64-bit OS.
The oracle client we use must MATCH the OS bit level.

The oracle probe for AIX is tested and supported on AIX v7.1 but not 7.2.