Location: The Official Oracle Wiki

Discussion: Why companies are not using EM Grid ControlReported This is a featured thread

Showing 1 - 20 of 71  |  Show  posts at a time
2 3 4 | Next
arifgulzar@gmail.com
arifgulzar@gmail.com
Why companies are not using EM Grid Control
Nov 18 2007, 3:59 AM EST | Post edited: Nov 18 2007, 3:59 AM EST
What's the reason for not using EM Grid Control in most of companies....What's the solution to make it more popular for every day DBA tasks 38  out of 108 found this valuable. Do you?    

jokach
1. RE: Why companies are not using EM Grid Control
Nov 18 2007, 9:52 AM EST | Post edited: Nov 18 2007, 9:52 AM EST
"What's the reason for not using EM Grid Control in most of companies....What's the solution to make it more popular for every day DBA tasks"
I think part of the solution is letting DBAs know that its not that hard to setup and maintain EM Grid Control. It can look intimidating (both in setup and use) compared to previous versions of OEM (9i especially) .. its a very powerful tool, but with that power comes reluctance. I think it will continue to catch on, especially as more shops continue their upgrades to 10g and beyond....
3  out of 39 found this valuable. Do you?    

oracle_cult
2. RE: Why companies are not using EM Grid Control
Nov 19 2007, 1:25 AM EST | Post edited: Nov 19 2007, 1:25 AM EST
I think removing the word "Grid" from within the 'EM Grid Control' wil surely help a little bit. It is carries too much weight of concept of Grid, RAC and all the complexities that come to mind. 5  out of 39 found this valuable. Do you?    
chanmm
chanmm
3. RE: Why companies are not using EM Grid Control
Nov 19 2007, 7:41 AM EST | Post edited: Nov 19 2007, 7:41 AM EST
Correct me if I am wrong. 'Grid' Control is just the Java based console as the Oracle 9i EM. So it is not really hard to use I bet?

Ming Man
2  out of 38 found this valuable. Do you?    

tjmorris
4. RE: Why companies are not using EM Grid Control
Nov 19 2007, 2:49 PM EST | Post edited: Nov 19 2007, 2:49 PM EST
If you're keeping up with vulnerability patching, it's just another component to have to maintain at this point (agent), that's one drawback. I wonder if there isn't confusion about licensing a bit also...with all the various packs and such. 8  out of 38 found this valuable. Do you?    

manuel.hossfeld
5. RE: Why companies are not using EM Grid Control
Nov 20 2007, 12:55 PM EST | Post edited: Nov 20 2007, 12:55 PM EST
"Correct me if I am wrong. 'Grid' Control is just the Java based console as the Oracle 9i EM. "
I'm sorry to correct you, but indeed you're wrong:
The java-based console ("fat client") you're talking about is still available, but only for reasons of backward compatibility - it has nothing to do with Grid Control.
Beginning with 10g, Enterprise Manager (both Database Control and Grid Control) is a web application.

In any case... simply speaking you could say:
Grid Control = Enterprise Manager for several targets (DBs, Appserver, etc.) with a central repository and mgmt. server
(as opposed to Database Control = Management GUI for just one specific database instance - If you wish to compare that with the "pre-10g world", you could say that the relation between Grid Control and Database Control is the same as the one between 9i EM in a "full installation" [with OMS and repository] and 9i EM in "stand-alone" or "DBA studio" mode.)

I hope that clears the confusion a bit...
18  out of 46 found this valuable. Do you?    

vchandra.s
6. RE: Why companies are not using EM Grid Control
Nov 20 2007, 8:52 PM EST | Post edited: Nov 20 2007, 8:52 PM EST
The new Grid Control have lot of new features compared to previous version of 9i OMS.
We have experienced some issues with job sub system and reporting functionality of job output.

Though this hasn't stopped from using GC, there are number of other Reporting/Tuning/High Availability aspects of Grid Control which we are using real time to monitor Data Guard/RAC.

I recommend, if you have your manual scripts already in place continue using them also have GC in parallel till you feel comfortable yourself using GC that can do the Job.

8  out of 34 found this valuable. Do you?    

deucewildwood
7. RE: Why companies are not using EM Grid Control
Nov 21 2007, 1:18 PM EST | Post edited: Nov 21 2007, 1:18 PM EST
We have recently deployed agents on all of our development and production servers. Maybe it's lack of education on the Grid Control, but I've been dissappointed thus far how difficult it has been to do the fundamental things.

Two examples...just bringing up the session list in an instance...I found myself hunting all over the place and settling for a Top SQL report. Maybe someone will read this and tell me how easy it really is. The hierachical organization of tools like 9i OEM and even (dare I say) SQL Server Enterprise Manager, are so intuitive that any experienced DBA could sit down and be productive in 30 minutes. Not so with 10g (in my opinion).

Next on my list of dissappoinments is reporting. I was expecting to be able define a group of targets...define a report...and schedule that report to run against all targets in that group. That sounded to me like pretty basic functionality for something as robust of the Grid. Can't do it. I doubted my DBA and had him open an SR to confirm...which they did.

Hoping it gets better...I want to leverage this tool!
9  out of 36 found this valuable. Do you?    

l8on
8. RE: Why companies are not using EM Grid Control
Nov 21 2007, 3:09 PM EST | Post edited: Nov 21 2007, 3:09 PM EST
We currently use OMS for our 9i databases. Our databases are being upgraded to 10g and we're using DB Console for management. This is a bit tedious to manage since we're running 5 different 10g servers.
Hoping that EM GC will provide us with the ease of administration from a central interface just as OMS did.
We've attempted to install twice - once on Windows and then on Linux. Both failed...hope this doesn't prove to be a deterrent :(
4  out of 31 found this valuable. Do you?    
Jeepman
Jeepman
9. RE: Why companies are not using EM Grid Control
Nov 22 2007, 11:02 AM EST | Post edited: Nov 22 2007, 11:02 AM EST
After playing around with it, we found several issues:
1. It was almost impossible to install on AIX. We had several SR's opened with Oracle about the Java installer. We ended up putting it on Linux.
2. Performance. Oracle Application Server is a resource pig. You need at least 1GB of Ram and a Dual Core CPU to handle it.
3. In EM9i, we had a Low Archive Log Space event triggered an RMAN Backup job would clean out the directory. Even Oracle couldn't figure out how to create that in Grid Control.
4. Performance Manager. I liked the Dash Board look and the fact that you could set the refresh rate as low as 5 seconds. You can't do that in Grid Control. Oracle, Give it Back!!!!
5. The Tablespace Map Graphic in EM9i was killer. It was great to show non-Oracle people, how the extents were organized in a tablespace. Can I do that in Grid Control?

Overall, it's not a bad product for a first release. Oracle needs to clean it up though. Considering I've been an Oracle DBA since version 6.0.29, I'll take it over what I had then. We'll see what 11g brings to the table.

The Jeepman
6  out of 33 found this valuable. Do you?    

oracle11g
10. RE: Why companies are not using EM Grid Control
Nov 25 2007, 4:47 PM EST | Post edited: Nov 25 2007, 4:47 PM EST
Most large companies are based around project based work that brings in money not improving existing infrastructure (Which deploying Grid would come under), next most Large companies house DBA with the skill set to not need a GUI tool to there work, next therer are tools from other companies that can do simalar management to G-control, last but not leaset db-control comes free
4  out of 30 found this valuable. Do you?    
zlakhani
zlakhani
11. RE: Why companies are not using EM Grid Control
Nov 26 2007, 2:54 AM EST | Post edited: Nov 26 2007, 2:54 AM EST
The 10g version is also java based. 2  out of 24 found this valuable. Do you?    

pawarj@michigan.gov
12. RE: Why companies are not using EM Grid Control
Nov 26 2007, 12:08 PM EST | Post edited: Nov 26 2007, 12:08 PM EST
I think EM Grid control slow implemenation has various reasons
1. It is new product in itself and need lot of maintenance time to maintain Grid control database and application.
2. For secure database, people avoid to install Grid control on same servers and management doesnt buy the idea to buy exclusive server for EM grid control and its database.
3. Experienced DBAs feel confident to configure and fire maintenance scripts for this tool
4. EM grid control add cost to budget.
5. Other application servers, and non DBA admins already have their tools to maintain third party tools and servers.
3  out of 24 found this valuable. Do you?    
rhceib
rhceib
13. RE: Why companies are not using EM Grid Control
Nov 28 2007, 9:57 AM EST | Post edited: Nov 28 2007, 9:57 AM EST
EM Grid Control still has no support for Oracle Enterprise Linux 5 - not even an agent yet. 4  out of 25 found this valuable. Do you?    

kilroypr
14. RE: Why companies are not using EM Grid Control
Nov 28 2007, 10:37 AM EST | Post edited: Nov 28 2007, 10:37 AM EST
I deployed the server on AIX and it is working relatively stable. The issues that I see woit this version of OEM is that the navigation on the interface is not up to par to even SQL Server 2005. The reporting is too restrictive to get actual usefull information with it without recurring to sa custom report. In overall when I used the OEM 8 adn later migrated to OEM9i life was good, why the nice features of those version were not ported to this one? 2  out of 21 found this valuable. Do you?    

l8on
15. RE: Why companies are not using EM Grid Control
Nov 29 2007, 10:00 AM EST | Post edited: Nov 29 2007, 10:00 AM EST
"3. In EM9i, we had a Low Archive Log Space event triggered an RMAN Backup job would clean out the directory. Even Oracle couldn't figure out how to create that in Grid Control."
I wanted to accomplish the same thing in OEM 9i. I was able to create the event but not sure how to do the Fixit job.
1  out of 20 found this valuable. Do you?    
tomcatkev
tomcatkev
16. RE: Why companies are not using EM Grid Control
Nov 29 2007, 7:14 PM EST | Post edited: Nov 29 2007, 7:14 PM EST
The main problem we are not using EM Grid Control actively is that our Security department policy locks down all ports by default, and has been holding up opening the necessary ports to enable OEM monitoring agents. For many months now :-p

If I could configure everything over ssh port 22 using port forwarding or something it would make life easier.
2  out of 21 found this valuable. Do you?    
irfanerp
irfanerp
17. RE: Why companies are not using EM Grid Control
Nov 30 2007, 5:53 PM EST | Post edited: Nov 30 2007, 5:53 PM EST
Oracle EM GC is the best tool so far i have come across, it takes bit of time and has a fair amount of learning curve. But 9 months into it and I love it. Its rich in features, which tool gives u beacon for URL monitoring, SQL execution on multiple DBs , shutdown and startup of 90% datacentre / DBA targets automatically from one place.

We had crossed over 160 targets, did cut down few and now on 123 targets and it has increased productivity manyfolds. Earlier we had crons and Openview just for Prod targets, now with EM we are on top of all non prod env including hosts and fs as well.

Companies not using it could be few reason.

1) Resistance to change.
2) Resistance to Learning curve.
3) Cost / Technical Know How.

But once on it , they will love it. Guaranteed

For any assistance with GC , Do contact me and i will possibly try to answer.
5  out of 26 found this valuable. Do you?    
surachart
surachart
18. RE: Why companies are not using EM Grid Control
Dec 4 2007, 12:02 AM EST | Post edited: Dec 4 2007, 12:02 AM EST
I think It's OK. I have used to maintain many Database and Application.
It can help to generate report for the monitor.
However It's not stable and it' not easy to maintain, when i add something wrong, that want to modify.
2  out of 18 found this valuable. Do you?    

scdansie
19. RE: Why companies are not using EM Grid Control
Dec 5 2007, 5:15 PM EST | Post edited: Dec 5 2007, 5:15 PM EST
"3. In EM9i, we had a Low Archive Log Space event triggered an RMAN Backup job would clean out the directory. Even Oracle couldn't figure out how to create that in Grid Control."

I wanted to accomplish the same thing in OEM 9i. I was able to create the event but not sure how to do the Fixit job.
----------------
Define a "Corrective Action" in the Metrics and Policy settings for the metric that monitors the Archive Log Space. When the metric is triggered it can fire off an OS script to clean up the area. We have used this on several hosts with good results.
3  out of 20 found this valuable. Do you?    
2 3 4 | Next

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)