Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Virtual machine and nodes preparation|
Topics of block 1
Get Oracle virtual box and prepare the operating system installation
Installation of Oracle linux 64 bits
Yum maniac, install rpm, set kernel parameters in one shot
Last steps before clone rac1 and create rac2
Create the second node with virtualbox clone option
Configure network in node 2, download binaries for GI 12c install
Storage managment: Creation of shared disk and map with ASM lib
Map shared disk as ASM devices with asmlib
Manage ssh equivalence between rac1 and rac2
Use Cluster verify script. Make a check before GI install
Use Cluster verify script Part II
Steps of all the block 1 lectures
End of block 1
|Section 2: Installation of GI for cluster graph and silent mode|
Topics of block 2
Install GI in graphic mode, with runInstaller Part I
Install GI in graphic mode, with runInstaller Part II
Here we'll install GI in both nodes with the silent option
Install GI in graphic mode, with runInstaller Part III
In this lesson we'll see in details the response file
This is the last step of the silent instalation
Create ASM env file, enter sqlplus, see some admin querys
end of block 2
|Section 3: Rdbms creation for cluster, and srvctl command|
Topics of block 3
Creation of the diskgroup DATA with 3 different methods
Creation of TURTLE database with cluster options, part I
Creation of TURTLE database with cluster options, part II
Creation of TURTLE database, PART III
Creation of TURTLE database, PART IV
Creation of TURTLE database: dbca silent mode
The SRVCTL command, PART I
The SRVCTL command, PART II
The SRVCTL command, PART III
The SRVCTL command, end
End of block 3
|Section 4: What is an Oracle cluster ?|
Details of the requisits
What is a cluster ?
All steps txt filePreview
End of block 4
|Section 5: Crsctl command line and practices|
Topics of block 5
crsctl by the example, part I
crsctl by the example, part II
Practice with crsctl, move location of crs metadata
End of course
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