Ad Widget

Collapse

Trying to make ODBC driver work for monitoring Oracle DB 11c

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • KeoMat
    Junior Member
    • Jan 2022
    • 1

    #1

    Trying to make ODBC driver work for monitoring Oracle DB 11c

    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 :
    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 =
    The odbcinst.ini :
    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,
Working...