Hi,
First post. I wasnt able to search through the forum posts so excuse this if its already been discussed. I am using Zabbix appliance on Centos linux. I am attempting to monitor Oracle databases using the Oracle odbc template. I'm using the recipe shown here in this blog... If there is a better setup process for Zabbix to monitor Oracle please give me that URL.
Agentless Oracle database monitoring with ODBC - Zabbix Blog
I have gone through and tested odbc and know that to be working. I cant seem to get Zabbix to monitor Oracle databases though. Here are the errors I'm seeing in the zabbix system log...
44196:20220319:195327.620 discovery rule "emcc:db.odbc.discovery[archivelog,,"Driver={$ORACLE.DRIVER};DBQ=//{HOST.CONN}:{$ORACLE.PORT}/{$ORACLE.SERVICE};"]" became not supported: Cannot connect to ODBC DSN: [SQL_ERROR]:[01000][0][[unixODBC][Driver Manager]Can't open lib '<Put path to oracle driver here>' : file not found]
44197:20220319:195328.623 discovery rule "emcc:db.odbc.discovery[asm,,"Driver={$ORACLE.DRIVER};DBQ=//{HOST.CONN}:{$ORACLE.PORT}/{$ORACLE.SERVICE};"]" became not supported: Cannot connect to ODBC DSN: [SQL_ERROR]:[01000][0][[unixODBC][Driver Manager]Can't open lib '<Put path to oracle driver here>' : file not found]
44196:20220319:195329.622 discovery rule "emcc:db.odbc.discovery[db_list,,"Driver={$ORACLE.DRIVER};DBQ=//{HOST.CONN}:{$ORACLE.PORT}/{$ORACLE.SERVICE};"]" became not supported: Cannot connect to ODBC DSN: [SQL_ERROR]:[01000][0][[unixODBC][Driver Manager]Can't open lib '<Put path to oracle driver here>' : file not found]
44197:20220319:195330.625 discovery rule "emcc:db.odbc.discovery[pdb_list,,"Driver={$ORACLE.DRIVER};DBQ=//{HOST.CONN}:{$ORACLE.PORT}/{$ORACLE.SERVICE};"]" became not supported: Cannot connect to ODBC DSN: [SQL_ERROR]:[01000][0][[unixODBC][Driver Manager]Can't open lib '<Put path to oracle driver here>' : file not found]
44196:20220319:195331.625 discovery rule "emcc:db.odbc.discovery[tbsname,,"Driver={$ORACLE.DRIVER};DBQ=//{HOST.CONN}:{$ORACLE.PORT}/{$ORACLE.SERVICE};"]" became not supported: Cannot connect to ODBC DSN: [SQL_ERROR]:[01000][0][[unixODBC][Driver Manager]Can't open lib '<Put path to oracle driver here>' : file not found]
My /etc/odbcinst.ini has this
[OracleODBC]
Description = Oracle ODBC driver for Oracle 21
Driver = /usr/lib/oracle/21/client64/lib/libsqora.so.21.1
The odbc.ini has a entry that I found to be required for Zabbix to create the connection string. It points to the driver entry in /etc/odbcinst.ini
[$ORACLE.DSN]
Driver = OracleODBC
It appears that when Zabbix attempts to connect it isnt seeing the /etc/odbcinst.ini and doesnt know where the library is. Can anyone help me on the setup process for Zabbix to monitor Oracle ?
Thanks in advance
First post. I wasnt able to search through the forum posts so excuse this if its already been discussed. I am using Zabbix appliance on Centos linux. I am attempting to monitor Oracle databases using the Oracle odbc template. I'm using the recipe shown here in this blog... If there is a better setup process for Zabbix to monitor Oracle please give me that URL.
Agentless Oracle database monitoring with ODBC - Zabbix Blog
I have gone through and tested odbc and know that to be working. I cant seem to get Zabbix to monitor Oracle databases though. Here are the errors I'm seeing in the zabbix system log...
44196:20220319:195327.620 discovery rule "emcc:db.odbc.discovery[archivelog,,"Driver={$ORACLE.DRIVER};DBQ=//{HOST.CONN}:{$ORACLE.PORT}/{$ORACLE.SERVICE};"]" became not supported: Cannot connect to ODBC DSN: [SQL_ERROR]:[01000][0][[unixODBC][Driver Manager]Can't open lib '<Put path to oracle driver here>' : file not found]
44197:20220319:195328.623 discovery rule "emcc:db.odbc.discovery[asm,,"Driver={$ORACLE.DRIVER};DBQ=//{HOST.CONN}:{$ORACLE.PORT}/{$ORACLE.SERVICE};"]" became not supported: Cannot connect to ODBC DSN: [SQL_ERROR]:[01000][0][[unixODBC][Driver Manager]Can't open lib '<Put path to oracle driver here>' : file not found]
44196:20220319:195329.622 discovery rule "emcc:db.odbc.discovery[db_list,,"Driver={$ORACLE.DRIVER};DBQ=//{HOST.CONN}:{$ORACLE.PORT}/{$ORACLE.SERVICE};"]" became not supported: Cannot connect to ODBC DSN: [SQL_ERROR]:[01000][0][[unixODBC][Driver Manager]Can't open lib '<Put path to oracle driver here>' : file not found]
44197:20220319:195330.625 discovery rule "emcc:db.odbc.discovery[pdb_list,,"Driver={$ORACLE.DRIVER};DBQ=//{HOST.CONN}:{$ORACLE.PORT}/{$ORACLE.SERVICE};"]" became not supported: Cannot connect to ODBC DSN: [SQL_ERROR]:[01000][0][[unixODBC][Driver Manager]Can't open lib '<Put path to oracle driver here>' : file not found]
44196:20220319:195331.625 discovery rule "emcc:db.odbc.discovery[tbsname,,"Driver={$ORACLE.DRIVER};DBQ=//{HOST.CONN}:{$ORACLE.PORT}/{$ORACLE.SERVICE};"]" became not supported: Cannot connect to ODBC DSN: [SQL_ERROR]:[01000][0][[unixODBC][Driver Manager]Can't open lib '<Put path to oracle driver here>' : file not found]
My /etc/odbcinst.ini has this
[OracleODBC]
Description = Oracle ODBC driver for Oracle 21
Driver = /usr/lib/oracle/21/client64/lib/libsqora.so.21.1
The odbc.ini has a entry that I found to be required for Zabbix to create the connection string. It points to the driver entry in /etc/odbcinst.ini
[$ORACLE.DSN]
Driver = OracleODBC
It appears that when Zabbix attempts to connect it isnt seeing the /etc/odbcinst.ini and doesnt know where the library is. Can anyone help me on the setup process for Zabbix to monitor Oracle ?
Thanks in advance
Comment