Oracle Database 21C Grid And Container Database Automation

Build a complete Oracle 21c Grid Infrastructure and Container Database with automation scripts in under one hour

What you'll learn

How to Download Grid21c, database21c, Goldengate21c and Linux8.1 binaries from oracle website

How to install Linux8.1 for Oracle restart system

How to automate the installation and configuration of Grid Infrastructure and create a container database

How to set up the YUM repository to download Oracle ASM library packages using a shell script

How to create group for oracle using a shell script using shell script

How to create Oracle user using a shell script

How to create OS partitions using a shell script

How to create ASM disks on OS partitions using a shell script

How to create the Data and FRA disk groups using a shell script

How to install and configure Grid Infrastructure using a shell script

How to configure Transparent Data Encryption (TDE) using a shell script

How to install GoldenGate binaries using a shell script

Requirements

Basic understanding of Oracle Database

Basic operating system knowledge

A 64-bit Windows PC with 12GB of memory and 80GB of free disk space

Description

In this comprehensive course, you will learn how to build and configure a Non-RAC Oracle Clusterware environment for Oracle Database 21c, using automation scripts. Oracle Clusterware provides high availability for your Oracle Database, even when running a single-instance database in a cluster.Throughout this course, you will explore:How to automate the installation and configuration of Oracle Grid Infrastructure, ensuring your database environment is highly available.The process of setting up and configuring ASM (Automatic Storage Management) to manage your database storage.How to use YUM repositories to easily download and install Oracle ASM Library Packages.Techniques for automating critical administrative tasks such as creating OS partitions, ASM disks, and configuring disk groups using shell scripts.How to use shell scripts to streamline the installation of Oracle Database 21c, including creating a container database and configuring Transparent Data Encryption (TDE) for enhanced security.An introduction to installing and configuring Oracle GoldenGate for real-time data integration and replication.By the end of this course, you will have the skills to configure a highly available Non-RAC Oracle Clusterware environment and automate key Oracle Database tasks, significantly reducing manual intervention and improving efficiency in your Oracle Database deployment.This course is ideal for DBAs, system administrators, and DevOps engineers who want to learn how to automate and manage Oracle Database infrastructure without the complexity of Oracle RAC, leveraging the power of Oracle Clusterware and automation scripting for consistent and reliable database management.

Overview

Section 1: Introduction

Lecture 1 Introductoin

Section 2: Download and install Oracle Virtualbox

Lecture 2 Oracle Virtualbox

Section 3: Download Grid, Database, Goldengate, Linux8.1 binaries

Lecture 3 Download binaries

Section 4: Create Virtual Machine and Install Linux8.1

Lecture 4 Create VM and Install Linux8.1

Section 5: Add 16 hard disks to the Linux Server

Lecture 5 Add 16 hard disks

Section 6: Clone Virtual Machine

Lecture 6 Clone Virtual Machine

Section 7: Network configuration to access Linux server

Lecture 7 Network configuration

Section 8: Copy Binaries to the server using winscp

Lecture 8 Copy Binaries using winscp

Section 9: Review Parameter file

Lecture 9 Review Parameter file

Section 10: Execute Automation Scripts

Lecture 10 Execute Automation Scripts

Section 11: The quickest way to create a database

Lecture 11 Create a database manually

Section 12: Review Automation Scripts

Lecture 12 Review Automation Scripts

Students who want to learn how to install and configure Grid and database with automation shell scripts,Students who want to learn how to install Linux operation system for Oracle,Database Administrators