Friday, April 06, 2007

Nagios and Oracle

Running a Oracle database in a production environment can be a relieve or can be a hassle. You can make it a relieve by monitoring your systems in a good way so you will be notified before a problem becomes a big problem. This can make your life as a Oracle DBA or system administrator a lot easier.

You will also be able to guarantee a higher business continuity meaning that the employees can continue work because the DBA’s and system administrators have a better view of upcoming problems and will be able to solve those problems before they become a thread to business continuity.

In this post I like point out to 3 new Nagios Oracle scripts.

One will check the oracle instance on number of users, table spaces, possible ORA messages will be send to Nagios so you will be able to view from your Nagios web application or it can be mailed or even send via SMS to you. Thanks to Sven Dolderer for this script written in Perl. You can download check_oracle_instance.pl from my website.

You can also download check_oracle_status.sh a shell script written by latigid010@yahoo.com and check_ora_table_space.pl a perl script written by Erwan Arzur.

Post a Comment