ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Oracle probe metrics are shown under robot device running oracle probe

book

Article ID: 132946

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

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

Cause

No ORACLE_HOME is defined.

Environment

Release :

Component : UIM - ORACLE

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.