Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-17314

Error: Cannot connect to ODBC DSN:[SQL_ERROR]:[01000][0][[unixODBC][Driver Manager]Can't open lib '/usr/lib/oracle/12.2/client64/lib/libsqora.so.12.1' : file not found]|

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • None
    • None

      I'm getting the following error from my Zabbix server:

      [root@ZabbixMonitor ~]# isql -v EX1
      [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/oracle/12.2/client64/lib/libsqora.so.12.1' : file not found
      [ISQL]ERROR: Could not SQLConnect

      I am trying to monitor oracle tablespaces through Zabbix, install oracle-instantclient-basic and odbc of oracle on the Zabbix server, I configured files /etc/odbcinst.ini and /etc/odbc.ini

      /etc/odbcinst.ini contains:

      [Oracle12c]
      Description = Oracle ODBC Driver
      Driver = /usr/lib/oracle/12.2/client64/lib/libsqora.so.12.1
      Trace = yes
      TraceFile = /var/log/odbcoracle
       
      [EX1]
      Driver = Oracle12c
      Servername = 172.xx.xx.xx:1521/EX1   "Server where is configured oracle database"
      Database = ED1
      Port = 1521
      UserID = EX1adm
      Password = xxxxx
      DatabaseCharacterSet = AL16UTF16
      

            edgar.akhmetshin Edgar Akhmetshin
            FreddPerez Freddy Alexander Perez
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: