$ symbol is showing up in performance data for oracle query

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
mohan23
Posts: 118
Joined: Tue Oct 03, 2017 7:11 am

$ symbol is showing up in performance data for oracle query

Post 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.
User avatar
cdienger
Support Tech
Posts: 5045
Joined: Tue Feb 07, 2017 11:26 am

Re: $ symbol is showing up in performance data for oracle qu

Post 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.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
mohan23
Posts: 118
Joined: Tue Oct 03, 2017 7:11 am

Re: $ symbol is showing up in performance data for oracle qu

Post 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.
mohan23
Posts: 118
Joined: Tue Oct 03, 2017 7:11 am

Re: $ symbol is showing up in performance data for oracle qu

Post 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
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: $ symbol is showing up in performance data for oracle qu

Post by tmcdonald »

Did you have further (related) questions or are we good to lock this up?
Former Nagios employee
mohan23
Posts: 118
Joined: Tue Oct 03, 2017 7:11 am

Re: $ symbol is showing up in performance data for oracle qu

Post by mohan23 »

yeah.. we can lock this up. Thank you again
Locked