Page 1 of 1
$ symbol is showing up in performance data for oracle query
Posted: Mon Jun 11, 2018 1:01 am
by mohan23
Hello,
I'm using check_oracle_health plugin to monitor oracle metrics and i see graphs are getting generated for table space metrics and i dont see rrd files are not getting generated and i see $ symbol is being added in performance data as shown below.
Performance Data: 'select'=4.390000;80;90$.
Can someone help me fix this to generate graph for this.
Re: $ symbol is showing up in performance data for oracle qu
Posted: Mon Jun 11, 2018 10:16 am
by cdienger
What version of check_oracle_health is being used(run /usr/local/nagios/libexeccheck_oracle_health --version to check)? What options are being run with it and are you seeing the output on the command line or somewhere in the web UI? Have you tried running it as root on the command line? The latest version is 3.1.2.1 and can be downloaded at
https://labs.consol.de/nagios/check_ora ... l#download if needed.
Re: $ symbol is showing up in performance data for oracle qu
Posted: Tue Jun 12, 2018 3:39 am
by mohan23
Here is the version details.
check_oracle_health (1.7.3)
This nagios plugin comes with ABSOLUTELY NO WARRANTY. You may redistribute
copies of this plugin under the terms of the GNU General Public License.
From command line , I'm seeing output and performance data correctly, I'm seeing this $ symbol from Nagios xi web console.
Re: $ symbol is showing up in performance data for oracle qu
Posted: Tue Jun 12, 2018 9:09 am
by mohan23
sorry , Issue got fixed and its issue with query that we are polling. Query have $ symbol which is appending to performance data . I have modified to $"$" from $ in my query, Its working fine and graph is also getting generated. Anyway Thanks for your quick inputs
Re: $ symbol is showing up in performance data for oracle qu
Posted: Tue Jun 12, 2018 11:22 am
by tmcdonald
Did you have further (related) questions or are we good to lock this up?
Re: $ symbol is showing up in performance data for oracle qu
Posted: Wed Jun 13, 2018 3:36 am
by mohan23
yeah.. we can lock this up. Thank you again