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