oracle probe profile connection error Create OCI environment failed with rc = -1

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

While configuring the oracle Metrics in Operator Console in SaaS relay hub robot server, its been observed that profile connection failed.

Environment

Any UIM version

Resolution

1. Add following environment variables path under controller->environment variables
ORACLE_HOME
TNS_ADMIN
LD_LIBRARY_PATH
PATH

Note: Define the ORACLE_HOME first in controller and then add the remaining variables.

Example:
ORACLE_HOME = /home/OracleClient/app/OracleClient/product/12.2.0/client_1
LD_LIBRARY_PATH = $ORACLE_HOME/lib:$LD_LIBRARY_PATH
PATH = $ORACLE_HOME/bin:$PATH

2. Make sure you have following set for oracle user used in probe configuration to connect to database.
grant connect to nimmon;
grant select_catalog_role to nimmon;
grant select on gv_$sort_segment to nimmon;
grant select on sys.ts$ to nimmon;

Make sure to replace nimmon with oracle user.
 

Additional Information

You may also look at below document.
https://comm.support.ca.com/kb/oracle-probe-connection-errors-create-oci-environment-failed-with-rc-1-or-ocienvcreate-failed-with-rc-1/KB000034400