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

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 go for this training?
The following professionals can go for this course:

  • Administrator
  • Architect
  • Database Administrator
  • OS Administrators

What are the pre-requisites for this Course?

  • Oracle DBA

Course Content

  • 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
  • Flex Cluster architecture and components
  • The effect of node failure in a Flex Cluster
  • Check clusterware background processes
  • Understand Clusterware startup sequence
  • Check Failover of VIP’s
  • Check High Availability of ASM Instance
  • 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
  • Describe the architecture and components of Flex ASM
  • Install and configure Flex ASM
  • Administer Flex ASM
  • 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
  • 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
  • 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
  • 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
  • Describe the high-availability components of Oracle Clusterware
  • Contrast policy-managed and administration-managed databases
  • Create an application Virtual IP (VIP)
  • Manage application resources
  • Perform the prerequisite steps to extend a cluster
  • Use addNode.sh to add a node to a cluster
  • Delete a node from a cluster
  • 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
  • Clusterware Architecture & components
  • VIP’s, Scan Listener & GNS concepts
  • Clusterware background processes
  • Clusterware Startup details
  • Perform Pre Installation Tasks
  • Install Grid Infrastructure
  • Verify the installation
  • Configure Automatic Storage Management (ASM) disk groups
  • 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
  • Automatic Storage Management (ASM) architecture
  • Components of ASM
  • Explain and apply Automatic Storage Management  (ASM) initialization parameters
  • Manage ASM instances and associated processes
  • Monitor ASM
  • Describe the benefits of Oracle RAC
  • Explain the necessity of global resources
  • Describe global cache coordination
  • Install the Oracle database software
  • Create a cluster database
  • Perform post-database-creation tasks
  • Convert a single-instance Oracle database to RAC
  • The RAC database to use ARCHIVELOG mode and the fast recovery area
  • RMAN for the RAC environment
  • 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
  • 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)
  • 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

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

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.

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.

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

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

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.

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

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

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.

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