Friday, 21 October 2011

Can the Oracle DBA manage the Exadata machine?



AN FRANCISCO -- Oracle person in accuse Larry Ellison advertised this week that the financial gathering marketed 1,000 Exadata devices in the past year.
While it's set a lofty objective of marketing another 3,000 in the drawing close year, use instances and best practices are still arduous to draw close by in spite of the sheer amount of Oracle's buyer base.

A query for any governing body deeming the big-ticket database device is, who oversees it -- and what talents does an person employed need? Bundling concurrently storage, database, hardware and networking would look like to call for a large assortment of IT skills


At a session  for database administrators (DBAs) at OpenWorld, Arup Nanda, principal database architect for Starwood Hotels & Resorts Worldwide Inc., described that oversight of Exadata ought drop to a novel role, the database machine head (DMA), essentially a database head with a small proportion other skills.
"It's very difficult to direct across groups," he said. "You have to pinpoint a synergy of one ability set performing everything."
Nanda, an Oracle ACE, has installed an Exadata machine at Starwood and cracked down the abilities necessary for a DMA as follows:
  • System administration: 10%
  • Storage administration: 0%
  • Network administration: 5%
  • Database administration: 60%
  • Cell administration: 25%
Storage agencies is irrelevant because Exadata does not want traditional storage commands, he said. Storage is Exadata-specific and does not rely on the existing abilities of a traditional storage administrator. That's why Nanda set aside a separate ability set of cell administration. Additionally, the Linux abilities wanted are not typical Linux agencies and want simply a worse set of abilities to perform Exadata.

"Most of us, if not all of us, know a little Linux commands," Nanda said.
To manage Exadata, he said DMAs need to know storage commands like the CellCLI command line interface, database nodes commands like ASM commands SQL*Plus, standard database commands like, startup and\ alter database.
"The only thing you don't know today is CellCLI; everything else you probably know," he said. "The question is, can I be a master of that?"
Additionally, it calls for some server management skills.
Turning DBAs into DMAs
"It worked very well for us," Nanda said. "We coached DBAs in these precise aspects. Was it difficult? No. If we can perform it, so can you."
For those still anxious, Nanda proposed up some of the coaching he employed at Starwood. He bids coaching in Linux lead mastery and a four-part Exadata Command reference.
"If you put it all concurrently, the bulk is the DBA," Nanda said. "In my view it makes many of sense for the DBAs to make up the skill-set divergences to become the DMA."