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