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

Monitor Database + Oracle

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      I have Zabbix 3.2
      When I'm trying to get data from Oracle, instead of integers get unreadable characters
      X?P?U  `?`?`a X?

      select ceil(sum(df.BYTES)/1024/1024/1024) msize from dba_data_files df, dba_tablespaces ts where df.tablespace_name=ts.tablespace_name and ts.tablespace_name='SYSTEM' group by ts.tablespace_name

      But through isql -in all good

      SQL> select ceil(sum(df.BYTES)/1024/1024/1024) msize from dba_data_files df, dba_tablespaces ts where df.tablespace_name=ts.tablespace_name and ts.tablespace_name='SYSTEM' group by ts.tablespace_name
      +-----------------------------------------+
      | MSIZE                                   |
      +-----------------------------------------+
      | 12                                      |
      +-----------------------------------------+
      SQLRowCount returns -1
      1 rows fetched
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              dm1987 Marvin
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: