Oracle RAC and Grid Infrastructure Administration

ORC-400 (5 Days)
Request Pricing for Oracle RAC and Grid Infrastructure Administration

Oracle Training Overview

This Oracle RAC and Grid Infrastructure Administration training teaches attendees how to install and administer Grid Infrastructure, RAC Clustered Databases, and Automatic Storage Management (ASM). 

The primary focus of this course is on installation, maintenance, and administration of Oracle Grid Infrastructure and RAC using command-line utilities. Graphical tools may be used if desired and are needed for some exercises.

Location and Pricing

Most Accelebrate courses are taught as private, customized training for 3 or more attendees at our clients' sites worldwide. In addition, we offer live, private online classes for teams who may be in multiple locations or wish to save on travel costs. Please visit our client list for organizations for whom we have delivered onsite training. To receive a customized proposal and price quote for private on-site or online training, please contact us.

In addition, some courses are available as live, online classes for individuals. See a schedule of online courses.

Oracle Training Objectives

All students will learn how to:

  • Install and configure Grid Infrastructure
  • Create clustered databases, convert from single instance to RAC
  • Carry out basic RAC administration, backup and recovery, and performance tuning
  • Configure RAC database services for zero downtime
  • Use GI to manage virtual IP addresses
  • Configure shared storage and the ASM Clustered File system
  • Use GI to provide high availability for third party applications

Oracle Training Outline

Expand All | Collapse All | Printer-Friendly

Introduction
Grid Infrastructure Concepts
  • What is a Cluster
  • Grid Infrastructure Components
  • Oracle Clusterware Architecture
  • Oracle Clusterware Software and Storage
  • Describe ASM Architecture
  • ASM Disk Groups
  • ASM Cluster File systems
Grid Infrastructure Installation and Configuration
  • Hardware Requirements and Configuration
  • OS Requirements and Prerequisites
  • Storage Options
  • Network Requirements
  • The cluster interconnect
  • GNS, DNS and DHCP Configuration
  • Grid Plug and Play Considerations
  • The Grid Naming Service
  • Single Client Access Names
The Database Listener Model
  • The SCAN listeners and the node listeners
  • Database session connect time fault tolerance
  • Session load balancing
  • Runtime load balancing and fault tolerance
Administering Oracle Clusterware
  • Adding, Deleting, or Migrating Voting Disks
  • The Oracle Cluster Registry (OCR)
  • OCR Mirroring and Backups
  • The Oracle Local Registry
  • Migrating voting file and OCR to ASM
  • Managing Network Settings
Managing cluster resources
  • Stopping, starting, and relocating  resources
  • Registering third-party applications
  • Configuring dependencies between resources
  • Writing event handler scripts
Oracle Clusterware High Availability
  • Oracle Clusterware high availability components
  • Contrasting policy-managed and administration managed databases
  • Server pool functionality
  • The Generic and Free Server Pools
  • Application placement policies
  • Application Virtual IPs
  • Managing application resources
Troubleshooting Oracle Clusterware
  • Oracle Clusterware Log Files
  • Gathering Log Files Using diagcollection.pl
  • Resource Debugging
  • Component-level Debugging
  • Troubleshooting the Oracle Cluster Registry
RAC and Grid Infrastructure
  • Architectural summary
  • ASM and share storage
  • The SCAN and node listener model
  • RAC solutions
Real Application Clusters Database Installation
  • Installing Oracle Database Software
  • Single Instance to RAC conversion
  • Creating A Clustered Database
Oracle RAC Administration
  • Redo Log Files In A RAC Environment
  • ndo Tablespaces In A RAC Environment
  • Starting And Stopping RAC Databases And Instances
  • Initialization Parameters In A RAC Environment
Managing Backup and Recovery for RAC
  • Protecting Against Media Failure
  • Archived Log File Configurations
  • Database Backup and Recovery with RMAN
  • Recovery following instance failure
Performance Tuning
  • The Tuning Methodology
  • The global cache and the global enqueue service
  • RAC Specific Statistics and Wait Events
  • Tuning Parallel Processing
  • RAC Specific Performance Issues
  • AWR and Statspack in a clustered environment
High availability and services
  • RAC Service Architecture
  • Configure and Manage Services in a RAC environment
  • Using Services with Client Applications
  • The fault tolerant architecture
  • Instance evictions
  • Policy managed databases and services
  • Stretched clusters
  • Maximum availability Architecture: RAC plus Data Guard
Administering ASM Instances
  • The ASM bootstrap
  • Administration privileges and the password file
  • ASM Initialization Parameters
  • Adjusting ASM Instance Parameters in SPFILEs
  • Starting and Stopping ASM Instances Using srvctl and other tools
  • Tuning and monitoring the ASM instance
Administering ASM Disks
  • Disk storage options: LUNs, directly attached storage, network attached storage
  • Using the ASMLib and the ASM Filter Driver
  • Using the udev facility
Administering ASM Disk Groups
  • Creating And Deleting ASM Disk Groups
  • The importance of the RDBMS, ASM, and ACFS compatibilities
  • Placing the OCR and voting files on ASM devices
  • ASM Disk Group Maintenance Tasks
  • The various levels of redundancy
  • Templates for striping and mirroring
  • Hot and cold areas: exploit the geometry of the disks
  • Fast mirror resynch
  • choosing an allocation unit  size and a sector size
  • Preferred Read Failure Groups
  • Metadata backup and restore
  • Performance And Scalability Considerations For ASM Disk Groups
ASM Files, Directories, and Templates
  • Using Different Client Tools to Access ASM Files
  • Creating and Managing ASM files, Directories and Aliases
  • Applying templates to files
  • File extents, segment extents, and allocation units
  • Techniques for moving files within, into, and out of ASM
  • Security and Access Control Lists
Administering ASM Cluster File Systems
  • The ASM Dynamic Volume Manager
  • The ACFS file system driver
  • The ACFS bootstrap
  • Managing ASM Volumes: striping and mirroring
  • ACFS file system snapshots
  • ACFS  file system replication
  • ACFS file system encrption
  • The administration tools: srvctl, asmca, acfsutil, Unix utilities
Flex ASM
  • Conversion from standard ASM to Flex ASM
  • Conversion from standard cluster to flex cluster
  • Configuring and using Flex ASM
  • The ASM network
  • The ASM listeners
  • Set the ASM instance cardinality
  • Relocate ASM instances and clients
  • The ADVM proxy service for ACFS in a Flex ASM environment
ASM, ACFS, and the database
  • Defining dependencies between a database and diskgroups
  • Defining dependencies between a database and file systems
  • Using ACFS for the database Oracle Home
  • Using ACFS to store database files
Conclusion
Request Pricing for Oracle RAC and Grid Infrastructure Administration
Lecture percentage

50%

Lecture/Demo

Lab percentage

50%

Lab

Course Number:

ORC-400

Duration:

5 Days

Prerequisites:

  • Understanding of Oracle database and instance architecture
  • Familiarity with SQL and basic PL/SQL
  • Knowledge of TCP/IP networking and file system administration
  • Able to work with Linux command-line tools

Training Materials:

All Oracle training students receive comprehensive courseware and a related textbook.

Software Requirements:

  • At least 8 GB RAM
  • A complete installation of Oracle
  • Oracle SQL Developer
  • Please contact us for detailed setup instructions if you have purchased this class

Contact Us:

Accelebrate’s training classes are available for private groups of 3 or more people at your site or online anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.

For pricing and to learn more, please contact us.

Contact Us Train For Us

Toll-free in US/Canada:
877 849 1850
International:
+1 678 648 3113

Toll-free in US/Canada:
866 566 1228
International:
+1 404 420 2491

925B Peachtree Street, NE
PMB 378
Atlanta, GA 30309-3918
USA

Subscribe to our Newsletter:

Never miss the latest news and information from Accelebrate:

Microsoft Gold Partner

Please see our complete list of
Microsoft Official Courses

Recent Training Locations

Alabama

Birmingham

Huntsville

Montgomery

Alaska

Anchorage

Arizona

Phoenix

Tucson

Arkansas

Fayetteville

Little Rock

California

Los Angeles

Oakland

Orange County

Sacramento

San Diego

San Francisco

San Jose

Colorado

Boulder

Colorado Springs

Denver

Connecticut

Hartford

DC

Washington

Florida

Fort Lauderdale

Jacksonville

Miami

Orlando

Tampa

Georgia

Atlanta

Augusta

Savannah

Hawaii

Honolulu

Idaho

Boise

Illinois

Chicago

Indiana

Indianapolis

Iowa

Ceder Rapids

Des Moines

Kansas

Wichita

Kentucky

Lexington

Louisville

Louisiana

New Orleans

Maine

Portland

Maryland

Annapolis

Baltimore

Frederick

Hagerstown

Massachusetts

Boston

Cambridge

Springfield

Michigan

Ann Arbor

Detroit

Grand Rapids

Minnesota

Minneapolis

Saint Paul

Mississippi

Jackson

Missouri

Kansas City

St. Louis

Nebraska

Lincoln

Omaha

Nevada

Las Vegas

Reno

New Jersey

Princeton

New Mexico

Albuquerque

New York

Albany

Buffalo

New York City

White Plains

North Carolina

Charlotte

Durham

Raleigh

Ohio

Akron

Canton

Cincinnati

Cleveland

Columbus

Dayton

Oklahoma

Oklahoma City

Tulsa

Oregon

Portland

Pennsylvania

Philadelphia

Pittsburgh

Rhode Island

Providence

South Carolina

Charleston

Columbia

Greenville

Tennessee

Knoxville

Memphis

Nashville

Texas

Austin

Dallas

El Paso

Houston

San Antonio

Utah

Salt Lake City

Virginia

Alexandria

Arlington

Norfolk

Richmond

Washington

Seattle

Tacoma

West Virginia

Charleston

Wisconsin

Madison

Milwaukee

Alberta

Calgary

Edmonton

British Columbia

Vancouver

Manitoba

Winnipeg

Nova Scotia

Halifax

Ontario

Ottawa

Toronto

Quebec

Montreal

Puerto Rico

San Juan

© 2013-2020 Accelebrate, Inc. All Rights Reserved. All trademarks are owned by their respective owners.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.