Oracle probe metrics are shown under robot device running oracle probe

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Oracle probe metrics are not displayed under the Orale DB server device in USM as expected. 

Environment

Release :

Component : UIM - ORACLE

Cause

No ORACLE_HOME is defined.

Resolution

Add ORACLE_HOME environment variable in Controller config->Setup->Environment tab

Setting the ORACLE_HOME path is mandatory to generate the correct Device ID, routing the QoS messages and alarms to the correct device, and viewing data on the Unified Service Manager (USM). Find more information:

https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/oracle-oracle-database-monitoring/oracle-preconfiguration-requirements#oraclePreconfigurationRequirements-AddEnvironmentVariables

Note that the ORACLE_HOME variable is used for locating Oracle Net configuration files like tnsnames.ora. Even when an EZCONNECT string is used in the oracle probe config and the string specifies DB server hostname, the ORACLE_HOME variable is required to resolve this issue.

For library loading path (e.g., OCI), use PATH and/or LD_LIBRARY_PATH variable instead. When configuring such variables, include variable ORACLE_HOME when using instant client, or include ORACLE_HOME/bin, ORACLE_HOME/lib when using Oracle client, in the corresponding user variables.

Additional Information

How to determine Oracle Home installed on a Windows Platform:

For Oracle Client or Oracle Instant Client installed via GUI installer, find the information in local registry:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_{HOME_NAME}  

Note 32 bits client is not supported, such home can be found in the local registry:

HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ORACLE\KEY_{HOME_NAME}  

For Oracle Instant Client - Basic on a Windows Platform:

The Oracle home is the folder path where you have unzipped the file downloaded from Oracle Site and where you can find oci.dll.

For other platforms, check the corresponding environment variables set for the local Oracle Software owner user.