RE: Oracle Free Monitoring link
- From: "Pakhutkin, Maxim (Max)" <maxim.pakhutkin@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 15 Jul 2005 13:41:55 -0400
10g Grid Control (OEM) won't connect to a pre-8i database (at least for me):
Failed to connect to database: ORA-03134: Connections to this server version
are no longer supported. (DBD ERROR: OCISessionBegin).
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT
<http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=297437.1>
&p_id=297437.1
"unfeasible to fix"
Personally I haven't had any major trouble with 10.1.0.4 Grid Control
monitoring 129 targets (82 of them are databases, only 2 are pre-8i) yet. I
wouldn't characterize it the way Rich did, at this point. Certainly less
resource-intensive than Spotlight, from my experience. There are a few bugs
that I've encountered, but they were not major, except for occasional
deadlocks. Nothing so far that would prevent us from using it in production in
addition to our current 3 monitoring scripts (can't beat the reliability of a
simple dbms_job script). Test reorgs via OEM had some glitches, but I would
never trust a tool to do something like that for me anyway, was just curious
how it did it. Plus we almost never do reorgs here.
Generally I'm very impressed with the tool. Very sound design. Can't really
compare with any one of Quest tools on an equal basis though, as OEM covers so
much more than any one individual Quest tool. We have licensed the whole Quest
suite here, but are considering stopping paying for support and upgrades, which
is why we deployed OEM in test. Some of the DBAs here haven't touched a Quest
tool (other than Toad) in months now.
Basically, if you know your databases well, you don't need a monitoring tool,
in my opinion, only basic homegrown "is it up or down?", "any errors in the
alert log?" and "how are we doing on space?" scripts. Which is what we use here
in production for monitoring. OEM just gives a nice centralized view of all the
monitoring targets, with some quite relevant data collected. I find the
performance monitoring features of OEM generally more useful than Spotlight's.
The repository is not too greedy on space: with default metric collection
settings and 129 targets the repository has stabilized at 3G in size. I don't
expect having to bring the thing down for maintenance more often than once a
quarter.
Of course, the more databases you have to monitor, the higher the payoff of
deploying OEM. If I only had 10 monitoring targets to monitor I would probably
be less impressed or more frustrated with OEM.
Max Pakhutkin
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Jesse, Rich
Sent: Friday, July 15, 2005 12:20 PM
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle Free Monitoring link
Unreliable, unstable, resource intensive, very difficult to install and
maintain (OEM 10g Grid Control), lesser level of support via MetaLink (my
observation)...
Need I go on as to why not OEM?
I do use Spotlight occasionally and I like it, but I don't think it's
necessarily a good tool to have running all the time, depending on your DBs.
There's also a free version of the web-based Big Brother (now also owned by
Quest) available at http://bb4.org , but I haven't used it in a while.
And if I ever get back to writing my Perl/tk Oracle monitor, now defunct for
over a year, there'll be another... ;)
Rich
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of rjamya
Sent: Friday, July 15, 2005 10:29 AM
To: smishra_97@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle Free Monitoring link
TORA for linux ... it is basic but free ... why not OEM?
Raj
On 7/15/05, Sanjay Mishra < smishra_97@xxxxxxxxx> wrote:
HI
I am looking for any tool that can be used to provide some graphical output for
Oracle monitoring. Is there any URL where I can download and configure to
monitor some of the Oracle / other database which can provide graphical
interface.
Thanks
Sanjay
Other related posts:
