Oracle Monitoring

Jeremy Russell Jeremy.Russell at chickasaw.net
Wed Apr 9 22:45:39 CEST 2003


There is no specific plugin for MS-SQL, but using something like the NSclient and snmp you could probably check to see if its at least running as a service, and then hit the tcp port to see if its active on the network.

These are the plugins that came with the Nagios-plugins 1.3.0 package.

Some have multifunctionality, so you can check almost anything with just these.
# ls ../libexec
README                         check_netapp.pl
apan.cgi                       check_nntp
check_adptraid.sh              check_nt
check_apache.pl                check_nt_load
check_apc_ups.pl               check_ntp
check_appletalk.pl             check_nwstat
check_backup.pl                check_nwstat.pl
check_bgpstate.pl              check_ora_table_space.pl
check_breeze                   check_oracle
check_breeze.pl                check_oracle_instance.pl
check_by_ssh                   check_overcr
check_citrix                   check_ping
check_compaq_insight.pl        check_pop
check_dig                      check_pop3.pl
check_digitemp.pl              check_procl.sh
check_disk                     check_procr.sh
check_disk_smb                 check_procs
check_disk_snmp.pl             check_qmailq.pl
check_dl_size.pl               check_real
check_dlswcircuit.pl           check_remote_nagios_status.pl
check_dns                      check_rpc
check_dns_random.pl            check_rrd_data.pl
check_dummy                    check_sap.sh
check_email_loop.pl            check_sensors
check_file_age.pl              check_smb.sh
check_flexlm                   check_smtp
check_flexlm.pl                check_snmp
check_ftp                      check_snmp_disk_monitor.pl
check_ftpget.pl                check_snmp_process_monitor.pl
check_hpjd                     check_sockets.pl
check_hprsc.pl                 check_ssh
check_http                     check_swap
check_ifoperstatus             check_tcp
check_ifstatus                 check_time
check_imap                     check_udp
check_inodes-freebsd.pl        check_unix_load
check_inodes.pl                check_ups
check_ircd                     check_users
check_javaproc.pl              check_vcs.pl
check_joy.sh                   check_vsz
check_ldap                     check_wave
check_linux_raid.pl            check_wave.pl
check_lmmon.pl                 check_wins.pl
check_load                     checkciscotemp.pl
check_log                      disk_by_snmp
check_log2.pl                  fetchlog
check_mailq                    generate.cgi
check_maxchannels.pl           maser-oracle.pl
check_maxwanstate.pl           mrtgext.pl
check_megaide                  nagios_sendim.pl
check_mem.pl                   negate
check_mrtg                     restrict.pl
check_mrtgtraf                 sched_downtime.pl
check_ms_spooler.pl            uptime_by_snmp
check_mysql                    urlize
check_mysql.pl                 urlize.pl
check_nagios                   utils.pm
check_nagios.pl                utils.sh
check_nagios_db.pl


We monitor around 50 servers and 200 services servicing 2500 users with it, not real big but big enough.  We use Cisco products for our hundreds of access layer equip, switches and routers, but Nagios for the services side.  Nagios has been very successful, the customization and configurability is what is most attractive.  I would like to see it in the future be integrated with or just built into a complete network/system management solution.  It has a very healthy start.

Jeremy Russell
Network Administrator, CNI
580-272-2707


-----Original Message-----
From: Rodrigo Comparini [mailto:rodrigocs at mailfarm.brasilis.com.br] 
Sent: Wednesday, April 09, 2003 3:34 PM
To: nagios-users at lists.sourceforge.net
Subject: Re: [Nagios-users] Oracle Monitoring

Jeremy,

Thank you for your help.

What about MS-SQL Server, is it possible to monitor Microsoft's Database ?

Also I would like to know:

1- Were can I find a detailed list about services/applications that can be
monitored using Nagios ?

2- Sucess cases of large companies using Nagios to monitor their
networks/servers environment !

I will really appreciate any kind of help.

Thanks in advance.

================================
Rodrigo Comparini de Sousa
Gerência de Sistemas Operacionais
COP - CTBC
================================
----- Original Message -----
From: "Jeremy Russell" <Jeremy.Russell at chickasaw.net>
To: "Rodrigo Comparini" <rodrigocs at mailfarm.brasilis.com.br>;
<nagios-users at lists.sourceforge.net>
Sent: Wednesday, April 09, 2003 4:57 PM
Subject: RE: [Nagios-users] Oracle Monitoring


The nagios-plugins package comes with a check_oracle plugin,  Not sure about
performance but it will check tables,  you probably can do some things you
want with it if you tweak it a bit..

 # ./check_oracle -h
check_oracle (nagios-plugins 1.3.0) 1.4
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>
  check_oracle --login <ORACLE_SID>
  check_oracle --cache <USER> <PASS> <INST> <CRITICAL> <WARNING>
  check_oracle --tablespace <USER> <PASS> <INST> <TABLESPACE> <CRITICAL>
<WARNING>
  check_oracle --oranames <Hostname>
  check_oracle --help
  check_oracle --version

Check remote or local TNS status and check local Database status

--tns=SID/IP Address
   Check remote TNS server
--db=SID
   Check local database (search /bin/ps for PMON process and check
   filesystem for sgadefORACLE_SID.dbf
--login=SID
   Attempt a dummy login and alert if not ORA-01017: invalid
username/password
--cache
   Check local database for library and buffer cache hit ratios
       --->  Requires Oracle user/password and SID  specified.
                --->  Requires select on v_ and v_
--tablespace
   Check local database for tablespace capacity in ORACLE_SID
       --->  Requires Oracle user/password specified.
                --->  Requires select on dba_data_files and dba_free_space
--oranames=Hostname
   Check remote Oracle Names server
--help
   Print this help screen
--version
   Print version and license information

If the plugin doesn't work, check that the ORACLE_HOME environment
variable is set, that ORACLE_HOME/bin is in your PATH, and the
tnsnames.ora file is locatable and is properly configured.

When checking Local Database status your ORACLE_SID is case sensitive.

Send email to nagios-users at lists.sourceforge.net if you have questions
regarding use of this software. To submit patches or suggest improvements,
send email to nagiosplug-devel at lists.sourceforge.net



Jeremy Russell
Network Administrator, CNI
580-272-2707

-----Original Message-----
From: Rodrigo Comparini [mailto:rodrigocs at mailfarm.brasilis.com.br]
Sent: Wednesday, April 09, 2003 2:43 PM
To: nagios-users at lists.sourceforge.net
Subject: [Nagios-users] Oracle Monitoring

Is it possible to monitor Oracle's performance/Objects using Nagios ?

Is there a plugin to do this ?

Thank you in advance !



================================
Rodrigo Comparini de Sousa
Gerência de Sistemas Operacionais
COP - CTBC
================================



-------------------------------------------------------
This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger 
for complex code. Debugging C/C++ programs can leave you feeling lost and 
disoriented. TotalView can help you find your way. Available on major UNIX 
and Linux platforms. Try it free. www.etnus.com
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null


-------------------------------------------------------
This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger 
for complex code. Debugging C/C++ programs can leave you feeling lost and 
disoriented. TotalView can help you find your way. Available on major UNIX 
and Linux platforms. Try it free. www.etnus.com
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null





More information about the Users mailing list