Oracle Monitoring

[Jeremy Russell]

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