Oracle RAC and Grid 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
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- 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
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
Outline
Expand All | Collapse All
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
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