Page 1 of 2
Monitorng multiple Oracle instances on a single server
Posted: Tue Jan 31, 2017 2:48 pm
by 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.
Re: Monitorng multiple Oracle instances on a single server
Posted: Tue Jan 31, 2017 4:19 pm
by 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
Re: Monitorng multiple Oracle instances on a single server
Posted: Wed Feb 01, 2017 8:36 am
by SETR
Thank you, will look into the plugin you suggested and see if it works out for us.
Re: Monitorng multiple Oracle instances on a single server
Posted: Wed Feb 01, 2017 10:58 am
by rkennedy
Sounds good - I'll leave this open should you have further questions.
Re: Monitorng multiple Oracle instances on a single server
Posted: Wed Feb 01, 2017 2:13 pm
by 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.
Re: Monitorng multiple Oracle instances on a single server
Posted: Wed Feb 01, 2017 5:30 pm
by 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
Re: Monitorng multiple Oracle instances on a single server
Posted: Thu Feb 02, 2017 11:56 am
by 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.
Re: Monitorng multiple Oracle instances on a single server
Posted: Thu Feb 02, 2017 4:35 pm
by dwhitfield
Were you able to get this resolved in the quickstart?
Re: Monitorng multiple Oracle instances on a single server
Posted: Tue Feb 07, 2017 6:40 pm
by 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.
Re: Monitorng multiple Oracle instances on a single server
Posted: Tue Feb 07, 2017 7:30 pm
by 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?