[Nagios-users] useful oracle checks
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.phpp=sourceforgeCID=DEVDEV___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] useful oracle checks
I just check_oracle --login dbnamesince 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- 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.phpp=sourceforgeCID=DEVDEV ___ Nagios-users mailing list Nagios-users@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 - 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.phpp=sourceforgeCID=DEVDEV___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] useful oracle checks
I'm not sure how the tablespace check would work with auto-extending tablespaces if you use them. I'm curous about that myself. Anybody know? It doesn't work well. :) Because auto-extending tables tend to live n the edge of their available space, this check will almost always report the table is nearly full, making it pretty useless as an alerting tool. - 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.phpp=sourceforgeCID=DEVDEV ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] useful oracle checks
Phil Costelloe wrote: Jim Avery wrote: I confess I haven't used these yet myself (probably ought to though). The ones I would immediately pick are: check_oracle --tns Oracle Sid or Hostname/IP address and check_oracle --tablespace ORACLE_SID USER PASS TABLESPACE I probably wouldn't bother with most of the others on the principle that if I can't interrogate the tablespaces, I can't connect to the databases either. I'm not sure how the tablespace check would work with auto-extending tablespaces if you use them. I'm curous about that myself. Anybody know? I was too curious to wait. :) In the version of check_oracle shipped with plugins 1.4.3 (and I suspect later releases though I haven't checked), the tablespaces option will report on the usage of currently allocated extents. This is the same logic the Enterprise Manager GUI uses and the net effect for busy tablespaces which are set to auto extend is to make them look like they're permanently on the verge of being 100% full. I've got some SQL that I run as a cron job that takes into account the maximum possible size of the tablespace when it works out the fill percentage, I'll see if I can work it into the check_oracle script. Does anybody maintain it? I suspect it's orphaned at the moment. -- Phil Costelloe Foundation IT, Hermitage Berkshire RG18 9SE - 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.phpp=sourceforgeCID=DEVDEV ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] useful oracle checks
Jim Avery wrote: I confess I haven't used these yet myself (probably ought to though). The ones I would immediately pick are: check_oracle --tns Oracle Sid or Hostname/IP address and check_oracle --tablespace ORACLE_SID USER PASS TABLESPACE I probably wouldn't bother with most of the others on the principle that if I can't interrogate the tablespaces, I can't connect to the databases either. I'm not sure how the tablespace check would work with auto-extending tablespaces if you use them. I'm curous about that myself. Anybody know? -- Phil Costelloe Foundation IT, Hermitage Berkshire RG18 9SE - 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.phpp=sourceforgeCID=DEVDEV ___ Nagios-users mailing list Nagios-users@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