arrowecs sora io#102936 tipguide2 031212

Upload: devjeet

Post on 12-Feb-2018

219 views

Category:

Documents


0 download

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