• Online, Self-Paced
Course Description

Enterprise Manager Cloud Control is a valuable tool in the day-to-day administration tasks of an Oracle RAC database. This course covers using Enterprise Manager and command-line utilities to manage an Oracle RAC database. Some of the topics covered in this course are understanding and modifying RAC specific initialization parameters, working with online redo log files and managing RAC instances. The course also covers converting a single instance database to RAC. 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

Administering RAC with Enterprise Manager

  • start the course
  • use the Enterprise Manager Cluster Database home page to view information pertaining to the cluster database as a whole
  • use the Enterprise Manager Cluster Database Instance home page as a starting point for performance, administration, and maintenance tasks
  • use the Enterprise Manager Cluster Home Page to view summary and detailed information about the cluster
  • use Enterprise Manager Cloud Control to manage metrics, alerts, and blackouts for Oracle RAC
  • use Enterprise Manager Database Express to view and manage a RAC database

 

General RAC Administration

  • manage redo log files in a RAC database
  • describe how undo tablespaces are used in RAC
  • use srvctl and SQL*Plus to stop and start RAC instances
  • use services to manage pluggable databases (PDBs) in Oracle RAC
  • describe automatic and manual management policies and use srvctl to switch between them
  • quiesce and unquiesce a RAC database
  • find and terminate a session on a specific RAC instance
  • describe how SQL statements affect the current instance or all instances
  • manage the keystore for Transparent Data Encryption when using Oracle RAC

 

Initialization Parameters in Oracle RAC

  • work with the spfile in an Oracle RAC database
  • change Oracle RAC database parameters
  • use Enterprise Manager to manage initialization parameters
  • describe RAC specific initialization parameters and initialization parameters that can affect RAC
  • describe parameters that require identical settings across RAC instances

 

Practice: RAC Administration Tasks

  • change the processes parameter for one RAC instance and confirm the change with Enterprise Manager

 

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.