[ZBX-11293] Monitor Database + Oracle Created: 2016 Sep 30  Updated: 2017 May 30  Resolved: 2016 Sep 30

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Incident report Priority: Major
Reporter: Marvin Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates ZBX-11213 DB Monitoring stopped working after u... Closed

 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


 Comments   
Comment by Glebs Ivanovskis (Inactive) [ 2016 Sep 30 ]

Closing as duplicate of ZBX-11213.

Comment by Marvin [ 2016 Sep 30 ]

thank you so much

Generated at Fri Apr 26 09:01:58 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.