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