Dear All,
i'm using zabbix 6.2.4 & i want to monitoring oracleDB via ODBC .
But i have some issue :
- can not connect DB when use : isql -v oracle
-> output error : isql -v orcl
[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/oracle/12.2/client64/lib/libsqora.so.12.1' : file not found
but when i check in this dir , it still have this file
* /etc/odbc.ini
[root@Zabbix ~]# cat /etc/odbc.ini
[orcl]
Driver=Oracle12c
Servername=xx.xx.xx.xx:1521/orcl
Database=orcl
Port=1521
UserID=zabbix
Password=zabbix
DatabaseCharacterSet=AL16UTF16
*/etc/odbcinst.ini
[Oracle12c]
Description=Oracle ODBC Driver
Driver=/usr/lib/oracle/12.2/client64/lib/libsqora.so.12.1
Trace=yes
TraceFile=/var/log/odbcoracle
================================================== ======
so , i think this is reason why i zabbix have this problem as below:
Anyone can help please !
i'm using zabbix 6.2.4 & i want to monitoring oracleDB via ODBC .
But i have some issue :
- can not connect DB when use : isql -v oracle
-> output error : isql -v orcl
[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/oracle/12.2/client64/lib/libsqora.so.12.1' : file not found
but when i check in this dir , it still have this file
* /etc/odbc.ini
[root@Zabbix ~]# cat /etc/odbc.ini
[orcl]
Driver=Oracle12c
Servername=xx.xx.xx.xx:1521/orcl
Database=orcl
Port=1521
UserID=zabbix
Password=zabbix
DatabaseCharacterSet=AL16UTF16
*/etc/odbcinst.ini
[Oracle12c]
Description=Oracle ODBC Driver
Driver=/usr/lib/oracle/12.2/client64/lib/libsqora.so.12.1
Trace=yes
TraceFile=/var/log/odbcoracle
================================================== ======
so , i think this is reason why i zabbix have this problem as below:
Anyone can help please !