Hello,
I got a old Oracle database version 11c
I first try to monitoring it with zabbix agent2 but that only seem to work with Oracle 12c or later.
So i just follow this official guide (https://git.zabbix.com/projects/ZBX/...at=release/5.4) from zabbix to get it work with ODBC driver but i am completely stuck on something.
Cannot connect to ODBC DSN: [SQL_ERROR]:[IM004][0][[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed]
I can't figure it out what the problem :
My LD_LIBRARY_PATH seem good.
Here is the odbc.ini :
The odbcinst.ini :
I try with isql -v but i got the same error.
Did someone already see that, how to solve it ?
Thanks in advance for you reply
Best regards,
I got a old Oracle database version 11c
I first try to monitoring it with zabbix agent2 but that only seem to work with Oracle 12c or later.
So i just follow this official guide (https://git.zabbix.com/projects/ZBX/...at=release/5.4) from zabbix to get it work with ODBC driver but i am completely stuck on something.
Cannot connect to ODBC DSN: [SQL_ERROR]:[IM004][0][[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed]
I can't figure it out what the problem :
My LD_LIBRARY_PATH seem good.
Here is the odbc.ini :
Code:
[zoracle] AggregateSQLType = FLOAT Application Attributes = T Attributes = W BatchAutocommitMode = IfAllSuccessful BindAsFLOAT = F CacheBufferSize = 20 CloseCursor = F DisableDPM = F DisableMTS = T DisableRULEHint = T Driver = driver-zoracle DSN = zoracle EXECSchemaOpt = EXECSyntax = T Failover = T FailoverDelay = 10 FailoverRetryCount = 10 FetchBufferSize = 64000 ForceWCHAR = F LobPrefetchSize = 8192 Lobs = T Longs = T MaxLargeData = 0 MaxTokenSize = 8192 MetadataIdDefault = F QueryTimeout = T ResultSets = T ServerName = SQLGetData extensions = F SQLTranslateErrors = F StatementCache = F Translation DLL = Translation Option = 0 UseOCIDescribeAny = F UserID =
Code:
[driver-zoracle] Description = Oracle ODBC driver for Oracle 19 Driver = /usr/lib/oracle/19.6/client64//libsqora.so.19.1 Setup = FileUsage = CPTimeout = CPReuse =
I try with isql -v but i got the same error.
Did someone already see that, how to solve it ?
Thanks in advance for you reply
Best regards,