ORACLE EXADATA L1 - L2 Training

Course

Introduction

Course Objectives
Audience and Prerequisites
Course Contents
Terminology
Additional Resources
Introducing the Laboratory Environment

-

Exadata Database Machine Overview

Introducing Database Machine
Introducing Exadata Storage Server
Exadata Storage Server Architecture: Overview
Exadata Storage Server Features: Overview
Exadata Storage Expansion Racks
InfiniBand Network
Database Machine Support: Overview

-

Exadata Database Machine Architecture

Database Machine Architecture: Overview
Database Machine Network Architecture
InfiniBand Network Architecture
InfiniBand Network Topology
Interconnecting Multiple Racks
Database Machine Software Architecture: Overview
Disk Storage Entities and Relationships

-

Key Capabilities of Exadata Database Machine

Classic Database I/O and SQL Processing Model
Exadata Smart Scan Model • Exadata Smart Storage Capabilities
Exadata Hybrid Columnar Compression
Exadata Smart Flash Cache
Exadata Storage Index
Database File System
I/O Resource Management
Labs on Capabilities

-

Exadata Database Machine Initial Configuration

Database Machine Implementation: Overview
Database Machine Site Preparation
Using Oracle Exadata Deployment Assistant
Choosing the Right Disk Redundancy Setting
Configuring Oracle Exadata Database Machine
The Result After Installation and Configuration
Supported Additional Configuration Activities
Labs Real time scenario on OEDA and Deployment on real machine

-

Exadata Storage Server Configuration

Exadata Storage Server Administration: Overview
Testing Storage Server Performance Using CALIBRATE
Configuring the Exadata Cell Server Software
Starting and Stopping Exadata Cell Server Software
Configuring Cell Disks and Grid Disks
Configuring ASM and Database Instances to Access Exadata Cells
Reconfiguring Exadata Storage
Exadata Storage Security Implementation

-

Bulk Data Loading using Oracle DBFS

Bulk Data Loading Using Oracle DBFS: Overview
Preparing the Data Files
Staging the Data Files
Configuring the Staging Area
Configuring the Target Database
Loading the Target Database
Labs on DBFS

-

Monitoring Exadata Database Machine Database Servers

Monitoring Database Servers: Overview
Monitoring Hardware
Monitoring the Operating System
Monitoring Oracle Grid Infrastructure
Monitoring Oracle Database
Monitoring Oracle Management Agent
Database Monitoring with Enterprise Manager Cloud Control 12c
Labs on details monitoring

-

Monitoring the InfiniBand Network

InfiniBand Network Monitoring: Overview
InfiniBand Network Monitoring with
Monitoring the InfiniBand Switches
Monitoring the InfiniBand Switch Ports
Monitoring the InfiniBand Ports
Monitoring the InfiniBand Fabric:
Monitoring the InfiniBand Fabric:
- - Labs on details monitoring

-

Monitoring Other Exadata Database Machine Components

Monitoring the Cisco Ethernet Switch
Monitoring the Sun Power Distribution Units
Monitoring the KVM Switch

-

Other Useful Monitoring Tools

Exachk: Overview
Running Exachk
Exachk Daemon
DiagTools: Overview
Using ADRCI on Exadata Storage Servers
Imageinfo: Overview
Imagehistory: Overview
OSWatcher: Overview

-

Patching Exadata Database Machine

Patching and Updating: Overview
Maintaining Exadata Storage Server Software
Maintaining Database Server Software
Assisted Patching Using OPlan
Assisted Patching Using
Maintaining Other Software
Recommended Patching Process
Test System Recommendations
Labs on Live Patch on-off/Rolling Patch+OPlan

-

End....