Oracle Database 12c R2: RAC Administration Ed 2

loading..
(Course eligible for SATVs)

loading..

This Oracle Database 12c R2: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

  • Clusterware Characteristics
  • RAC and Flex ASM
  • Oracle Clusterware
  • What is a Flex Cluster? 
  • Hardware and Software Concepts (High level)
  • What is a Cluster? 
  • Oracle RAC One Node (High Level)
  • Benefits of Using RAC
  • Overview of Oracle RAC
  • Global Resources
  • Scaleup and Speedup
  • I/O Throughput Balanced
  • Cluster-Aware Storage Solutions
  • Post-installation Tasks
  • Single Instance to RAC Conversion using DBCA and rconfig
  • Creating the Cluster Database 
  • Installation Options
  • Configuring Oracle RAC Reader Nodes
  • Installing the Oracle Database Software
  • Parameters and RAC-SPFILE, identical and Unique Parameters
  • RAC Alerts
  • RAC Metrics
  • Use Enterprise Manager Cluster Database Pages
  • Local Temporary Tablespaces
  • Redo Threads
  • Separation of Duty for Administering Oracle RAC
  • Undo Tablespaces
  • Merge Patches
  • Performing Out of Place Database Upgrades
  • Overview of Upgrades and Patching
  • Post Upgrade Tasks
  • Planning and Preparing for Upgrade
  • PSU, CPU and Interim Patches
  • Release and Patch Set Upgrades
  • Redo Threads and Archive Logs Configurations and Admin
  • Parameter Settings Affecting Parallel Recovery and MTTR
  • Instance Failure and Recovery In RAC-LMON and SMON
  • RAC and the Fast Recovery Area
  • RMAN Configuration
  • RMAN Admin for RAC: Channels, Instances, Backup Considerations
  • Row cache management
  • Buffer Cache Management Requirements
  • Undo and read consistency considerations in RAC
  • Multi-block read considerations in RAC
  • Globally Managed Resources and Management
  • Buffer cache fusion
  • Accessing single blocks in RAC
  • Library Cache Management
  • OCPU and Wait Time Latencies
  • Common RAC Tuning
  • RAC specific V$ Views
  • Wait Events for RAC
  • Monitoring RAC with Cluster Health Advisor (CHA)
  • Session and System Statistics
  • Automatic Database Diagnostic Monitor for RAC
  • Oracle Services
  • Managing Services
  • Service-Oriented Buffer Cache Access
  • Services and Connection Load Balancing
  • Creating Services
  • Use Services with Client Applications
  • Service for Policy – and Administrator- Managed Databases
  • Services and Transparent Application Failover
  • Client-Side Load Balancing
  • Server-Side Load Balancing
  • Types of Workload Distribution
  • Configuring the Server-Side ONS
  • The Load Balancing Advisory FAN Event
  • Server- Side Callouts
  • Fast Application Notification
  • Runtime Connection Load Balancing and Connection Pools
  • Side Effects
  • Restrictions
  • What problem does it solve? 
  • How AC works
  • Benefits of AC
  • Application requirements
  • What is AC?
  • AC Architecture
  • Use DBCA to convert a single instance database to a RAC One Node Database
  • RAC One Node Concepts
  • Adding Oracle RAC One Node Database to an Existing Cluster
  • Convert an Oracle RAC Database to a RAC One Node Database
  • Online database migration
  • Convert an Oracle RAC One Node database to a RAC database
  • Architecture of In-Memory Column Store
  • Implementing In-Memory FastStart
  • Implementing In-Memory Column Store in RAC
  • Oracle RAC and Multitenant Configuration
  • CDB in a Non-RAC Environment
  • Connection to a Non-RAC CDB
  • Multitenant Architecture: Benefits
  • Non-CDB Architecture
  • Oracle RAC and Multitenant Architecture
  • Containers
  • Terminology and Data Dictionary Views
  • QoS Management Concepts
  • QoS Management Components
  • QoS Management functionality
  • Describe the benefits of using QoS Management
  • Service Configuration Options & Service Connection Options
  • REST APIs
  • Management Responsibilities 
  • Introducing Exadata Cloud Service
  • Simple Web-Based Provisioning & Management 
  • Migrating to Exadata Cloud Service 
  • Storage Configuration & Management Details
  • Service Architecture & Availability
  • Administrator
  • Database Administrators

Suggested Prerequisite:

  • Oracle Database 12c R2: Clusterware Administration
  • Working knowledge of Oracle Database 11g: Release 2, including Clusterware, ASM and RAC
  • Working knowledge of Oracle Clusterware, ASM & RAC on Linux 

Required Prerequisite: 

  • Oracle Database 12c R2: Clusterware Adminstration

Key Participants Benefit

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

  • Configure Oracle RAC Reader Nodes
  • Define redo log files in a RAC environment
  • Define undo tablespaces in a RAC environment
  • Describe the benefits of Oracle RAC
  • Convert a single-instance Oracle Database to RACs
  • Install the Oracle Database software
  • Create a cluster database 
  • Define local temporary tablespaces in a RAC environment
  • Modify initialisation parameters in a RAC environment
  • Perform post-database-creation tasks
  • Configure RMAN for the RAC environment
  • Configure the RAC database to use ARCHIVELOG mode and the fast recovery area
  • Explain the necessity of global resources
  • Describe global cache coordination
  • Explain the principles and purposes of clusters
  • Describe the Oracle Clusterware architecture

Register

Traditional Classroom   

    Show all

    Traditional Classroom   

      Show all

      Traditional Classroom   

        Show all

        Traditional Classroom   

          Show all

          OnlineLive   

            Show all

            Connected Classroom   

              Show all

              Flexible Mentored Learning   

                Show all

                Flexible Mentored Learning   

                  Show all

                  Flexible Mentored Learning   

                    Show all

                    Flexible Mentored Learning   

                      Show all

                      Not currently scheduled

                      Fast track the availability of this course.
                      Add to watch list or call 1300 794 006.

                      Need your team upskilled?
                      Request a Quote

                      blah is false
                      top