We are using OEM currently on our Oracle environments. However, we have about 100 Sybase servers and about 10 Microsoft SQL Server servers in addition to the 20 or so Oracle instances we have. There are only 6 of us supporting all these environments, and not everybody is knowledgeable in all the dbms'. What we'd like to get is a proactive monitoring tool that can be used for all of our databases. If I could get OEM to monitor the others, I would!
-----Original Message----- Sent: Wednesday, December 05, 2001 7:35 PM To: Multiple recipients of list ORACLE-L I have evaluated I/Watch and it was pretty good. Especially with Spotlight. I have actually seen Spotlight help me quickly identify a problem which I am not sure I could have found so easily with out the visual picture. I had both tools for about 3 months but could not get anyone to agree to the bucks. Depending on what you are looking for out of OEM it really is not a bad tool. It is the one that is the least intrusive on your servers and you need not create objects in your database for it. Thing I learned though is to make sure you set up warnings for email and not page. Really annoying when you get paged at 3AM cause a tablespace is 80% full. Ya, so, tell me tomorrow. Make sure you do not have alert log monitoring on for development systems. If you do you may be tempted to kill your developers. It might not be the best tool out there but if you work with the right versions of Oracle and use the OEM agents for 8.1.7 or 9i its pretty good. It does not have those problems of not being able to deregister and all that fun stuff that existing in 8. Don't forget that the agents do not have be the same version as the database. -----Original Message----- WILLIAMS Sent: Wednesday, December 05, 2001 8:20 AM To: Multiple recipients of list ORACLE-L I appreciate everyone sharing their experiences. My question on this topic is what tools are appropriate for what environments? Some tools seem more extensive (and expensive) and therefore appropriate to sites with many Oracle instances. I am currently responsible for 5 production instances all at our HQ datacenter. On those rare occasions when something goes down, some usually quickly contacts me, so I haven't felt the need for a monitoring tool. However, we are discussing a project to put servers in a handful of manufacturing plants and they would be more 23x7 situations, so I have been reviewing OEM (it fails a lot more often than the instance, I'm not about to turn on its remote notification). Naturally vendors will claim that their product is just ideal for your type of site. Does anyone have any input on which monitoring tools are appropriate for sites with a smaller number of Oracle instances? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, December 05, 2001 6:40 AM To: Multiple recipients of list ORACLE-L I second that, too long to list the problems I had w/ CA Unicenter, worthless expensive product. CA touts their product to top management, then you get the call to implement. Just my $.02, since you asked :) Gene >>> [EMAIL PROTECTED] 12/04/01 08:35PM >>> CA Unicenter sucks, CA support sucks. CA sucks. Stay away. -----Original Message----- Sent: Tuesday, December 04, 2001 12:25 PM To: Multiple recipients of list ORACLE-L Hi - Does anyone have experience with either of these products? I'm interested in ease of installation, ease of use, and quality of support. I realize they are both pricey, but they both seem to do a lot. I've been asked to look at alternatives (I'm sure the cost will be prohibitive, but we'll see). Also if you know of any comparable tools, I'm very interested to hear about them. Thanks much - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
