+91-9910111641 +91-9871481152 +91-01204310416 info@ncpnetwork.com

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....