Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Exadata Database Machine - Administration

( Duration: 5 Days )

This Exadata Database Machine - Administration training course introduces you to Oracle Exadata Database Machine, covering the features and capabilities of the Exadata Database Machine. In this course, you will be introduced to Oracle Database Exadata Cloud Service. Explore the various Exadata Database Machine features and configurations, with emphasis on the unique capabilities delivered by Exadata Storage Server.

By attending Exadata Database Machine - Administration workshop, delegates will learn to:

  • Describe the key capabilities of Exadata Database Machine
  • Identify the benefits of using Exadata Database Machine for different application classes
  • Describe the architecture of Exadata Database Machine and its integration with Oracle Database, Clusterware and ASM
  • Configure I/O Resource Management
  • Complete the initial configuration of Exadata Database Machine
  • Describe various recommended approaches for migrating to Exadata Database Machine
  • Gain an understanding of the Oracle Database Exadata Cloud Service
  • Monitor Exadata Database Machine health and optimize performance

  • Attend a training on Oracle Database 12c: Backup and Recovery Workshop or equivalent practical experience
  • A working knowledge of Unix/Linux along with an understand of general networking, storage and system administration concepts
  • Prior knowledge and understanding of Oracle Database 11g Release 2 or 12c, including Oracle Clusterware and Automatic Storage Management (ASM)

The Exadata Database Machine - Administration class is ideal for:

  • Administrators
  • Database Administrators
  • End Users
  • Systems Administrators

COURSE AGENDA

1

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
2

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
3

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
4

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
5

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
6

I/O Resource Management

  • I/O Resource Management Concepts
  • IORM Architecture
  • Getting Started with IORM
  • Enabling Intradatabase Resource Management
  • Setting Database I/O Utilization Limits
  • Interdatabase Plans and Database Roles
  • Using Database I/O Metrics
  • IORM and Exadata Storage Server Flash Memory
7

Consolidation Options and Recommendation

  • Consolidation: Overview
  • Different Consolidation Types
  • Recommended Storage Configuration for Consolidation
  • Alternative Storage Configurations
  • Cluster Configuration Options
  • Isolating Management Roles
  • Schema Consolidation Recommendations
  • Maintenance Considerations
8

Migrating Databases to Exadata Database Machine

  • Migration Best Practices: Overview
  • Performing Capacity Planning
  • Database Machine Migration Considerations
  • Choosing the Right Migration Path
  • Logical Migration Approaches
  • Physical Migration Approaches
  • Post-Migration Best Practices
  • Migrating to Database Machine Using Transportable Tablespaces
9

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
10

Exadata Database Machine Platform Monitoring Introduction

  • Monitoring Technologies and Standards
  • Simple Network Management Protocol (SNMP)
  • Intelligent Platform Management Interface (IPMI)
  • Integrated Lights Out Manager (ILOM)
  • Exadata Storage Server Metrics, Thresholds, and Alerts
  • Automatic Diagnostic Repository (ADR)
  • Enterprise Manager Cloud Control 12c
  • Enterprise Manager Database Control
11

Configuring Enterprise Manager Cloud Control 12c to Monitor Exadata Database Machine

  • Enterprise Manager Cloud Control 12c Architecture: Overview
  • Cloud Control Monitoring Architecture for Exadata Database Machine
  • Configuring Cloud Control to Monitor Exadata Database Machine
  • Pre-discovery Configuration and Verification
  • Deploying the Oracle Management Agent
  • Discovering Exadata Database Machine
  • Discovering Additional Targets
  • Post-discovery Configuration and Verification
12

Monitoring Exadata Storage Servers

  • Exadata Metrics and Alerts Architecture
  • Monitoring Exadata Storage Server with Metrics and Alerts
  • Isolating Faults with
  • Monitoring Exadata Storage Server with Enterprise Manager: Overview
  • Monitoring Hardware Failure and Sensor State
  • Monitoring Exadata Storage Server Availability
  • Comparing Metrics Across Multiple Storage Servers
13

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
14

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:
15

Monitoring Other Exadata Database Machine Components

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

Other Useful Monitoring Tools

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

Backup and Recovery

  • Using RMAN with Database Machine
  • General Recommendations for RMAN
  • Disk-Based Backup Strategy
  • Disk-Based Backup Recommendations
  • Disk-Based Backup on
  • Tape-Based Backup Strategy
  • Tape-Based Backup Architecture and Recommendations
  • Backup and Recovery of Database Machine Software
18

Exadata Database Machine Maintenance Tasks

  • Database Machine Maintenance: Overview
  • Powering Database Machine Off and On
  • Safely Shutting Down a Single Exadata Storage Server
  • Replacing a Damaged Physical Disk
  • Replacing a Damaged Flash Card
  • Moving All Disks from One Cell to Another
  • Using the Exadata Cell Software Rescue Procedure
19

Exadata Database Machine: Patching, Automated Support Ecosystem Cloud Service Overview

  • Introducing Exadata Cloud Service
  • Service Configuration Options Service Connection Options
  • Service Architecture Availability
  • Management Responsibilities
  • Storage Configuration Management Details
  • Simple Web-Based Provisioning Management
  • REST APIs
  • Migrating to Exadata Cloud Service
20

Exadata Database Machine Maintenance Tasks

  • Database Machine Maintenance: Overview
  • Powering Database Machine Off and On
  • Safely Shutting Down a Single Exadata Storage Server
  • Replacing a Damaged Physical Disk
  • Replacing a Damaged Flash Card
  • Moving All Disks from One Cell to Another
  • Using the Exadata Cell Software Rescue Procedure
21

Exadata Database Machine: Patching, Automated Support Ecosystem Cloud Service Overview

  • Introducing Exadata Cloud Service
  • Service Configuration Options Service Connection Options
  • Service Architecture Availability
  • Management Responsibilities
  • Storage Configuration Management Details
  • Simple Web-Based Provisioning Management
  • REST APIs
  • Migrating to Exadata Cloud Service

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X