Oracle Real Application Cluster

Learn all the secrets to set a 2 nodes Oracle RAC with your virtual machine. The perfect simulaton for training !
4.2 (18 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
293 students enrolled
Instructed by Luis Diaz Development / Databases
$20
Take This Course
  • Lectures 45
  • Contents Video: 6 hours
    Other: 1.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 5/2015 English

Course 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.

What are the 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

What am I going to get from this course?

  • 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

What is the target audience?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Virtual machine and nodes preparation
Teacher presentation
Preview
03:58
Topics of block 1
3 pages
Get Oracle virtual box and prepare the operating system installation
09:06
Installation of Oracle linux 64 bits
13:04
Yum maniac, install rpm, set kernel parameters in one shot
19:27
Last steps before clone rac1 and create rac2
10:27
Create the second node with virtualbox clone option
11:29
Configure network in node 2, download binaries for GI 12c install
15:20
Storage managment: Creation of shared disk and map with ASM lib
07:44
Map shared disk as ASM devices with asmlib
11:22
Manage ssh equivalence between rac1 and rac2
10:53
Use Cluster verify script. Make a check before GI install
11:37
Use Cluster verify script Part II
10:20
Steps of all the block 1 lectures
16 pages
End of block 1
3 pages
Section 2: Installation of GI for cluster graph and silent mode
Topics of block 2
3 pages
Install GI in graphic mode, with runInstaller Part I
15:10
Install GI in graphic mode, with runInstaller Part II
16:00
14:49

Here we'll install GI in both nodes with the silent option

Install GI in graphic mode, with runInstaller Part III
10:30
15:18

In this lesson we'll see in details the response file

05:30

This is the last step of the silent instalation

Create ASM env file, enter sqlplus, see some admin querys
11:36
end of block 2
3 pages
Section 3: Rdbms creation for cluster, and srvctl command
Topics of block 3
3 pages
Creation of the diskgroup DATA with 3 different methods
11:34
Creation of TURTLE database with cluster options, part I
15:00
Creation of TURTLE database with cluster options, part II
08:50
Creation of TURTLE database, PART III
07:05
Creation of TURTLE database, PART IV
08:58
Creation of TURTLE database: dbca silent mode
12:59
The SRVCTL command, PART I
12:28
The SRVCTL command, PART II
07:38
The SRVCTL command, PART III
12:56
The SRVCTL command, end
09:44
End of block 3
3 pages
Section 4: What is an Oracle cluster ?
Details of the requisits
21 pages
What is a cluster ?
20 pages
All steps txt file
Preview
Article
End of block 4
3 pages
Section 5: Crsctl command line and practices
Topics of block 5
3 pages
crsctl by the example, part I
12:32
crsctl by the example, part II
08:16
Practice with crsctl, move location of crs metadata
09:42
End of course
3 pages

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Luis Diaz, Database dba since 2005

I was born in Spain and then travel to Paris where I start studying databases.

Then I go back to Spain and since 2005 I work exclusivly as Oracle dba. During several years I work in diferents environments and I touch a lot of Oracle technology. Here is part of this knowledge. Most recently, I work with Oracle 12c grid version, Oracle dataguard 11g and some other technologies as Rman o Oracle FlashBack.

Citare aqui unas de las operaciones que realize con exito:

- Mantenimiento de las instancias de Oracle

- Migración Grid control de 10G a 11G

- Migración de datos de un diskgroup a otro. (Cambiar discos de cabina)

- Copia de seguridad diseño de las políticas de recuperación de las bases de datos

- Instalación diseño e instalación de nuevo RAC entornos ASM ersión 11gR2

- Seguimiento con las herramientas de monitoring de OVO, Grid Control y Ganglia

- Creación de nuevas alarmas para OVO

- Restoración de bases de datos con RMAN duplicate

- Formación de un equipo de desarolladores con Oracle FlashBack. Simulamos perdidas de datos tras una release y recuperamos los datos perdidos gracias a FB

Ready to start learning?
Take This Course