We do use Nagios extensively and in combination with Orca (for trend analysis). Nagios Plugins does come with a plugin for oracle which can do some basic checks, but if you want to do more intensive monitoring you can easily write your own plugins (in Perl for example).
A (somewhat old) example package of what we use is available at http://users.tpg.com.au/lingent/proj/util/orca/install.html - it refers to Netsaint, which is what Nagios used to be called.
Cheers, Tony Around 11/09/2009 6:19 AM, Allen, Brandon said:
I think you might want to start with getting some more detail on exactly what your manager is looking for. In your quote from him, you said "manage" the databases, but in your subject you say "monitoring". OEM/Grid Control/DB Control/SQL*Plus work fine for /managing/ databases, and the first 3 are usually sufficient for /monitoring/ also if you have Diagnostics Pack licensed. If you don't have that, and you want to monitor and send alerts, your best bet is probably Nagios along with some custom scripts and/or some of the available plug-ins such as Monocle or those available here: http://www.monitoringexchange.org/cgi-bin/page.cgi?g=Check_Plugins%2FDatabase%2FOracle%2Findex.html;d=1Disclaimer: I've never used Nagios or Monocle, but I've heard lots of good things about Nagios on this list in the past (search the archives). I've only looked at Monocle briefly and it looks promising, but I haven't had time to actually implement it yet.I'm currently using custom scripts and HP OpenView to monitor my databases, but planning to switch to Nagios soon.Regards, Brandon------------------------------------------------------------------------Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
