Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Oracle Real Application Cluster

Learn all the secrets to set a 2 nodes Oracle RAC with your virtual machine. The perfect simulaton for training !

Created byLuis Diaz

Last updated 5/2015

English

English [Auto],

What you'll learn

Install and set from scratch a 2 node cluster with Oracle 12c technology
Know all the important point to set a cluster with Oracle
Install and set Oracle virtual box for RAC
Install and set linux 6.6 64bits for RAC
Create and present shared disks to simulate you have a storage array
Install, configure and use oracle asmlib libraries to map the shared disks to ASM disks
Know and practice with the most important cluster command lines

Course content

5 sections • 45 lectures • 7h 32m total length

Teacher presentation3:58
Topics of block 13:00
Get Oracle virtual box and prepare the operating system installation9:06
Installation of Oracle linux 64 bits13:04
Yum maniac, install rpm, set kernel parameters in one shot19:27
Last steps before clone rac1 and create rac210:27
Create the second node with virtualbox clone option11:29
Clone the first node in VirtualBox to create the second node, then configure unique MAC addresses, update network adapters, and change the hostname and IP to complete the clone.
Configure network in node 2, download binaries for GI 12c install15:20
Storage managment: Creation of shared disk and map with ASM lib7:44
Map shared disk as ASM devices with asmlib11:22
Manage ssh equivalence between rac1 and rac210:53
Use Cluster verify script. Make a check before GI install11:37
Use Cluster verify script Part II10:20
Master cluster verify script part II by diagnosing package checks, DNS server settings, and hosts file configuration, while preparing and validating multi-node Oracle Real Application Cluster installations.
Steps of all the block 1 lectures16:00
End of block 13:00

Topics of block 23:00
Install GI in graphic mode, with runInstaller Part I15:10
Install GI in graphic mode, with runInstaller Part II16:00
Install GI in graphic mode, with runInstaller Part III10:30
Install GI in silent mode with response file, Part I15:18
In this lesson we'll see in details the response file
Install GI in silent mode with response file, Part II14:49
Here we'll install GI in both nodes with the silent option
Install GI in silent mode with response file, Part III5:30
This is the last step of the silent instalation
Create ASM env file, enter sqlplus, see some admin querys11:36
end of block 23:00

Topics of block 33:00
Creation of the diskgroup DATA with 3 different methods11:34
Create the diskgroup DATA using three methods: command-line with corrected syntax, graphical interface, and silent-mode scripting, and verify the mount across instances.
Creation of TURTLE database with cluster options, part I15:00
Creation of TURTLE database with cluster options, part II8:50
Learn to create a TURTLE database within an Oracle Real Application Cluster setup, including configuring two instances, transitioning from single to cluster mode, and validating the clustered installation.
Creation of TURTLE database, PART III7:05
Learn to create a two-instance turtle database within an Oracle real application cluster, guiding the installation process, validating instance readiness, and verifying completion through administration views.
Creation of TURTLE database, PART IV8:58
Creation of TURTLE database: dbca silent mode12:59
Learn to create a database instance in Oracle Real Application Cluster using dbca silent mode, selecting templates and seeds, configuring parameters, and verifying instances with queries.
The SRVCTL command, PART I12:28
Learn to use the srvctl command line to manage Oracle real application clusters, view resources, monitor status, and perform safe startup and backups.
The SRVCTL command, PART II7:38
The SRVCTL command, PART III12:56
Explore Oracle Real Application Clusters management with the srvctl command, learning to create, start, stop, and manage services and perform switchover across cluster instances.
The SRVCTL command, end9:44
End of block 33:00

Requirements

For this course you'll need: a laptop o Pc with at least 6G RAM and 70G free space
You need a adsl connection to download all the software
We'll install Oracle virtual box, Oracle linux 64bits, Grid infrastructure 12c and rdbms 11gR2

Description

Welcome to this Real Application Cluster couse

During these moments that we spend together, I have only one goal, that you enjoy setting a professional high-tech environment. Grid Infrastructure 12c, data base 11gR2 both products were installed in graphic and silent mode.

All these products involve the execution of different tasks defined below.

The course have been produced with videos, you'll also listen my voice. I will give all explanations and examples relevant to the successfull anderstanding of this course.

In addition, I will make available the "roadmap" that I used throughout the course with all the querys and operating system commands, this way you can use it to copy and paste into your environment.

The course is about 4 hours and you'll find the following chapters:

1 Installation and setting of Oracle VirtualBox, creation of RAC1 Virtual Machine (VM)

2 Installation of Oracle linux 64 bits operating system

3 Setting network cards and the /etc/hosts file

4 Tune RAC1 with yum: Kernel parameters, packages dependencies, user and groups

5 Clone RAC1 to RAC2, the second node of our Oracle RAC cluster

6 Creation of the shared disks from virtual box and present them to both racs

7 Creation of ASM disk for subsequent creation of diskgroups

8 Installation of the binaries GI 12c

Set the ssh connectivity between node 1 and node 2

Run runcluvfy to get all the check results

At this step if all is good, you have your first cluster 12c !

9 Installation of GI 12c silent mode

10 Installing Oracle 11gR2 binaries (graphic and silent)

11 Creating Database 11gR2 data (graphic and silent)

12 Learn all the command available to manage your cluster

With this course, you have in your hand a powerful environment, created with the last version of Oracle products and for a very low cost. You can simulate a production environment at home with your personal computer.

Who this course is for:

This course is for dba that have at least install one Oracle database
It's better that studiants have any knowledge of linux and network

Oracle Real Application Cluster

What you'll learn

Explore related topics

Course content

Virtual machine and nodes preparation15 lectures • 2hr 37min

Installation of GI for cluster graph and silent mode9 lectures • 1hr 35min

Rdbms creation for cluster, and srvctl command12 lectures • 1hr 53min

What is an Oracle cluster ?4 lectures • 51min

Crsctl command line and practices5 lectures • 37min

Requirements

Description

Who this course is for: