Real DBAs use Grid Control…

Hopefully the title got your attention. Of course it could have read, “Real Linux Sysadmins use Cobbler and Puppet…”, or any number of comparable statements and products. The point being, there is a gradual evolution in the way we approach tasks and if we don’t move with them we marginalize ourselves to the point where we are so unproductive we cease to be of use.

A few years ago I was doing a lot of Linux installations and I got sick of running around with CDs, so started doing network installations to save time. I’ve been doing loads of installs on VMs at home recently, so I started doing PXE Network Installations, which saved me even more time. As a result of the article I wrote about that, Frits Hoogland pointed me in the direction of Cobbler, which makes PXE installations real easy (once you get to grips with it). I’m not a sysadmin, so why do I care? Even when I’m installing and running a handful of VMs at home I can see productivity gains by using some of these tools. Imagine the impact in a data-center!

So back to Grid Control. Does anyone remember the days when you kept a “tail -f” on your alert log? At one site I used to have a CDE workspace on an X station just running tails. Then the number of instances got too big, so I used to scan through the alert logs each day to look for issues. The next step was to use shell scripts to check for errors and mail me. This was a pain at one site where I was using Solaris, HP-UX and Windows, which meant I needed three solutions. Then the Oracle 9i Enterprise Manager with the Management Server came into my life. All of a sudden it could manage my alert logs and I could assume everything was fine ( 🙂 ) unless I got a notification email. This feature alone sold me on the 9i management server.

Back then, being a DBA and admitting using Enterprise Manager was a little like announcing to the world you were into cross dressing. 🙂 Time has moved on, the product name has changed and so has its functionality, but essentially it’s still doing the same thing, which is reducing the effort needed to manage databases (and other things). The difference is that rather than managing 40 instances, teams are now managing thousands of instances.

Of course, none of this is new. I guess it’s just been brought into focus by a few things that have happened to me recently, like the PXE/Cobbler thing, the recent demise of my Grid Control VM at home and the constant talk of cloud computing and SaaS etc.

Specialists and performance consultants have the time to obsess over minute detail. The day-to-day DBAs and sysadmins have to churn through work at a pace, with reliable and reproducible results. Failing to embrace tools, whatever they are, to aid this is career suicide.



Author: Tim...

DBA, Developer, Author, Trainer.

9 thoughts on “Real DBAs use Grid Control…”

  1. Tim… (always wanted to start a comment like that, reminds me of little Bobby Tables) er anyway. I entirely agree, which is why my last 2 presentations have been about using tools to automate the mind numbing stuff and to free the DBA up to do the hard value-add stuff.

    I do feel duty bound to mention though that you can’t use Grid Control itself to email you without paying extra for the diagnostic pack license. Madness.

  2. ah, and I can’t edit comments. You used to be able to email yourself in 9i of course – not to mention use at least some of Enterprise Manager’s performance tools without extra cost. Kind of a downgrade.

  3. Hi.

    Yeah. Licensing is a real bummer. 🙂

    I guess it all comes down to return on investment. If a company can see the saving associated with automation, selling it as a concept is a lot easier.

    By the time Oracle 13 comes out, all this will be part of standard edition and there will be some new thing we can’t afford to use. 🙂



  4. I’ve found those tools great to manage things like profiles, jobs and a few others.

    Absolute murder to setup/maintain from the command line, even on a single instance!

    Mind you: have you tried to install grid from scratch on anything other than Leenooks?

    An exercise in patience…

  5. I think of most of the app server-related stuff as Linux-only products. They all seem to install easier and work more reliably on Linux.



  6. The 9i enterprise manager felt like the candy house of the witch to me. It really looked well (yummy) when it appeared. Later, when we did set it up in an enterprise environment (100+ databases) we encountered some really ridiculous bugs. Like you needed to register all objects again after adding a new administrator, otherwise the new admin wouldn’t see anything. Or inserting an event internally even if you did say you didn’t want any event (which resulted in OEM stopping to function after reaching more than events)

    Anyways. I think Oracle DBA’s will enter the world of linux administration more and more. With Oracle Enterprise Linux, the box says ‘Oracle’, so the DBA must administer, just like we’ve seen with the application server.

    I don’t know what that will result in. After all, walking over a bridge for more than 10 years doesn’t mean you are able to build it. It sometimes seems like DBA’s must (and think) they can administer linux/unix because they’ve used it for a long time.

    Oh, Tim, have a look at splunk (I didn’t come up with the name): It can be used for free up to a certain amount of data. Again, this is silly for use with on-laptop VM’s, but quickly makes sense in corporate environments.

Comments are closed.