While configuring the oracle Metrics in Operator Console in SaaS relay hub robot server, its been observed that profile connection failed.
1. Add following environment variables path under controller->environment variables
Note: Define the ORACLE_HOME first in controller and then add the remaining variables.
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.
You may also look at below document.