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

Monitor Database + Oracle

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • None
    • None
    • None

      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
      

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

              Created:
              Updated:
              Resolved: