• Online, Self-Paced
Course Description

Installing, upgrading, and patching are essential tasks for any DBA, ensuring outages due to software problems are kept to a minimum. This course provide the skills to implement and maintain Oracle RAC software in a production environment and also covers creating a RAC database and understanding all the options available when creating a RAC database. The course also covers converting a single-instance database to RAC and the administration of Oracle RAC One Node. This course is one of a series in the Skillsoft learning path that cover a portion of the objectives for exam 1Z0-068 Oracle Database 12c: RAC and Grid Infrastructure.

Learning Objectives

Installing and Configuring Oracle RAC

  • start the course
  • perform an Oracle Database software installation
  • start the database configuration assistant and begin the process of creating a new database
  • use the database configuration assistant to perform steps 4 through 8 of creating a new database
  • complete the creation of a new database and describe the different memory management options
  • describe the RAC specific background processes
  • list the considerations for converting single-instance databases to Oracle RAC
  • list the steps for converting single-instance databases to Oracle RAC using Database Configuration Assistant and rconfig


Upgrading and Patching Oracle RAC

  • describe the different types of patches available for Oracle RAC
  • describe how to find the correct patches for your software and how to download them from Oracle Support
  • describe how to apply a patch with zero downtime using the rolling patch method
  • list the steps to perform an out-of-place upgrade of an Oracle RAC database
  • describe what OPatch is and identify the use cases for OPatch
  • use OPatch to query and apply patches
  • patch the Grid home and all Oracle RAC database homes in one step
  • view OPatch log and trace files and use a SQL interface to view the database patches


Oracle RAC One Node

  • define the concept of Oracle RAC One Node and describe some of the benefits of using Oracle RAC One Node
  • describe how to create a new RAC One Node database and how to verify an existing RAC One Node database
  • describe the RAC One Node online relocation process and list some of the considerations involved in an online relocation
  • perform an online relocation and describe how rolling patches can be applied using online relocation
  • describe how to convert a RAC One Node Database to RAC
  • describe how to convert a single-instance to RAC One Node and how to convert a RAC database to RAC One Node


Practice: Converting Single-instance to RAC

  • use DBCA to convert a single-instance database to a RAC database


Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.