Oracle Monitoring

[Rodrigo Comparini]

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