oracle probe profile connection error

book

Article ID: 130532

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

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

Environment

IM SaaS
 

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