Alias Key Error

[nivethaa]

Hello Everyone ,

I tried to set up Alias for oracle.ts.discovery LLD rule ( from default template ) in the conf file :

Alias=custom.oracle.ts.discovery1racle.ts.discovery["tcp://localhost:1521","username","password","service"]

It keeps throwing this error when I try to check the key , sudo zabbix_agent2 -t custom.oracle.ts.discovery1

[m|ZBX_NOTSUPPORTED] [ORA-00000: DPI-1047: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared object file: No such file or directory". See https://oracle.github.io/odpi/doc/in...ion.html#linux for help]

I have configured the environment variable with HOME, LD_LIBRARY in /etc/zabbix/zabbix-agent2 . The items for the services are able to pull the data . Is this something with the alias ?

[Julianna Wilamowska]

Hi, in the link below you will find article for the error you mentioned. Hope that helps.
https://blog.zabbix.com/agentless-or...th-odbc/15589/

[nivethaa]

Hi Julianna , thank you for the article , I'm using zabbix agent2 and did set the environment variable as I have a full database install on the server . The items in the template is able to pull the database information , however I tried to set up an alias for existing LLD in the template and its not pulling the data and when I checked the alias key , it throws the environment variable error saying [m|ZBX_NOTSUPPORTED] [ORA-00000: DPI-1047: Cannot locate a 64-bit Oracle Client library:

I have this set up already in /etc/sysconfig/zabbix-agent2

ORACLE_BASE=/usr/local/oracle
ORACLE_HOME=/usr/local/oracle/product/19.0.0/db_1
PATH=/usr/share/Modules/bin:/usr/local/oracle/product/19.0.0/db_1/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/usr/local/oracle/product/19.0.0/db_1/bin
LD_LIBRARY_PATH=/usr/local/oracle/product/19.0.0/db_1/lib:/usr/local/oracle/product/19.0.0/db_1/network/lib

[nivethaa]

I have set up the LLD something like this :

Alias=custom.oracle.ts.discovery1racle.ts.discovery["tcp://localhost:1521","username","password","service"]


The oracle.ts.discovery["tcp://localhost:1521","username","password","service"] is the default LLD key in the template , I wanted to use an alias to try few things and it threw that error.