useful oracle checks

Hari Sekhon hpsekhon at googlemail.com
Mon Feb 26 11:55:10 CET 2007


I just "check_oracle --login dbname"since this tells me if the server is 
reachable, if the login prompt is given correctly and if there are any 
problems, they are raised with the ORA-xxxx error message so at all time 
I know what the exact condition or error of the database is.

-h

Hari Sekhon



Mestdagh Tommy wrote:
> Hi,
>  
> I need to monitor an oracle database ( on debian ).  I played with the 
>  "check_oracle --tns 127.0.0.1" over ssh
> And thats returns green ok !  So far so good. 
>  
> But what other checks are useful to do or even better like the --login 
> option or do need to check them all
> ... i'm not home at oracle stuff.
>  
> regards
>   Tommy
>  
> Usage:
>   check_oracle --tns <Oracle Sid or Hostname/IP address>
>   check_oracle --db <ORACLE_SID>
>   check_oracle --login <ORACLE_SID>
>   check_oracle --cache <ORACLE_SID> <USER> <PASS> <CRITICAL> <WARNING>
>   check_oracle --tablespace <ORACLE_SID> <USER> <PASS> <TABLESPACE> 
> <CRITICAL> <WARNING>
>   check_oracle --oranames <Hostname>
>   check_oracle --help
>   check_oracle --version
> Check Oracle 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
>  
>  
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20070226/d686ab80/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
-------------- next part --------------
_______________________________________________
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