arrowecs sora io#102936 tipguide2 031212
TRANSCRIPT
-
7/23/2019 ArrowECS SORA IO#102936 TipGuide2 031212
1/5
Can the DBA manage the
Exadata machine?
-
7/23/2019 ArrowECS SORA IO#102936 TipGuide2 031212
2/5
Page 2 of 5 Sponsored by
Can the DBA manage the Exadata machine
Contents
Can the DBA manage
the Exadata machine?
Oracle's push to bundle its database, storage andhardware together presents a quandary for prospective
buyers. A question for any organization considering the big-
ticket database machine is, who oversees it -- and what skills
does an employee need? Bundling together storage,
database, hardware and networking would seem to call for a
wide range of IT skills. In this expert Tip-Guide, find out who
should manage Exadata and why the answer isnt so cut-
and-dry.
Can the DBA manage the Exadata machine?By: Barney Beal, News Director
SAN FRANCISCO -- Oracle chairman Larry Ellison announced this week that
the company sold 1,000 Exadata machines in the past year.
While it's set a lofty goal of selling another 3,000 in the coming year, use
cases and best practices are still difficult to come by despite the sheer size of
Oracle's customer base.
A question for any organization considering the big-ticket database machine
is, who oversees it -- and what skills does an employee need? Bundling
together storage, database, hardware and networking would seem to call for
a wide range of IT skills.
"What really scares most of us -- and to be honest, me particularly -- is
network management,"
Arup Nanda, principal database architect for Starwood Hotels & Resorts
Worldwide Inc.
At a session for database administrators (DBAs) at OpenWorld, Arup Nanda,
principal database architect for Starwood Hotels & Resorts Worldwide Inc.,
explained that oversight of Exadata should fall to a new role, the database
-
7/23/2019 ArrowECS SORA IO#102936 TipGuide2 031212
3/5
Page 3 of 5 Sponsored by
Can the DBA manage the Exadata machine
Contents
Can the DBA manage
the Exadata machine?
machine administrator (DMA), essentially a database administrator with afew additional skills.
"It's very difficult to coordinate across groups," he said. "You have to find a
synergy of one skill set managing everything."
Nanda, an Oracle ACE, has installed an Exadata machine at Starwood and
broke down the skills necessary for a DMA as follows:
System administration: 10%
Storage administration: 0%
Network administration: 5%
Database administration: 60%
Cell administration: 25%
Storage administration is irrelevant because Exadata does not require
traditional storage commands, he said. Storage is Exadata-specific and does
not rely on the existing skills of a traditional storage administrator. That's why
Nanda set aside a separate skill set of cell administration. Additionally, the
Linux skills required are not typical Linux administration and require only asmaller set of skills to manage 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.
-
7/23/2019 ArrowECS SORA IO#102936 TipGuide2 031212
4/5
Page 4 of 5 Sponsored by
Can the DBA manage the Exadata machine
Contents
Can the DBA manage
the Exadata machine?
"Most of you have not done server management," Nanda told attendees athis DBA session. "But in server administration what you have to do is simple
commands. Once in a while you'll get a patch from Oracle. That's a skill you
probably nev
er had to apply in the past. In DMA you have to know that. How much? Very
little."
The same goes for network management, but since Exadata uses switched
fabric communications link InfiniBand, the networking angle is different --
and simpler, according to Nanda.
"What really scares most of us -- and to be honest, me particularly -- isnetwork management," he said. "Fortunately, Oracle provides tools to
manage this. It's designed for only one domain, Exadata. It's not for the
entire operation. Its scope is only in the Exadata box itself."
In fact, according to Nanda, all the tools a DMA needs for network support
can be found at Ora/opt/oracle.SupportTools. And the Exadata product
manager promises more to come, Nanda added.
Turning DBAs into DMAs
"It worked very well for us," Nanda said. "We trained DBAs in these specific
aspects. Was it difficult? No. If we can do it, so can you."
For those still worried, Nanda offered up some of the training he used at
Starwood. He offers training in Linux command mastery and a four-part
Exadata Command reference.
"If you put it all together, the bulk is the DBA," Nanda said. "In my opinion it
makes a lot of sense for the DBAs to make up the skill-set differences to
become the DMA."
-
7/23/2019 ArrowECS SORA IO#102936 TipGuide2 031212
5/5
Page 5 of 5 Sponsored by
Can the DBA manage the Exadata machine
Contents
Can the DBA manage
the Exadata machine?
Free resources for technology professionalsTechTarget publishes targeted technology media that address your need for
information and resources for researching products, developing strategy and
making cost-effective purchase decisions. Our network of technology-specific
Web sites gives you access to industry experts, independent content and
analysis and the Webs largest library of vendor-provided white papers,
webcasts, podcasts, videos, virtual trade shows, research reports and more
drawing on the rich R&D resources of technology providers to address
market trends, challenges and solutions. Our live events and virtual seminarsgive you access to vendor neutral, expert commentary and advice on the
issues and challenges you face daily. Our social community IT Knowledge
Exchange allows you to share real world information in real time with peers
and experts.
What makes TechTarget unique?TechTarget is squarely focused on the enterprise IT space. Our team of
editors and network of industry experts provide the richest, most relevant
content to IT professionals and management. We leverage the immediacy of
the Web, the networking and face-to-face opportunities of events and virtualevents, and the ability to interact with peersall to create compelling and
actionable information for enterprise IT professionals across all industries
and markets.
Related TechTarget Websites