Oracle RAC Administration Training

Teacher

Categories

Review

5/5 (3)

$2,700.00

In this class Oracle Certified Master John Watson will teach you how to install, configure and manage Oracle 12c|18c|19c Real Application Clusters databases. The course is backward compatible to 11g R2. Emphasis is placed on manual, command line techniques, though a lesson on managing RAC with 12c Enterprise Manager Express (“EM Express”) is included.

Knowledge of the single instance database architecture is a prerequisite. Detailed knowledge of Grid Infrastructure (ASM and Clusterware) is not essential, but may be beneficial.

Each student is provided with a pre-built cluster, with Grid Infrastructure and shared storage (both ASM and a clustered file system) configured.

The course is workshop oriented: students will go through practical exercises that cover all the tasks likely to be needed when creating, migrating to, and administering RAC databases.

Related Classes

Oracle RAC, Grid Infrastructure and ASM Training

Oracle ASM Training

Oracle Grid Infrastructure Training

In this 3 day class (~20 hours online) Oracle Certified Master John Watson will teach you how to install, configure and manage Oracle Real Application Clusters databases. Emphasis is placed on manual, command line techniques. Knowledge of the single instance database architecture is a prerequisite. Detailed knowledge of Grid Infrastructure (ASM and Clusterware) is not essential, but may be beneficial.Each student is provided with a pre-built cluster, with Grid Infrastructure and shared storage (both ASM and a clustered file system) configured. The course is workshop oriented: students will go through practical exercises that cover all the tasks likely to be needed when creating, migrating to, and administering RAC databases.

Configuring MAA (Maximum Availability Architecture, RAC plus Data Guard) is discussed and (time, interest, and background knowledge permitting) can be included as demonstration or exercise.

Objectives

Create clustered databases, convert from single instance to RAC
Carry out basic RAC administration, backup and recovery, and performance tuning
Configure RAC database services for zero downtime
Use GI to manage virtual IP addresses
Configure shared storage

Related Classes

Oracle RAC, Grid Infrastructure and ASM (Fast Track, 5 Days)

Oracle Grid Infrastructure (3 Days)

Free Tutorials

Oracle RAC Tutorial

Oracle Grid Infrastructure Tutorial

Oracle ASM Tutorial

Course Features

Lectures 0
Quizzes 0
Duration 3 Days
Skill level All levels
Language English
Students 7
Certificate Yes
Assessments Yes

RAC and Grid Infrastructure Architectural summary

ASM and share storage
The SCAN and node listener model
RAC solutions

Real Application Clusters Database Installation

Installing The Oracle Database Software
Single Instance to RAC conversion
Creating A Cluster Database

Oracle RAC Administration

Redo Log Files In A RAC Environment
Undo Tablespaces In A RAC Environment
Starting And Stopping RAC Databases And Instances
Initialization Parameters In A RAC Environment

Managing Backup and Recovery for RAC

Protecting Against Media Failure
Archived Log File Configurations
Database Backup and Recovery with RMAN
Recovery following instance failure

Performance Tuning

The Tuning Methodology
The global cache and the global enqueue service
RAC Specific Statistics and Wait Events
Tuning Parallel Processing
RAC Specific Performance Issues
AWR and Statspack in a clustered environment

High availability and services

RAC Service Architecture
Configure and Manage Services in a RAC environment
Using Services with Client Applications
The fault tolerant architecture
Instance evictions
Policy managed databases and services
Stretched clusters
Maximum availability Architecture: RAC plus Data Guard

Practical Exercises

Install a RAC database home
Convert a single instance database to RAC
Create a RAC database
Configure RMAN for a RAC database
Backup, restore, and recover a RAC database
Tune parallel query and parallel DML in a RAC
Convert databases between administrator management and policy management
Use services for high availability and load balancing
Set up session connect time load balancing and fault tolerance
Configure session failover

John Watson

https://skillbuilders.com/our_team/john-watson/

Leave A Review

Please provide as much detail as you can to justify your rating and to help others.

Did he clearly defined the objectives for this course?

Was he prepared for the class?

Did he know the subject matter?

Did he Answer your questions satisfactorily?

Did he possess strong presentation skills?

Did he show enthusiasm?

Were the course notes were clear and concise?

Did the course content meet your training needs?

Did the exercises and workshops reinforced the concepts taught?

Did the course met stated objectives?

Would you recommend this course to your friends and colleagues?

What did you particularly like about the course?

Please describe your suggestions for improvement of the course.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?

4.9/5

What did you particularly like about the course?
The 2 week duration of course had my attention and that was because of the strength of the course material and knowledge skills of Mr. John. Overall, it was a privilege to get training from one of the best oracle experts.

Please describe your suggestions for improvement of the course.
Add more content for diagnosing clusterware issues - add demos/exercises
Add more contents for Database (SQL) performance Tuning

Anju Gandhi

August 17, 2015

5/5

What did you particularly like about the course?
John brought a lot of energy to the class and was always prepared for the material he was going to cover. John was always open to having questions asked and always answered them with just the right amount of detail for where we were in the course. He wo

Please describe your suggestions for improvement of the course.
The training manual included was a little small and a little difficult to make notes on, especially because of the large spiral bind. It just made note taking on the page being covered a bit difficult so I needed to use a separate pad and make sure I not

Lupe Garcia

August 17, 2015

5/5

What did you particularly like about the course?
John's enthusiasm is viral. He is excited about any questions or problems we throw at him.
His wealth of knowledge is inspiring.

The ability to have hands on experience on our own system each is essential.

Please describe your suggestions for improvement of the course.
For every subject, reference to oracle documentation or metalink number would be great.

I took notes of keywords for concepts presented throughout the course to deepen my knowledge later on, but providing metalink doc ids or reference to books or paper

Nicolas de Fontenay

August 17, 2015