Date: Thu, 10 Sep 2009 13:19:47 -0700
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=1
Disclaimer: 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.
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. Received on Thu Sep 10 2009 - 15:19:47 CDT