Adding a RAC Node with “One-Click” in Gird Control?
Published by Alex Gorbachev 6 months, 3 weeks ago in OracleTags: .
Just saw this this blog post and even spent 10 minutes watching the video demo.
In under one hour and could be as low as 30 minutes!?
Right… Assuming all your nodes and environments are absolutely identical. Otherwise, you spend hours and hours or rather days debugging and troubleshooting failures. Unless you are a large ASP, or something on that scale, there is very low chance you have your nodes fully standardized. I know few companies that do to some significant extent but those are very rare.
I’d love to see how “easy” it is to recover from a failure during one of “One-Click” procedures. My best bet is to clean up the mess (which is, I bet, not automated) and start from scratch. Perhaps, you could try to “Create Like” and start from failure if that’s possible but that’s far from simple “One-Click” scenario anyway.
But this is nothing. What is usually forgotten is how much efforts and time is needed to prepare the new host BEFORE this “One-Click” procedure can run like proper storage and network configuration.
Why do I write all this? Don’t take me wrong - I like Oracle taking measures to automate complex processes but reality is still far from it. I’d rather have Oracle simplifying the processes and write more reliable management tools.
What should I answer my client questioning my estimate of efforts to add a new cluster node after this presentation?
- “Even a rookie DBA can click few times in OEM to set it up in one hour. Why should it take you, a Senior DBA, a day?”
I never actually tried these “One-Click” procedures in real life and I’d love someone to prove me wrong. Please?
PS: Before hitting sent button, I closed my eyes and imagined the response of Oracle support on the SR I would open upon failure of one of those “One-Click” procedure…
See also:
Ha, sounds like another Reality Gap
Right. Looking forward for a more substantial post from you then!
can anyone help on this topic
on oracle EM I have this info
Status Up
Up Since Mar 5, 2008 2:29:58 PM MST
Availability (%) 100 ( Last 24 hours )
Instance Name ariel1
Version 10.2.0.3.0
Read Only No
Oracle Home /opt/oracle/product/10.2.0/db3
Host wplnx510
Listener LISTENER_WPLNX510_wplnx510
ASM ASM1_wplnx510
this is URL :…/em/console/database/instance/instanceProperties?event=doLoad&target=ariel_ariel1&type=oracle_database
so I am looking at this XML oracle_database.xml and can not find anything related
I saw some on Alex’s papers how to add MySQL to Oracle EM that why I am asking on the blog. pardon me if this is not related
skhochay,
I’m not sure what problem you are trying to describe and what you are looking for in the XML file. Could you be more specific?
Alex
I am lookin for API fo OEM so I can create my custome pages
You can’t arbitrary create your own pages bug depending what your requirements are you might be interesting in one of the following:
- create reports
- create dashboards
- create User Defined Metrics
- create new management plug-ins
The latter is part of OEM extensibility framework. I have finally released MySQL plug-in for Grid Control, for example.
Yes Alex. I was looking at your MySQL plug-in and that how I found your blog. I am looking to
enhance OEM not so much but only a pointer to external site and metadata about the same db…
for example I have db where I am keeping WO log for each db. so I was thinking if I can add a link look at
my example pictures. http://picasaweb.google.com/skhochay/OEM/photo#5195506655021272674
-thank Sergey
Sergey,
You cannot customize the home page of an existing standard target type.
There is a way to add related links to your new target but not to the standard oracle instance home-page. Well, not that I’m aware of.
You might be able to fiddle with oracle xml definition files but then you are definitely on your own and no support from Oracle - see Adding Related Links to Target Home Pages.
thank you