oracle probe profile connection error

Document ID : KB000130532
Last Modified Date : 05/04/2019
Show Technical Document Details
Issue:
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