暂无图片
zabbix6.0 odbc监控报错
我来答
分享
XM.
2022-06-09
zabbix6.0 odbc监控报错

以下是添加web监控项时的报错

Cannot connect to ODBC DSN: [SQL_ERROR]:[01000][0][[unixODBC][Driver Manager]Can't open lib '/usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1' : file not found]

查看依赖包也没少

[root@zabbix tmp]# ldd /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
linux-vdso.so.1 (0x00007ffd737ee000)
libdl.so.2 => /usr/lib64/libdl.so.2 (0x00007fade922b000)
libm.so.6 => /usr/lib64/libm.so.6 (0x00007fade8ea9000)
libpthread.so.0 => /usr/lib64/libpthread.so.0 (0x00007fade8c89000)
libnsl.so.1 => /usr/lib64/libnsl.so.1 (0x00007fade8a6f000)
libclntsh.so.11.1 => /usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1 (0x00007fade6100000)
libodbcinst.so.1 => /usr/lib64/libodbcinst.so.1 (0x00007fade5eea000)
libc.so.6 => /usr/lib64/libc.so.6 (0x00007fade5b25000)
/lib64/ld-linux-x86-64.so.2 (0x00007fade942f000)
libnnz11.so => /usr/lib/oracle/11.2/client64/lib/libnnz11.so (0x00007fade5758000)
libaio.so.1 => /usr/lib64/libaio.so.1 (0x00007fade5555000)
libltdl.so.7 => /usr/lib64/libltdl.so.7 (0x00007fade534b000)

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
Uncopyrightable

Solution:

Create file
Code:
[root@zabbix ~]# cat /etc/sysconfig/zabbix-server
ORACLE_HOME=/usr/lib/oracle/11.2/client64
LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib:/usr/lib64
TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/usr/lib/oracle/11.2/client64/lib

export ORACLE_HOME
export LD_LIBRARY_PATH
export TNS_ADMIN
export PATH
Restart zabbix
Code:
service zabbix-server restart
Сheck environment variables
Code:
[root@zabbix ~]# strings -a /proc/<Zabbix Main PID>/environ
LANG=en_US.UTF-8
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/usr/lib/oracle/11.2/client64/lib
CONFFILE=/etc/zabbix/zabbix_server.conf
ORACLE_HOME=/usr/lib/oracle/11.2/client64
LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib:/usr/lib64
TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin

暂无图片 评论
暂无图片 有用 0
打赏 0
XM.
题主
2022-06-10
Zabbix Main PID 怎么获取
XM.
题主
2022-06-10
按照上面的步骤配置还不行
回答交流
Markdown


请输入正文
提交