[ale] OT: Oracle Monitoring Tools

[Sid Lane]

sorry, I did not mean for that to come across as condescending as it may
have - I was just trying to help save them from wasting a bunch of $$$.

my current employer spent almost $200K on OEM plugg-ins a couple of months
before hiring me and the (then) CTO was RPO'd when I told him I didn't need
it and wasn't going to use it (go figure).

just trying to save others from making similar mistakes...

that being said, OEM does give novices point/click GUI access to a myriad of
things they should not even know exist w/o understanding what they do/mean &
possible consequences.  I had a director at a consulting firm before here
that said:  "if you don't know how to do it with a shell, vi & sqlplus you
aren't qualified to do it".  luckily I'm a bit more progressive - I've
accepted/added PERL/DBI to the list...  :-P

On 8/9/06, Jeff Lightner <jlightner at water.com> wrote:
>
>  Of course some people doing monitoring are not DBAs self respecting or
> otherwise.  In many organizations the monitors are required by management
> and managed by System Admins.
>
>
>
> Here we do Nagios monitoring from a Management standpoint but it's fairly
> minimal.  Just check whether tnsping to the instance works from another
> server, whether the LSRN and PMON are up and whether concurrent manager is
> running.   The DBAs here (presumably self respecting ? I've never asked) of
> course have additional monitoring they've configured.
>
>
>
> So the question becomes how deeply are you trying to "monitor" the DB?
>
>
>
> In other environments I've used Patrol which has prebuilt probes for
> Oracle and other products.   However it is not cheap either.
>
>
>  ------------------------------
>
> *From:* ale-bounces at ale.org [mailto:ale-bounces at ale.org] *On Behalf Of *Sid
> Lane
> *Sent:* Wednesday, August 09, 2006 11:03 AM
> *To:* Atlanta Linux Enthusiasts
> *Subject:* Re: [ale] OT: Oracle Monitoring Tools
>
>
>
> "license for the monitoring package of EM is a bit steep"
>
> it's also a steaming piece of poo - no self respecting DBA uses it.  there
> is NO substitute for knowing your data dictionary, v$ views, etc.
>
> I've written my own stuff with PERL (/DBI), etc.
>
> if you want something "canned" I'm pretty sure Big Brother has some Oracle
> plugins but I don't know how robust they are though it's pretty easy to
> write your own modules and hook them in.
>
> On 8/8/06, *Ryan Fish* <FishR at bellsouth.net> wrote:
>
> Do any of you know of any cheap/free monitoring tools for Oracle?  The
> license for the monitoring package of EM is a bit steep so I'm looking for
> alternatives if they exist.
>
>
>
> Thank you.
>
> -Ryan
>
>
>
> I tried sending this same message earlier but it never hit the list for
> some reason?
>
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
>
>
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
>
>
-------------- next part --------------
An HTML attachment was scrubbed...