oracle probe - possible memory leak - probe consumes 100 MB/hr without release.

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The oracle probe appears to have a memory leak. The oracle probe is monitoring database instances remotely (not on the local database server). The memory is continuously increasing.

Environment

Environment: UIM v8.31

oracle probe v5.01 GA

OS the probe is running on: RHEL 6, 2.6.32-573.22.1.el6.x86_64

hub v7.80

robot v7.80, where oracle probe sits

12 G of RAM available on the robot where the oracle probe is running

profiles: > 51 on the Linux machine, 55+ connections

size of the oracle.cfg on the Linux machine is ~11MB

Oracle 11g and/or 12c database instances are being monitored

Oracle cluster and/or single instances (probe running on single instance RHEL)

Cause

Resolution

Oracle 12c client has a known memory leak as per Oracle Support. Memory leak is between 110-120k per Oracle client session (connection) when using the oracle probe.

1. Install Oracle client 11.2.0.3 (11g libraries are installed as part of the client install.) The 12c libs were still in place.

2. The Robot environment had to be configured for the 11g client.

For example: 

variable name               variable value

LD_LIBRARY_PATH  /orah4/product/11.2.0.3/lib 
NLS_LANG 
ORACLE_BASE         /orabase 
ORACLE_HOME        /orah4/product/11.2.0.3 
PATH                          /orah4/product/11.2.0.3/bin:$PATH

3. Cold start the oracle probe (Deactivate-Activate)

The memory leak issue should be averted.

Additional Information

The Oracle SR number is:

3-11609558641

Please also refer to the oracle probe Help doc:

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/alphabetical-probe-articles/oracle-oracle-database-monitoring/oracle-oracle-database-monitoring-release-notes.html#concept.dita_03df114cfbf63df6852ce5ad3b91546626756a5f_KnownIssuesandWorkarounds