Help needed setting up Oracle Database Monitoring

[brian.m]

Hey All

Just working on a project (more a POC) to move our monitoring to Zabbix. So far so good, however, I've encountered an issue setting up Oracle DB monitoring per this document: https://www.zabbix.com/integrations/...#oracle_agent2. I've set up and everything and the agent is reporting as normal. The only problem is that the oracle database monitoring is not working at all. I've installed the Instant Client on the Zabbix Server and added the Database host to inventory. I also set the the following three macros for the database directly:
Macro Value
{$ORACLE.USER} > {zabbix_mon}
{$ORACLE.PASSWORD} > (verylongpasswordhere)
{$ORACLE.CONNSTRING} > (tcp://ipofdbserver:1521}
{$ORACLE.SERVICE} > {testdbservice}

I've double checked and TNS listener and connectivity is fine on the database in question. I am at a loss as to what is the issue.

Questions:
1) After installing the instant client do I also need to set tnsnames?
2) Are the above values correct?
3) What configuration items are required in the zabbix agent 2 file

Many thanks for any and all help!

Cheers
Brian

[brian.m]

Finally got this sorted.

[amit.z]

have the exact same question..following

[brian.m]

If you are having the same issue did you also set the following environment variables for the agent?
Environment variables:
LD_LIBRARY_PATH=/oracle/app/oracle/product/19.0.0/dbhome_1/lib
ORACLE_HOME=/oracle/app/oracle/product/19.0.0/dbhome_1