Best Oracle Exadata training institute Bangalore| Exadata Machine Administration


Oracle Exadata Machine Administration Workshop in Bangalore

Oracle Exadata training Bangalore, best Exadata training bangalore, Exadata training institute in bangalore, Exadata training course bangalore, exadata training koramangala, exadata training topics

 Oracle Exadata Training in Bangalore

Exadata Database Machine: Administration Workshop

 Click here to download the Syllabus 

This course introduces students to Oracle Exadata Database Machine. Students learn about the various Exadata Database Machine features and configurations, with emphasis on the unique capabilities delivered by Exadata Storage Server.

What is Exadata?

1. A bundle of Hardware and Software from Oracle Itself and ready to use immediately.

2. An Intelligent Storage Server to optimize Database Performance. In order to achieve this intelligent a software called Exadata is installed on all storage servers.

In Exadata Terms, A single storage server is called Cell or Cell server. So I will be referring storage server and cell server interchangeably in this article. I might be referring DB Server, DB Node for Database Server.

The conventional Oracle database system is a combination of multiple distinct components - servers, managed by system admins; storage units, managed by SAN admins; network components such as switches and routers, managed by network admins; and, of course, the database itself, managed by the DBAs.

Exadata is an Engineered machine with both Hardware & Software incorporated and has all those components - servers, storage (as cell servers), infiniband network, ethernet network, flash disks, the whole nine yards; but packaged inside a single physical frame representing a single logical unit.

Component of Exadata Storage Server:

It's another storage device, which has CUP, Memory, Disks, network cards, an Operating System Oracle Linux and Most important past Exdata Storage Server Software. There are mainly three services which run on cell server for processing, CellSRV (Cell Service), MS (Management Server) and RS (Restart Server).

Cell Service (CellSRV): This is the primary component of Exdata Cell which provides all Exadata Storage services. This process communicate with Database server for providing database blocks.

Management Server (MS): MS service provide an interface to DBA for communicating or Managing Cell Server. CellCLI is the Command Line tool which Exadata DBA used for performing Exadata Administration services.

Restart Server (RS): This service is to make sure the functioning of Exadata Server. RS monitors CellSRV and MS for liveliness and restart them whenever required.

best training institute for exadata in bangalore, exadata hands on training in bangalore, top training for exadata bangalore

Who should attend the session?

Database Administrators.
Those who have basic working knowledge as Oracle Database Administrators.
Those who have undergone a course on any Oracle Database Administration course.
Those who wish to explore opportunities on Exadata.

Trainer Profile:

10+ years experienced real time Exadata DBA

Duration:

4 hours x 4 days (2 weekends)

Course Topics

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

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

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

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

Recommendations for Optimizing Database Performance
• Flash Memory Usage
• Influencing Caching Priorities
• Choosing the Flash Cache Mode
• Compression Usage
• Index Usage
• ASM Allocation Unit Size
• Minimum Extent Size
• Exadata Specific System Statistics

Using Smart Scan
• Exadata Smart Scan: Overview
• Smart Scan Requirements
• Monitoring Smart Scan in SQL Execution Plans
• Smart Scan Join Processing with Bloom Filters
• Other Situations Affecting Smart Scan
• Exadata Storage Server Statistics: Overview
• Exadata Storage Server Wait Events: Overview

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

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

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

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

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

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

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

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:

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

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


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

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

Click here to download the detailed Syllabus 

Call us to talk about your training requirements:
+91 (80) 4150 1359 (Training) or Click here to Fill up the Enquiry form