All coursesPart 1 · Essentials

Exadata Part 1: Exadata Essentials

What Exadata is and how it is built, then a quarter rack you install yourself on a laptop.

Taught by Ravi Kumar

Read the reviews

What you'll learn

  • Learn Oracle Exadata from Scratch
  • Exadata Introduction - DMA Roles
  • Traditional RAC versus Exadata
  • DB Challenges - Exadata
  • Exadata Versions(V1 to X8m)
  • Exadata Configurations
  • Rack Overview - HW & SW
  • DB Servers - HW & SW
  • Cell Servers - HW & SW
  • NW Components - HW & SW
  • SFC & PMEM
  • Modifications to SW or HW Components
  • Management Network
  • ILOM Network
  • InfiniBand/RoCE Network
  • Client Network
  • Exadata Internal & External Connectivity
  • Comparisons(among versions)
  • Installation(In laptop)
  • Cells–OS – Installation (Lab)
  • Cells-System Software – Installation (Lab)
  • Cells-Storage–Configuration (Lab)
  • DB Node – OS Installation (Lab)
  • DB Node–Install – GIS Binaries – Prerequisites (Lab)
  • Create cellip and cellinit files (Lab)
  • DB Node–Install – GIS Binaries – RunInstaller (Lab)
  • DB Node–Install GIS Binaries – root script (Lab)
  • DB Node – Install RDBMS Binaries (Lab)
  • DB Node – RAC DB Creation (Lab)

Course content

6 sections · 29 lessons · 28 h 45 min

Course Outline1 lesson · 11 min
  1. 1
    Course Outline

    What the course covers and how the two parts fit together.

    Part 1 and Part 2 at a glance · where the laptop lab comes in

    11 min
Exadata_Introduction6 lessons · 7 h 33 min
  1. 2
    IT Teams - DBA - DMA

    How the IT teams around a database split the work, and how a DBA becomes a Database Machine Administrator (DMA) on Exadata.

    the teams around a database · DBA against DMA

    1 h 08 min
  2. 3
    DMA Roles
    1 h 42 min
  3. 4
    Traditional RAC versus Exadata
    1 h 27 min
  4. 5
    DB Challenges - Exadata
    48 min
  5. 6
    Exadata Versions

    Every Exadata generation from V1 to X8M and what changed in each.

    V1 and V2 · X2 to X8M · the move from InfiniBand to RoCE with X8M

    49 min
  6. 7
    Exadata Configurations

    The rack sizes Oracle sells and how they are built up.

    eighth, quarter, half and full racks · elastic configurations

    1 h 36 min
Hardware Architecture4 lessons · 2 h 48 min
  1. 8
    Rack Overview

    What sits in an Exadata rack and where.

    database servers, storage servers, switches and power units in the rack

    33 min
  2. 9
    DB Servers
    31 min
  3. 10
    Cell Servers

    The storage server hardware.

    hard disks, flash cards and persistent memory · High Capacity and Extreme Flash cells

    1 h 08 min
  4. 11
    NW Components

    The switches that connect the rack.

    InfiniBand or RoCE switches · the management switch

    34 min
Software Architecture5 lessons · 2 h 13 min
  1. 12
    Compute Servers
    47 min
  2. 13
    Storage Servers

    The Exadata System Software on the storage cells.

    the cell services (CELLSRV, MS, RS) · CellCLI

    14 min
  3. 14
    SFC Architecture

    How Exadata Smart Flash Cache works.

    write-through and write-back flash cache

    35 min
  4. 15
    PMEM Architecture

    Persistent memory on X8M storage cells.

    PMEM cache · PMEM log

    22 min
  5. 16
    HW SW Modifications
    12 min
Networking Architecture3 lessons · 3 h 31 min
  1. 17
    Networking Architecture-1

    The networks every Exadata runs.

    management network · ILOM network · client network

    1 h 38 min
  2. 18
    Networking Architecture-2
    38 min
  3. 19
    Comparisons

    The Exadata versions side by side.

    hardware and network differences across generations

    1 h 15 min
Installation on VMware - Virtual Rack10 lessons · 12 h 27 min
  1. 20
    Cells OS Installation (Lab)

    Install the operating system on the virtual storage cells.

    2 h 25 min
  2. 21
    Cell System SW Installation(Lab)

    Install the Exadata System Software on the cells.

    2 h 08 min
  3. 22
    Cell Storage Configuration (Lab)

    Configure cell disks and grid disks on the cells.

    cell disks · grid disks

    1 h 20 min
  4. 23
    DB Node OS Installation (Lab)

    Install the operating system on the database nodes.

    1 h 42 min
  5. 24
    DB Node Install GIS Binaries Prerequisites (Lab)
    35 min
  6. 25
    DB Node Create cellip.ora and cellinit.ora (Lab)

    Point the database nodes at the storage cells.

    cellip.ora (which cells to use) · cellinit.ora (the node's own storage network address)

    48 min
  7. 26
    DB Node Install GIS Binaries RunInstaller (Lab)

    Run the Grid Infrastructure installer.

    32 min
  8. 27
    DB Node Install GIS Binaries root.sh (Lab)

    Run root.sh to bring up the cluster on both nodes.

    45 min
  9. 28
    DB Node Install RDBMS Binaries (Lab)

    Install the Oracle database software.

    34 min
  10. 29
    DB Node RAC DB Creation (Lab)

    Create a two node RAC database on the grid disks.

    1 h 34 min

Requirements

  • You are an Oracle DBA with good working knowledge of ASM, RAC and RMAN, on 11gR2 and 12c or 19c.
  • You understand general networking, storage and system administration.

Who this course is for

  • Oracle database administrators, SMEs and architects
  • Systems administrators

The laptop lab runs an 11.2 software stack, the version a laptop can carry. The lessons cover Exadata from V1 to X8M; Part 2 goes up to X11M.