Sign in or 
Location: The Official Oracle Wiki
Discussion: Why companies are not using EM Grid Control
Category:
Discussion Forum /
General Discussion
Share this
porushh |
60. RE: Why companies are not using EM Grid Control
Aug 31 2008, 7:41 AM EDT
"We have several DBA teams - mostly siloed by environment (dev/test/prod), but there are some pockets of "shadow" DBA teams out there too. I say those guys are on their own :-)Sounds good mate. Do you find this valuable? |
|
suzannew |
61. RE: Why companies are not using EM Grid Control
Sep 2 2008, 1:09 PM EDT
I am running the old 9i OEM on my 9i databases and while the Tuning and Diagnostic packs are certainly helpful they are not required. The information I am looking for is the basic session information that is under the Instance option in the old database tree structure. That basic session information is only available with the Tuning pack in Grid Control (it is still free in the OEM 10g Console).
3
out of
3 found this valuable.
Do you?
|
|
mcpdba |
62. RE: Why companies are not using EM Grid Control
Jan 14 2009, 11:19 AM EST
I am new on Grid control. I have a question for you. My developer wants a readonly access to monitor performance and jobs. How can you give access...? what are the steps to create users roles and privilleges.?
Do you find this valuable?
|
irfanerp |
63. RE: Why companies are not using EM Grid Control
Jan 14 2009, 12:28 PM EST
Once you login to EM grid control, go to setup on the left hand side you have option of roles, create your role with necessary privileges on individual targets or system wide and then assign the same to the user.You can create users using the administrators tab with navigation same as above Do you find this valuable? |
|
porushh |
64. RE: Why companies are not using EM Grid Control
Jan 14 2009, 11:04 PM EST
"Once you login to EM grid control, go to setup on the left hand side you have option of roles, create your role with necessary privileges on individual targets or system wide and then assign the same to the user.Yes, there is full role-based security in Grid Control. You can create target groups and assign to admins (full access to all targets) and managers (read access), this is perfect for larger corporates with multiple database teams. Each team will only see their own targets. At the same time you can also have a read only user for the database login. Do you find this valuable? |
|
rparvu |
65. RE: Why companies are not using EM Grid Control
Jan 20 2009, 4:43 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 these products: Grid Control and Database Control are still quite difficult to troubleshoot when problems arise. So an efficient DBA would prefer sticking to the old proved tools rather than spending the time troubleshooting OEM. Example from of of our environments: minor db upgrade from 10.2.0.3 to 10.2.0.4 caused the OEM not to start anymore and could not completely fix it. Do you find this valuable? |
jedi294 |
66. RE: Why companies are not using EM Grid Control
Jan 26 2009, 10:49 AM EST
Are you talking about Grid Control or DBConsole? Grid Control works better than DBConsole in just about all aspects. We have had more problems with DBConsole and had to reconfigure it each time we ran into an issue. Using Grid Control has just about eliminated this problem (haven't moved production to it yet). With Grid Control, we have had more issues out of the agents before we upgraded then to 10.2.0.4 patchset. After the patch upgrade to the agents, it appears to be working just fine. As for other companies not moving to Grid Control, I would speculate that is has to do with the fact we are all humans and change is sometimes looked down upon as a bad and difficult issue. Before moving to Grid Control, ensure that a lot, and I mean a lot of reserach is done and how it can benefit the organization. Once the mountain of change has been climbed then the benefits of Grid Control can be seen. Overall, I would say Oracle should haved named it something else as well. Less confusion that way. Do you find this valuable? |
|
porushh |
67. RE: Why companies are not using EM Grid Control
Jan 27 2009, 2:23 AM EST
Jedi294, I am sure you will have a good experience when you use Grid Control in production. The potential for improving the DBA work-life is awesome - I have used it in production in major corporates and I have compared it to my pre-Grid Control days. For example, I used to take an hour or so to set up RMAN scripts on a new server, now, using Grid Control, I could setup and schedule an RMAN job on a new server in 5 to 10 minutes.I could also setup Dataguard standbys easily. Grid Control also now allows patching multiple databases using scheduled deployment procedures. Imagine the work-life improvements for DBAs. About the name, I think Grid Control is appropriate, since Oracle 10g and 11g are also "g" databases ie. for the Grid. So Grid Control is what controls the Grid. It is the best name possible. 1 out of 1 found this valuable. Do you? |
|
porushh |
68. How Telstra saved more than 2 million Aussie bucks using Grid Control
Feb 14 2009, 12:00 AM EST
Since 2004 to early 2006, I was involved with this project as the Senior Database Consultant in the Database Technologies team. We were the first in the world to use Oracle 10g Grid Control Release 1 in production (now on Release 4). Case study link: http://www.oracle.com/customers/snapshots/telstra-em-bbs-case-study.pdf A friend wrote: >Porus: Thank You. What Server Platform [Hardware/Software] Sun-Solaris, >Dell-Linux, HP-Linux, other. Are you able to disclose more detailed >architecture characteristics: number nodes, number instances/database, >load-balancing assignments, memory region allocations, etc We used HP-Red Hat Linux for all 32-bit servers. We had 3 management servers, with 4 CPUs each, and 8 GB RAM. We had 1 database server and 1 Dataguard standby server with the same configuration. We had a pair of Big-IP load balancers, one live, one standby. The load balancers handled the console requests as well as the agent uploads. This configuration was able to achieve the management and monitoring of more than 600 servers and databases at that time, and still growing. Scale-out possible by just adding more management servers and moving the database to RAC. The configuration was fully certified by Oracle who were working with us on-site since it was the first production Grid Control in the world. Another friend wrote: > Thanks - now only if we can convince our clients! Sure you can convince your clients. Just tell them how much automation Grid Control can achieve with its "manage many as one" philosophy. DBAs can achieve a lot more instead of being tied down with the nitty gritty. Do you find this valuable? |
|
bkberryman |
69. RE: Why companies are not using EM Grid Control
Mar 18 2009, 3:48 PM EDT
| Post edited: Mar 18 2009, 4:18 PM EDT
Part of the problem lies in one's inability to easily upgrade GC from one version to the next. Unfortunately, Oracle can't seem to figure out how to make a patch to go from OEM 10.2.0.3 to OEM 10.2.0.4. So you can't simply upgrade your GC, you need to start from scratch, go back to the base install and patch to 10.2.0.4. This is partly due to the fact that the App Server and Database product teams don't have coordinated release cycles, which has been a problem at Oracle for a very long time, and which they continually fail to address.Another problem with GC is the inability to create a simple custom report. Custom reports will only draw information from the repository contents, not from the actual targets you are monitoring. Bottom line: if the repository doesn't collect it, you can't build it into a report. To make matters worse, those built-in report elements (charts, graphs, etc.,) that you might wish to use in a custom report, can't be used unless you can figure out how to isolate the repository code that "builds" them and save it in a SQL file. A separate SQL file for each and every report element you want to use. Oracle does not provide them in the product as separate "building blocks" for you to build a report with. Which is too bad, because the code already exists, but it's a nightmare to find it, parse it out, save and organize it into something useful. But there seems to be a disincentive for them to make it more useful, because there's money to be made selling you a pricey consulting services engagement to "unlock" the power of custom reports... Do you find this valuable? |
|
porushh |
70. Use of EM Grid Control by companies
Mar 18 2009, 11:31 PM EDT
I just upgraded the OMS and the Agent (using the patch) from 10.2.0.4 to 10.2.0.5 and it went fine. So Oracle have now incorpated this upgrade facility in Grid Control. Regarding the reporting on the target database, you can put it as an enhancement request, we did so. Also, for yourr report building blocks idea, you can do likewise. Oracle is one of the companies that do look at customer enhancement requests. Do you find this valuable? |
