Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Oracle RAC DBA Online Training

1 Reviews

Course type: Online Instructor led Course

Platform: skype

Course ID: 42006

Course type: Online Instructor led Course

Platform: skype

Students Interested 0 (Seats Left 0)

1 Reviews

About the Course

12c ORACLE RAC DBA Course Topics:


 


Available Courses:-



  • 11gr2/12c Oracle DBA.

  • 11gr2/12c Oracle RAC DBA.

  • 12c Oracle Golden Gate.

  • Shell/Perl scripting.


 


Course Name: - 12c Oracle RAC DBA


Course Duration: - Every day 90 minutes -- 30days (45 Hrs.)


Pre-requisite Knowledge: - Oracle DBA


 


Audience (Who can learn the RAC DBA):-


Administrator


Database Administrators


Technical Consultant


 


What you will learn from expert & experienced Real Time Professionals?


Describe the Oracle Cluster-ware architecture


Explain the principles and purposes of clusters


Describe the benefits of Oracle RAC


Describe global cache coordination


Explain the necessity of global resources


Describe how Grid Plug and Play affects Cluster-ware


Install the Grid-Infrastructure software & Oracle Database software


Define redo log files in a RAC environment


Define undo tablespaces in a RAC environment


Create database and Perform post-database-creation tasks


Modify initialization parameters in a RAC environment


Configure RMAN for the RAC environment


Configure the RAC database to use ARCHIVELOG mode and the fast recovery area


Convert a single-instance Oracle Database to RACs


Create a cluster database


Start and stop RAC databases and instances


 


Module 1 - BASIC OVERVIEW & CONCEPT


Chapter 1 - Grid Infrastructure Overview


What is Cluster?


What is Cluster-ware and Oracle Cluster-ware?


Oracle Flex Cluster, Hub Nodes, Leaf Nodes & its scalability


Oracle Cluster-ware Networking


Oracle Cluster-ware Initialization


GPnP Architecture: Overview & How it helps to Cluster Node Startup


Grid Naming Service (GNS)


Single Client Access Name


Client Database Connection


What is Oracle ASM?


ASM CloudFS and ACFS


Oracle Flex ASM


ASM Feature & Benefits


 


Chapter 2 - RAC Databases Overview & Architecture 11gr2 & 12c


Overview of Oracle RAC (Real Application Cluster)


Typical Oracle RAC Architecture


RAC One Node Single-Instance High Availability


Oracle RAC One Node


Oracle RAC One Node and Oracle Cluster-ware


Oracle Cluster-ware Storage Solution


Oracle Cluster File System


Oracle RAC and Network Connectivity


Benefits of Using Real Application Cluster


Cluster and Scalability & Level of Scalability


Scaleup, Speedup and Workloads


I/O Throughput Balanced: Example


Necessity of Global Resources


Additional Memory Requirement for RAC


Parallel Execution with RAC


 


Chapter 3 - Checklist to Install Grid Infrastructure software & RAC


Overview of 11gr2 & 12c Oracle Grid Infrastructure (GI)


Server Hardware requirement for Oracle Grid Infrastructure


Operating System requirement for Oracle Grid Infrastructure


Server Configuration requirement for Oracle Grid Infrastructure


Network requirement for Oracle Grid Infrastructure


Storage requirement for Oracle Grid Infrastructure


User Environment Configuration requirement for Oracle Grid Infrastructure


Chapter 4 - Overview of Oracle Cluster-ware & Its Components


What is Oracle Cluster-ware?


What is OCR (Oracle Cluster Registry)?


What is Voting Disk?


Concept of Virtual IPs


Concept of Single Client Access Name (SCAN)


SCAN VIP & SCAN Listeners


SCAN & DNS Server


SCAN & Host Files


Node Related Listener


 


Chapter 5 - Overview & Benefits Oracle Automatic Storage Management (ASM)


Overview of Oracle ASM


ASM Placement in Storage Stack


ASM Features & Advantage


ASM Instance & Parameters


ASM Disks & ASM Disk-Groups


ASM Disk-Group Redundancy


ASM Failure Group


ASM Files & Directories


Disk Group Rebalance


ASM Extents & Allocation Units


ASM Limits


Overview of 12c Flex Cluster Architecture & Flex ASM.


 


Module - 2 INSTALLATION & CONFIGURATION


Chapter 6 - Grid Infrastructure Pre-Installation Tasks


Verify System Requirement


Verify & Configure the Network Requirement


Install & Prepare the Required Operating System Packages, Set the Kernel Parameters


Create Group & Users & Configure the SSH (Password less connectivity)


Create Required Directories for Grid Infrastructure & RAC Database Installation


Configure the Shared Storage & Create the Oracle ASM Disk OR Disk Group


Configure the Required Owner Shell Limits


 


Chapter 7 - Installation of ORACLE 12c Grid Infrastructure software


Verify the Installation Requirement using Cluster Verification Utility


Install & Verify the Oracle Grid Infrastructure Software


 


Chapter 8 - Installation of ORACLE 12c Software & RAC Database creation


Installing Oracle 12c Software with Proper location


Creating RAC Database and verify


 


Module - 3 CONTROLLING & ADMINISTERING GRID INFRASTRUCTURE


Chapter 9 - Controlling and Managing Oracle Cluster-ware & Itâ??s Services


Use Cases of Oracle Cluster-ware


Oracle Cluster-ware Components, Processes & Services


Local & Cluster level Resources


Controlling & Verifying Oracle Cluster-ware using CRSCTL & SRVCTL utility


Star & Stop Oracle Cluster-ware & Oracle High Availability Services (OHAS)


Enable & Disable Oracle Cluster-ware & Oracle High Availability Services (OHAS)


Controlling the OCR & Voting disk using OCRCHECK, OCRCONFIG & OCRDUMP Utilities


Determine the location of Cluster Configuration files (OCR & Voting Disk)


Check the Integrity of Cluster Configuration files


Locating the OCR Auto-backup & Changing the Location of OCR Auto-backup


Manual Backup & Restore of OCR & Voting Disk


Controlling OLR (Oracle Local Registry)


Overview on (Oracle Interface Configuration) OIFCFG utility


 


Chapter 10 â?? Administrating 12c Flex Cluster-ware


Verifying the Cluster mode


Verifying the Role Node (Hub/Leaf)


Verifying the Oracle ASM mode


Listing the ASM Instances & Listeners


 


Chapter 11 â?? Oracle Cluster-ware Log & Use Case of ADRCI Utility


ADR Directory Structure & ADRCI


Oracle Cluster-ware trace files and Alert Log file


Normal trace files & Incident Trace files


Collecting Oracle Cluster-ware Diagnostic data


Purging Automatic Workload Repository (All Incidents & Trace Files)


Diagnostics Collection Script


 


Chapter 12 â?? Cluster-ware Health Monitor & Advisor


Overview of monitoring Oracle Cluster-ware


Cluster Health Monitor (CHM) & Cluster Health Advisor (CHA)


Oracle 12c Grid Infrastructure Management Repository (GIMR)


Collecting CHM data


Managing CHM with OCLUMON


Chapter 13 â?? Cluster-ware Health Checkup via CVU utility


Cluster Verification Utility Overview


Verify Cluster Components using CVU


Cluster Verify Locations


Cluster Verify Configuration files


 


Chapter 14 â?? Administrating ASM Instance


Parameters related to ASM Instance


Parameter files for ASM Instance


Modifying the ASM Parameters


Managing ASM password files


Shared Oracle ASM Password file in Disk-Group


Start & Stop ASM Instance using SRVCTL utility


ASM Dynamic Performance Views


 


Chapter 15 â?? Administrating ASM Disks & Disk-Groups


Overview of Disks & Disk Groups


Create the New Disks


Create the New Disk Group using SQL*Plus & ASMCA


Altering the Disk Groups


Adding, Removing & Renaming the Disk Groups


Resizing the Disks in Disk Group


Attributes & Viewing the Attributes of Disk Groups


Checking the consistency of Disk Group Metadata


Mounting & Dismounting the Disk Groups


Dropping the Disks from Existing Disk Groups


Dropping the Disk Groups


ASM Failure Groups


 


Chapter 16 â?? Administrating ASM Files, Directories & Templates


Interaction between Database Instances & ASM Instances


Accessing ASM Files by using RMAN


Accessing ASM Files by Using DBMS_FILE_TRANSFER


Accessing ASM Files by Using ASMCMD


View ASM Aliases, Files, and Directories


ASM ACL (Access Control Lists) Disk Group Attributes


Managing ASM ACL with ASMCMD & SQL*Plus commands


 


 


 


Chapter 17 â?? Overview of Oracle Cloud FS


Overview of Oracle Cloud File System


ASM files and Volumes


ACFS & ADVM Architecture Overview & Itâ??s Processes


Using ASMCMD for Dynamic Volumes


Configuration Settings for Database Files


List of ACFS Views


Oracle Cloud FS Advanced Topics


 


Module - 4 CONTROLLING & ADMINISTERING ORACLE RAC DBs


Chapter 18 â?? Oracle RAC Database Overview & Architecture


Overview of Oracle RAC Database


Typical Architecture of Oracle RAC Database


Oracle Cluster-ware Storage Solution


Global Resource in RAC


Need of GCS, GES & GRD (Global Resource Directory)


Concept of Cache Fusion


 


Chapter 19 â?? Administering Oracle RAC Database & Instance


Overview of RAC DB Administration


Starting & Stopping RAC Instance with SQL*Plus and SRVCTL utility


Starting & Stopping Pluggable Database in Oracle RAC


Switch between Automatic & Manual Database Restart Policy


RAC Initialization Parameter files


SPFILE Parameter Values and RAC


Parameter Files Search Order in Oracle RAC


Parameters that Require Identical Settings & Parameters that Require Unique Settings


Terminating Sessions in Oracle RAC Database


 


Chapter 20 â?? Managing Backup & Recovery for Oracle RAC Database


Overview Instance Recovery & Database Availability


Instance Recovery on RAC DB concepts


RAC and the Fast Recovery Area


Enable Archive log mode in RAC


Configuring RMAN Snapshot Control file Location


Configuring Control file and SPFILE auto backup


Channel Connections to RAC Instances


Configuring Non-Cluster & Local Archiving


Restore & Recovery on Oracle RAC DB


Cloning of Oracle RAC DB


Chapter 21 â?? Managing High Availability of Services


Service Usage in Oracle RAC Database


Characteristics of a Service


Default Service Connections & How to Restricted Service Registration


Create the Services with Preferred & Available Instance


Managing Services with SRVCTL utility


Using Services as TNS Entry for Client Applications


Services & Connection Load Balancing


Services and Transparent Application Failover (TAF)


Define a TAF Policy for a Service


TAF Configuration on Server Side & Client Site


Lists of Service Performance Views


 


Chapter 22 â?? Migrating File System Database to ASM


Why migrate to ASM?


 Basic concepts of migrating to ASM


 Preparing to migrate to ASM


 Migrating Database to ASM


 


Chapter 23 â?? Converting Single Instance Database to Multi-node (RAC) Database


Overview of different Methods/Tools


 About RCONFIG utility


 Preparing XML file


 Converting to RAC using RCONFIG


 Verifying the conversion


 


Chapter 24 â?? Upgrading & Patching Oracle RAC Database


Patch & Patch-set Overview


Types of Patches


Configuring the Software Library


Downloading the Patches


Reducing the Downtime Patching for Oracle RAC Database


OPatch Overview, General Use & OPatch Automation


Rolling Patch


Out-of-Place Oracle RAC DB upgrade with OUI


 

Date and Time

Not decided yet.

About the Trainer

Gulasan Mishra picture

5 Avg Rating

13 Reviews

14 Students

6 Courses

I have 5+ years of experience as Oracle RAC DBA and Golden Gate expert.I have passion to share my technical knowledge and real time working professional experience.I give training on Oracle DBA, Oracle RAC DBA and Oracle Golden Gate Technologies.

Student Feedback

5.0

Average Rating

100%
0%
0%
0%
0%

Reviews

S

Srinivas Karra

I learned Oracle RAC from Gulasan. Gulasan is a passionate and effective teacher, infusing each lesson with immense knowledge. He explains concepts clearly, concisely, and always answers questions well. If required he will go beyond what needs to be covered and explains in detail. I highly recommend him.

Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Oracle Training Post your requirement now

Enquire

Submit your enquiry for Oracle RAC DBA Online Training

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Gulasan

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more