19c RAC Clusterware and Database Administration

The Oracle Clusterware and Database Administration course describes the Oracle Clusterware architecture and provides an overview of this product. This course also describes administrative and deployment topics for Oracle Clusterware.

Information in this course applies to Oracle Clusterware as it runs on all platforms unless otherwise noted. In addition, the content of this manual supplements administrative and deployment topics for Oracle single-instance databases that appear in other Oracle

Course Overview

Course Objective

What will you learn?

  • Configure RMAN for the RAC environment
  • Describe the benefits of Oracle RAC
  • Explain the necessity of global resources
  • 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
  • ain an understanding of the Oracle Database Exadata Cloud Service
  • Explain the principles and purposes of clusters
  • Install the Oracle Database software
  • Modify initialization parameters in a RAC environment
  • Perform post-database-creation tasks
  • Define redo log files in a RAC environment
  • Define undo tablespaces in a RAC environment
  • Describe global cache coordination
  • Describe how Grid Plug and Play affects Clusterware
  • Describe the Oracle Clusterware architecture

Who Should Learn

Who should go for this training?
The following professionals can go for this course:

  • Administrator
  • Architect
  • Database Administrator
  • OS Administrators

Prerequisite

What are the pre-requisites for this Course?

  • Oracle DBA

Course Content

1. Introduction to Grid Infrastructure and Clusterware

  • Explain the principles and purposes of clusters
  • Describe cluster hardware best practices
  • Describe the Oracle Clusterware architecture
  • Describe how Grid Plug and Play affects Clusterware

3. Flex Clusters

  • Flex Cluster architecture and components
  • The effect of node failure in a Flex Cluster

5. Post Installation tasks and Clusterware Verification

  • Check clusterware background processes
  • Understand Clusterware startup sequence
  • Check Failover of VIP’s
  • Check High Availability of ASM Instance

7. Troubleshooting Oracle Clusterware

  • Locate the Oracle Clusterware log files
  • Gather all log files by using diagcollection.pl
  • Enable resource debugging
  • Enable component-level debugging
  • Enable tracing for Java-based tools
  • Troubleshoot the Oracle Cluster Registry (OCR) file

9. Flex ASM

  • Describe the architecture and components of Flex ASM
  • Install and configure Flex ASM
  • Administer Flex ASM

11. Administering ASM Disk Groups

  • Create and delete Automatic Storage Management (ASM) disk groups
  • Set the attributes of an existing ASM disk group
  • Perform ongoing maintenance tasks on ASM disk groups
  • Explain key performance and scalability considerations for ASM  disk groups

13. Global Resource Management Concepts

  • The need for global concurrency control
  • Global Resource Directory
  • How global resources are managed
  • RAC global resource access coordination
  • Global enqueue and instance lock management
  • Global buffer cache management

15. Oracle RAC Administration

  • Use Enterprise Manager Cluster Database pages
  • Define redo log files in a RAC environment
  • Define undo tablespaces in a RAC environment
  • Start and stop RAC databases and instances
  • Modify initialization parameters in a RAC environment

17. RAC Database Monitoring and Tuning

  • Determine RAC-specific tuning components
  • Determine RAC-specific wait events, global enqueues, and system statistics
  • Implement the most common RAC tuning tips
  • Use the Cluster Database Performance pages
  • Use the Automatic Workload Repository (AWR) in RAC
  • Use Automatic Database Diagnostic Monitor (ADDM) in RAC

19. Making Applications Highly Available with Oracle Clusterware

  • Describe the high-availability components of Oracle Clusterware
  • Contrast policy-managed and administration-managed databases
  • Create an application Virtual IP (VIP)
  • Manage application resources

21. Managing Cluster Nodes

  • Perform the prerequisite steps to extend a cluster
  • Use addNode.sh to add a node to a cluster
  • Delete a node from a cluster

23. Oracle RAC One Node

  • Perform an online database migration
  • Add an Oracle RAC One Node Database to an existing Cluster
  • Convert an Oracle RAC One Node database to a RAC database
  • Use DBCA to convert a single instance database to a RAC One  Node database

2. Oracle Clusterware Architecture

  • Clusterware Architecture & components
  • VIP’s, Scan Listener & GNS concepts
  • Clusterware background processes
  • Clusterware Startup details

4. Grid Infrastructure Installation

  • Perform Pre Installation Tasks
  • Install Grid Infrastructure
  • Verify the installation
  • Configure Automatic Storage Management (ASM) disk groups

6. Traditional Clusterware Management

  • Demonstrate your Clusterware management proficiency
  • Demonstrate Oracle Cluster Registry (OCR) backup and  recovery techniques
  • Manage network settings
  • Describe the scope and capabilities of what-if command  evaluation

8. ASM Overview & Architecture

  • Automatic Storage Management (ASM) architecture
  • Components of ASM

10. Administering ASM Instances

  • Explain and apply Automatic Storage Management  (ASM) initialization parameters
  • Manage ASM instances and associated processes
  • Monitor ASM

12. RAC Databases Overview & Architecture

  • Describe the benefits of Oracle RAC
  • Explain the necessity of global resources
  • Describe global cache coordination

14. Installing and Configuring Oracle RAC

  • Install the Oracle database software
  • Create a cluster database
  • Perform post-database-creation tasks
  • Convert a single-instance Oracle database to RAC

16. Managing Backup and Recovery for RAC

  • The RAC database to use ARCHIVELOG mode and the fast recovery area
  • RMAN for the RAC environment

18. Managing High Availability of Services

  • Configure and manage services in a RAC environment
  • Use services with client applications
  • Use services with the Database Resource Manager
  • Use services with the Scheduler
  • Configure services aggregation and tracing

20. High Availability for Connections and Applications

  • Configure client-side connect-time load balancing
  • Configure client-side connect-time failover
  • Configure server-side connect-time load balancing
  • Use the Load Balancing Advisory (LBA)
  • Describe the benefits of Fast Application Notification  (FAN)
  • Configure server-side callouts
  • Configure the server- and client-side ONS
  • Configure Transparent Application Failover (TAF)

22. Upgrading, Patching Grid Infrastructure and Oracle RAC

  • Describe the types of patches and upgrades available
  • Plan for rolling patches and rolling upgrades
  • Compare software versions with the active version
  • Install a patchset with the Oracle Universal Installer (OUI) utility
  • Install a patch with the opatch utility

Modes of Training

Classroom Training

Live interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.

Online Training

Learn from anywhere over the internet, joining the live sessions delivered by our expert trainers.

Self-Pace Training

Learn through pre-recorded video sessions delivered by experts at your own pace and timing.

Frequently Asked Questions

Who are the trainers?

Our trainer is an OCP & OCM certified consultant and has a significant amount of experience in working with the technology, having 18yrs of experience.

How do I join the live sessions?

Once you get registered, our back-end team will share you the details to join the session live over an online portal which can be accessed through a browser.

What if I miss a class?

Each of our live sessions is recorded. In case if you miss any, you can request us to share the link to that particular session.

How will I execute the practical?

For practical execution, our trainer/technical team will provide server access details to the student

Will you help us in building our own Lab Setup in our local Desktop/Laptop?

Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.

What is the difference between live online and pre-recorded video training?

Live-Online training is where you can have a live session with the trainer and clarify queries parallelly.

Pre-recorded sessions are the recorded videos that will be provided to you that you can see, listen, and learn anytime at ur feasible place. For doubts in the videos, you can mail the trainer regarding the same.

What if I have queries after completion of the class?

You can contact our support team, or just drop an email to help@sarinfotechindia.com with your queries.

Is the course material accessible after completion of the course?

The course material and recorded videos which are provided during the course period. You can download it anytime.

Any offer/discount that I can avail?

Visit our website regularly to check discounts offers from time to time. However, we provide a discount for single participants & special discounts for 2 or more participants.

Will I get the refund if I cancel my enrollment?

* If the request for cancelation is made within 2 days of enrolment for class, 100% refunded.

* If the request made after 2 days, then Refund is made after deduction of the administration fee.