check_oracle_health does not work as provided

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
dlukinski
Posts: 1130
Joined: Tue Oct 06, 2015 9:42 am

Re: check_oracle_health does not work as provided

Post by dlukinski »

rkennedy wrote:Where are you seeing an incomplete $ARG5$ and $ARG6$?
- my mistake, not that
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: check_oracle_health does not work as provided

Post by rkennedy »

Can you try putting it in double quotes rather than single? It could be the special characters that are causing an issue (:/).
Former Nagios Employee
dlukinski
Posts: 1130
Joined: Tue Oct 06, 2015 9:42 am

Re: check_oracle_health does not work as provided

Post by dlukinski »

rkennedy wrote:Can you try putting it in double quotes rather than single? It could be the special characters that are causing an issue (:/).
Still not working :-(
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: check_oracle_health does not work as provided

Post by lmiltchev »

Since this is working from the CLI,
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 /usr/local/nagios/libexec/check_oracle_health --connect='10.102.35.237:1532/KCTCQA.konecranes.com' --username=nagiosxi ­­--password=KsaXer3587 ­­--mode=rman-backup-problems --warning 1 --critical 2
you can try modifying your "check_oracle_health" command and your service in a way that you would pass:

Code: Select all

'10.102.35.237:1532/KCTCQA.konecranes.com'
as one piece to $ARG1$, wrapped in single quotes. See example below:
example01.PNG
Save, and apply configuration. Don't test from the CCM. Click on the service under the "Service Detail" page, schedule an immediate forced check, and see if you will get the expected output.
You do not have the required permissions to view the files attached to this post.
Be sure to check out our Knowledgebase for helpful articles and solutions!
dlukinski
Posts: 1130
Joined: Tue Oct 06, 2015 9:42 am

Re: check_oracle_health does not work as provided

Post by dlukinski »

lmiltchev wrote:Since this is working from the CLI,
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 /usr/local/nagios/libexec/check_oracle_health --connect='10.102.35.237:1532/KCTCQA.konecranes.com' --username=nagiosxi ­­--password=KsaXer3587 ­­--mode=rman-backup-problems --warning 1 --critical 2
you can try modifying your "check_oracle_health" command and your service in a way that you would pass:

Code: Select all

'10.102.35.237:1532/KCTCQA.konecranes.com'
as one piece to $ARG1$, wrapped in single quotes. See example below:
example01.PNG
Save, and apply configuration. Don't test from the CCM. Click on the service under the "Service Detail" page, schedule an immediate forced check, and see if you will get the expected output.
Not working
This does not help our troubles with NAGIOS Oracle checks: we have to be able to manage single check for multiple hosts (and multiple tablespaces)
- essentially our Oracle admin would NOT consider NAGIOS if we cannot do that. (talking about hundreds tablespaces)
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: check_oracle_health does not work as provided

Post by rkennedy »

Can you try moving everything to $ARG1$ and go from there?

The next option, is going to be using the resource.cfg, and seeing the variable to a $USER#$ variable. See this link for more of an explanation - https://assets.nagios.com/downloads/nag ... Macros.pdf
Former Nagios Employee
dlukinski
Posts: 1130
Joined: Tue Oct 06, 2015 9:42 am

Re: check_oracle_health does not work as provided

Post by dlukinski »

rkennedy wrote:Where are you seeing an incomplete $ARG5$ and $ARG6$?
Please close this support thread

Thank you
Locked