How to Install Oracle 19c RAC including upgrade of Grid/DB

Install Oracle RAC 19c
Free tutorial
Rating: 4.3 out of 5 (17 ratings)
1,157 students
1hr 12min of on-demand video
English
English [Auto]

Oracle DBA
Oracle RAC DBA
Oracle EBS DBA
Oracle Cloud DBA

Requirements

  • Oracle DBA

Description

Here are the course contents anyone needs to know


Configure RMAN for the RAC environment

Describe the benefits of Oracle RAC

Explain the necessity of global resources

Configure the RAC database to use ARCHIVELOG mode and the fast recovery area

Convert a single-instance Oracle Database to RACs

Create a cluster database

Gain an understanding of the Oracle Database Exadata Cloud Service

Explain the principles and purposes of clusters

Install the Oracle Database software

Modify initialization parameters in a RAC environment

Perform post-database-creation tasks

Define redo log files in a RAC environment

Define undo tablespaces in a RAC environment

Describe global cache coordination

Describe how Grid Plug and Play affects Clusterware

Describe the Oracle Clusterware architecture


Grid Infrastructure Overview and Review

· What is a Cluster?

· What is a Flex Cluster

· Clusterware Characteristics

· Oracle Clusterware

· Hardware and Software Concepts (High level)

RAC Databases Overview & Architecture

· Overview of Oracle RAC

· RAC One Node

· Cluster-Aware Storage Solutions

· Benefits of Using RAC

· Scaleup and Speedup

· I/O Throughput Balanced

· Global Resources

· RAC and Flex ASM

Installing and Configuring Oracle RAC

· Installing the Oracle Database Software

· Installation options

· Creating the Cluster Database

· Post-installation Tasks

· Single Instance to RAC Conversion

· Cleaning Up Unsuccessful Installs

Oracle RAC Administration

· Parameters and RAC - SPFILE, Identical and Unique Parameters

· Instance Startup, Shutdown and Quiesce

· Undo Tablespaces

· Redo Threads

· Use Enterprise Manager Cluster Database Pages

· RAC Alerts

· RAC Metrics

Managing Backup and Recovery for RAC

· Overview of Upgrades and Patching

· Release and Patch Set Upgrades

· PSU, CPU and Interim Patches

· Merge Patches

· Performing Out Of Place Database Upgrades

· Planning and Preparing for Upgrade

· Performing Out of Place Release Install or Upgrade

· Post Upgrade Tasks

RAC Backup and Recovery

· Instance Failure And Recovery In RAC - LMON and SMON

· Redo Threads and Archive Log 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 Distribution

· RMAN Restore And Recovery RAC Considerations

RAC Global Resource Management and Cache Fusion

· Globally Managed Resources and Management

· Library Cache Management

· Row cache management

· Buffer cache fusion

· Buffer Cache Management Requirements

· Accessing single blocks in RAC

· Multi-block read considerations in RAC

· Undo and read consistency considerations in RAC

RAC Database Monitoring and Tuning

· OCPU and Wait Time Latencies

· Wait Events for RAC

· Common RAC Tuning

· Session and System Statistics

· RAC specific V$ Views

· Automatic Database Diagnostic Monitor for RAC

Managing High Availability of Services in a RAC Environment

· Oracle Services

· Services for Policy - and Administrator-Managed Databases

· Creating Services

· Managing Services

· Use Services with Client Applications

· Services and Connection Load Balancing

· Services and Transparent Application Failover

· Services and the Resource Manager

Managing High Availability of Connections

· Types of Workload Distribution

· Client-Side Load Balancing

· Server-Side Load Balancing

· Runtime Connection Load Balancing and Connection Pools

· Fast Application Notification

· The Load Balancing Advisory FAN Event

· Server-Side Callouts

· Configuring the Server-Side ONS

Application Continuity

· What is AC?

· What problem does it solve?

· Benefits of AC

· How AC works

· AC Architecture

· Side Effects

· Restrictions

· Application requirements

RAC One Node

· RAC One Node Concepts

· Online database migration

· Adding Oracle RAC One Node Database to an Existing Cluster

· Convert an Oracle RAC One Node database to a RAC database

· Convert an Oracle RAC database to a RAC One Node database

· Use DBCA to convert a single instance database to a RAC One Node database

Multitenant Architecture and RAC

· Non-CDB Architecture

· Multitenant Architecture: Benefits

· CDB in a Non-RAC Environment

· Containers

· Terminology and Data Dictionary Views

· Connection to a Non-RAC CDB

· Oracle RAC and Multitenant Configuration

· Oracle RAC and Multitenant Architecture

Quality of Service Management

· QOS Management concepts

· Describe the benefits of using QoS Management

· QoS Management components

· QoS Management functionality


Who this course is for:

  • Oracle folks who wants to Install RAC 19c on their own System

Instructor

Oracle EBS DBA, Oracle RAC DBA, OCI Consultant
Admin AppsDBA
  • 4.3 Instructor Rating
  • 447 Reviews
  • 3,995 Students
  • 32 Courses

The trainer is an Oracle E-Business DBA, Oracle Cloud Infrastructure Consultant and Oracle 12c/19c DBA consultant who takes a leadership role in Planning, Installing, and implementing innovative business process and system solutions using state-of-the-art approaches and technology. Creative problem-solver who always goes the extra mile, is adept at learning new systems and processes, and has proven ability to work effectively. Strong customer/user advocate, apt negotiator with excellent analytical, collaboration, communication, decision-making, and organization skills. He also has experience on Oracle Identity and Access Management (SSO) for 8 years including Integrating PaaS, SaaS and Azure AD/ADFS and also has worked in RAC 19c environment. He is also a Distinguished Toastmaster (DTM). He has 15 OCI certifications.


The trainer has below Certifications for his credit


Oracle Cloud Database Services 2021 Certified Specialist

Oracle Database Cloud Administrator 2021 Certified Professional

Oracle Cloud Infrastructure 2021 Certified Architect Professional

Oracle Cloud Infrastructure 2021 Certified Cloud Operations Associate

Oracle Autonomous Database Cloud 2021 Certified Specialist

Oracle Cloud Database Migration and Integration 2021 Certified Specialist

Oracle Cloud Infrastructure 2021 Certified Architect Associate

Oracle Cloud Infrastructure Foundations 2021 Certified Associate

Oracle Cloud Infrastructure 2021 Enterprise Workloads Certified Associate

Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator

Oracle Database Cloud Service 2020 Certified Specialist

Oracle Database Cloud Administrator 2020 Certified Professional

Oracle Cloud Infrastructure 2019 Certified Cloud Operations Associate

Oracle Cloud Infrastructure 2020 Certified Architect Associate

Oracle Cloud Infrastructure Foundations 2020 Certified Associate

Oracle Cloud Infrastructure 2019 Certified Architect Professional

Oracle Autonomous Database Cloud 2019 Certified Specialist

Oracle Cloud Infrastructure 2019 Certified Architect Associate

Oracle Cloud Infrastructure 2018 Certified Architect Associate

Oracle Database Cloud Administrator Certified Professional

Oracle Database Cloud Service Operations Certified Associate

Oracle Database 11g Administrator Certified Professional

Oracle E-Business Suite R12 Applications Database Administrator Certified Professional

Top companies trust Udemy

Get your team access to Udemy's top 17,000+ courses