Exadata Database Machine 12c Administration Workshop Ed 2

Duration: 5 Days

This workshop introduces Oracle Exadata Database Machine, focusing on its architecture, features, configurations, and administration techniques. Participants will gain hands-on experience with Exadata Storage Server and Exadata Cloud Service through a virtualized lab environment.

Module 01: Introduction

Terminology and resources

Laboratory environment overview

Course contents and audience

Module 02: Exadata Database Machine Overview

InfiniBand network

Storage Server features and architecture

Database Machine configurations and support

Module 03: Exadata Architecture

Disk storage entities and network topology

Software and hardware architecture

Multiple rack interconnects

Module 04: Key Capabilities

Smart Scan and Flash Cache

Hybrid Columnar Compression

I/O Resource Management (IORM)

Storage Index and Smart Storage

Module 05: Initial Configuration

Disk redundancy settings

Deployment Assistant and site prep

Post-install configuration

Module 06: Storage Server Configuration

CALIBRATE and testing tools

Cell software admin and disk configuration

ASM and cell integration

Module 07: I/O Resource Management (IORM)

Intra/interdatabase plans

Flash memory allocation

I/O metrics and utilization limits

Module 08: Performance Optimization

Index usage and compression

Flash cache strategies and extent sizing

System statistics and caching priorities

Module 09: Smart Scan

Monitoring with execution plans and wait events

Join processing and Bloom filters

Smart scan behavior and diagnostics

Module 10: Consolidation Best Practices

Storage and schema consolidation options

Cluster configuration and isolation

Management roles and recommendations

Module 11: Migration to Exadata

Logical and physical migration methods

Capacity planning and best practices

Transportable tablespaces

Module 12: Bulk Data Loading with DBFS

Staging and loading files

Target database configuration

Bulk data loading steps and tools

Module 13: Monitoring Platforms

SNMP, IPMI, ILOM, ADR, and Exadata-specific metrics

Cloud Control and diagnostic tools

Module 14: Enterprise Manager Cloud Control

Target discovery and agent deployment

Architecture and monitoring setup

Post-discovery configurations

Module 15: Monitoring Storage Servers

Hardware failures and sensor states

Metrics comparison and alert analysis

Monitoring with Enterprise Manager

Module 16: Monitoring Database Servers

Grid infrastructure and OS monitoring

Agent and database diagnostics

Module 17: Monitoring InfiniBand Network

Switches, ports, and fabric overview

Monitoring Ethernet, KVM, and PDUs

Module 18: Other Monitoring Tools

Exachk, OSWatcher, ADRCI

Imageinfo/imagehistory, DiagTools

Module 19: Backup and Recovery

RMAN recommendations

Tape/disk-based strategies

Software recovery practices

Module 20: Maintenance Tasks

Power cycling and disk replacement

Rescue procedures and maintenance tips

Module 21: Cloud Service & Automation

Provisioning and migration to Exadata Cloud Service

Service architecture, APIs, and automation tools