How to check for multiple Oracle tablespaces

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

How to check for multiple Oracle tablespaces

Post by dlukinski »

Hello XI Support

Stock Oracle wizard does not allow checking for multiple tablespaces from the same service (we have hundreds of those).
We how some old plugin (attached), but unsure how to specify server to connect.

So the question is how we could list/monitor/check all tablespaces from the same service without defining every single one of them?

Thank you
You do not have the required permissions to view the files attached to this post.
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: How to check for multiple Oracle tablespaces

Post by tmcdonald »

Can you please link us to where this was found? The original author might have some more information.

I see this one here, but it does not seem to match what you have attached in your post.

https://exchange.nagios.org/directory/P ... ce/details
Former Nagios employee
dlukinski
Posts: 1130
Joined: Tue Oct 06, 2015 9:42 am

Re: How to check for multiple Oracle tablespaces

Post by dlukinski »

tmcdonald wrote:Can you please link us to where this was found? The original author might have some more information.

I see this one here, but it does not seem to match what you have attached in your post.

https://exchange.nagios.org/directory/P ... ce/details
Sorry, here is the right one: https://exchange.nagios.org/directory/P ... es/details
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: How to check for multiple Oracle tablespaces

Post by rkennedy »

Over the CLI, please attempt to run the check. The instructions mention it being used like so -

Code: Select all

/usr/local/nagios/libexec/check_oracle_tablespaces database user1 password1 95 90
Can you attempt to run the above, and post the full input / output for us to see if you run into issues?
Former Nagios Employee
dlukinski
Posts: 1130
Joined: Tue Oct 06, 2015 9:42 am

Re: How to check for multiple Oracle tablespaces

Post by dlukinski »

rkennedy wrote:Over the CLI, please attempt to run the check. The instructions mention it being used like so -

Code: Select all

/usr/local/nagios/libexec/check_oracle_tablespaces database user1 password1 95 90
Can you attempt to run the above, and post the full input / output for us to see if you run into issues?
I think I misunderstand the concept
- should I run it from the client (host) with NRPE installed?
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: How to check for multiple Oracle tablespaces

Post by rkennedy »

dlukinski wrote:nderstand the concept
- should I run it from the client (host) with NRPE installed?
Yes. I would recommend getting it working on the client end, and then create the command for NRPE to use to execute.
Former Nagios Employee
dlukinski
Posts: 1130
Joined: Tue Oct 06, 2015 9:42 am

Re: How to check for multiple Oracle tablespaces

Post by dlukinski »

rkennedy wrote:
dlukinski wrote:nderstand the concept
- should I run it from the client (host) with NRPE installed?
Yes. I would recommend getting it working on the client end, and then create the command for NRPE to use to execute.
Please close this one.
Thank you
Locked