Monitorng multiple Oracle instances on a single server

[SETR]

Is there a way to monitor multiple oracle databases residing on a single server using NagiosXI? We have about 100 Redhat Linux servers and each server hosts anywhere between 5 -15 databases. All we are looking for is to make sure the database is up and running and if possible monitor the tablespace size. We looked into some of the in-built Oracle database wizards NagiosXi provided but the wizard supports only one SID and it will be really time consuming to run the wizard for all our databases. Also, we would like to avoid installing any npre agents on the Database server to achieve this.

Any recommendation is really appreciated.

[rkennedy]

I don't have an Oracle database here to test with, but you should be able to use --tns and --db to specify the parameters.

Code: Select all

[root@centos7 libexec]# ./check_oracle --help
check_oracle v2.0.3 (nagios-plugins 2.0.3)
The nagios plugins come with ABSOLUTELY NO WARRANTY. You may redistribute
copies of the plugins under the terms of the GNU General Public License.
For more information about these matters, see the file named COPYING.

Usage:
  check_oracle --tns <Oracle Sid or Hostname/IP address>
  check_oracle --db <ORACLE_SID>

If most of your services will be the same between DB hosts, then you could look at using hostgroups / templates to add things easier in your system, and add further control.

I don't believe NRPE is required by this plugin by default - some other ones may though for the information you're after. Take a look here for other options - https://exchange.nagios.org/index.php?o ... ord=oracle

[SETR]

Thank you, will look into the plugin you suggested and see if it works out for us.

[rkennedy]

Sounds good - I'll leave this open should you have further questions.

[SETR]

Is there a way to bulk upload IP, SID and Port and may be use a template to add all database servers? I was able to setup all the services I would like to monitor for a database server.

[avandemore]

Bulk upload into what? We have a bulk modification tool if that's what you are interested in.

https://assets.nagios.com/presentations ... ios_XI.pdf

[SETR]

Bulk upload into Nagios to monitor. Unfortunately the default bulk upload tool will not work for Oracle databases as it does not have an option to specify SID and Port number which is required by the Oracle plugins available in Nagios.

[dwhitfield]

Also, have you set up a 1-hour quickstart session? https://www.nagios.com/services/quickstart/, Yes, I have one setup for this coming Thursday

Were you able to get this resolved in the quickstart?

[SETR]

To some extent yes, looks like we would have to use either command line or macros.The rep we had the quick start session with said he is going to send us some documents to go through. Hopefully, we will be able to come with a way to bulk upload databases.

[SETR]

Is there any way to modify the oracle serverspace wizard to accept multiple IP's and SID's just like the bulk import wizard does?