• 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 NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration
  • Systems Development