Oracle Monitoring

[Thorsten Giese]

Hello there.

I am not in that lucky situation to have Oracle running on a Linux box nor a 
Unix box. I really would like to monitor that, not using ./check_tcp ... 
because it is a main server. 

Is there a plugin to monitor a remote located oracle running the listener? As 
far as I can see, the check_oracle only checks local databases. Or am I 
completly wrong? 

BTW: I experimented with --tns switch on that Host, but did not get any 
results. What does it (the switch) check exactly?

-- 
Viele Grüße
Thorsten Giese


Am Mittwoch, 9. April 2003 21:57 schrieb 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



-------------------------------------------------------
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