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

DB Monitoring stopped working after upgrade to 3.2

XMLWordPrintable

      I have some item which query an Oracle DB. After upgrading to 3.2 from 3.0 (no issues regarding my zabbix postgresql DB upgrade) I have found that my ODBC Item is not working anymore. I perform simple query against an Oracle (RAC) user table using odbc. the same sql using isql is working fine:
      One example of sql is the following:

      SELECT count (*),trunc(first_time) FROM v$loghist a where trunc( first_time)=trunc(sysdate) and THREAD# =1 group by trunc(first_time);
      

      This sql is used as item in db monitoring. Before upgrading it was working fine.
      Any advice?

      With Best Regards,

      Alessandro

        1. snapshot01.png
          16 kB
          Ruslan Eremenko
        2. ZBX-11213.patch
          2 kB
          Glebs Ivanovskis

            Unassigned Unassigned
            alessandro.mariotti@p-a.it Alessandro Mariotti
            Votes:
            6 Vote for this issue
            Watchers:
            29 Start watching this issue

              Created:
              Updated:
              Resolved: