[ZBX-24686] 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] Created: 2024 Jun 20 Updated: 2024 Jul 04 Resolved: 2024 Jun 26 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Server (S) |
Affects Version/s: | 6.0.30 |
Fix Version/s: | None |
Type: | Problem report | Priority: | Trivial |
Reporter: | mingking | Assignee: | dimir |
Resolution: | Won't fix | Votes: | 0 |
Labels: | odbc_Monitor | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Attachments: |
![]() ![]() ![]() |
Description |
2.with odbc Monitor Configuration Below: [root@Ora ~]# rpm -qa |grep ODBC
[root@Ora ~]# odbcinst -j
[root@Ora ~]# cat /etc/odbcinst.ini [Oracle]
[root@Ora ~]# isql -v audit
---------------------------------------
-------------
-------------
3. user zabbix and root ldd output Below : [root@Ora zabbix]# chmod 777 -R /usr/lib/oracle [root@Ora zabbix]# ls -l /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1 [root@Ora ~]# ldd /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1 [root@Ora zabbix]# env 4. zabbix_server path with Binary compilation: [root@Ora zabbix]# pwd [root@Ora zabbix]# ls 5.Find a closer solution on the official website,But there is no process environment variable associated with Oracle [root@Ora zabbix]# cat /etc/sysconfig/zabbix-server export ORACLE_HOME [root@Ora zabbix]# systemctl restart zabbix_server [root@Ora zabbix]# ps -ef |grep zabbix [root@Ora diag]# strings -a /proc/1376564/environ How to make the main process with oracle environment variables ?Or deal with the problem of not finding the file ”libsqora.so.11.1“
|
Comments |
Comment by dimir [ 2024 Jun 26 ] |
This is not a Zabbix issue. Your system (ldconfig) is not properly configured. You need to add the path to the list of paths: echo "/usr/lib/oracle/11.2/client64/lib" | sudo tee /etc/ld.so.conf.d/oracle-client-12.2.conf sudo ldconfig -v | grep oracle Closing "Won't fix", feel free to re-open if you disagree. |
Comment by mingking [ 2024 Jun 27 ] |
Before referring to the configuration steps of many people I have done this step,The error remains: in user root setup: Check the code: Must the file name be identical to the code provided, But I think it's just a filename, whether it's 12 or 21, it's mostly the contents of the file. It's okay, just consulting. It may also be the use of the operating system-level problems, later also replaced the oracle high version of the driver, for the time being you can use ODBC to monitor |
Comment by dimir [ 2024 Jul 04 ] |
Yeah, all those numbers are just an example, you should use exactly what you have. The following commands could help you generate the proper command: find /usr/lib/oracle -name '*.so' find /etc -name 'oracle-client*.conf' |