Grid Infrastructure

• Explain the principles and purposes of clusters

• Describe the Oracle Clusterware architecture

• Describe how Grid Plug and Play affects Clusterware

RAC Databases and Architecture

• Describe the benefits of Oracle RAC

• Explain the necessity of global resources

• Describe global cache coordination

Installing and Configuring Oracle RAC

• Install the Oracle database software

• Create a cluster database

• Perform post-database-creation tasks

• Convert a single instance Oracle database to RAC

Administering Oracle RAC

• 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

Managing Backup and Recovery for RAC

• Configure the RAC database to use ARCHIVELOG mode and the fast recovery area

• Configure RMAN for the RAC environment

Managing Global Resources

• Explain the need for global concurrency control

• Describe the Global Resource Directory

• Explain how global resources are managed

• Explain global enqueue and instance lock management

• Explain global buffer cache management

RAC Database Monitoring and Tuning

• Identify RAC-specific tuning components

• Determine RAC-specific wait-events, global enqueues and system statistics

• Implement the most common RAC tuning practices

• Use the Cluster Database Performance pages

• Use the Automatic Workload Repository (AWR) in RAC

• Use Automatic Database Diagnostic Monitor (ADDM) in RAC

Managing High Availability of Services

• 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

Managing High Availability for Connections and Applications

• Configure client-side connect-time load balancing and failover

• Configure server-side connect-time load balancing

• Use the Load Balancing Advisory (LBA)

• Explain the benefits of Fast Application Notification (FAN)

• Configure server-side callouts

• Configure the server- and client-side ONS

• Configure Transparent Application Failover (TAF)

Upgrading and Patching Oracle RAC

• Describe the different types of patches

• Plan for rolling patches and rolling updates

• Install a patchset with the Oracle Universal Installer (OUI) utility

• Install a patch with the opatch utility

Managing Oracle RAC One Node

• 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

Using Oracle Database Quality of Service Management (QoS)

• Explain the purpose and benefits of using QoS

• Describe the components of QoS

• Explain the operation of QoS

Using Multitenant Architecture in a RAC Environment

• Describe the multitenant architecture in RAC and non-RAC environments

• Create a RAC multitenant container database (CDB)

• Create a pluggable database (PDB) in a RAC CDB

• Use the default CDB and PDB services

• Create PDB services to associate PDB services with server pools

• Drop a PDB from a RAC CDB

Oracle Database 12c: Grid Infrastructure Administration

Introduction to Clusterware

• Explain the principles and purposes of clusters

• Describe Cluster hardware best practices

• Describe how Grid Plug and Play affects Clusterware

Oracle Clusterware Architecture

• Explain the Oracle Clusterware architecture

• Describe Oracle Clusterware startup details

Flex Clusters

• Explain the Flex Cluster architecture and components

• Describe the effect of node failure in a Flex Cluster

Grid Infrastructure Installation Planning and Pre-Tasks

• Plan for Grid Infrastructure installation

• Verify system and network requirements

• Install required OS packages

• Set kernel parameters

• Create groups and users

• Create directories

• Configure shell limits

Grid Infrastructure Installation

• Install Grid Infrastructure

• Verify the installation

• Configure ASM disk groups

Managing Cluster Nodes

• Perform the prerequisite steps to extend a cluster

• Use addNode sh to add a node to a cluster

• Delete a node from a cluster

Traditional Clusterware Management

• Perform day to day Clusterware administration tasks

• Perform Oracle Cluster Registry (OCR) backup and recovery

• Manage network settings

• Explain the scope and capabilities of what-if command evaluation

Policy-Based Cluster Management

• Explain the architecture and components of policy-based cluster management

• Administer server categorization

• Administer a policy set

• Activate a policy

Upgrading and Patching Grid Infrastructure

• Explain 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)

• Install a patch with the opatch utility

Troubleshooting Oracle Clusterware

• Locate the Oracle Clusterware log files and use diagcollection pl

• Enable resource debugging

• Enable component-level debugging

• Enable tracing for Java-based tools

• Troubleshoot the Oracle Cluster Registry (OCR) file

Making Applications Highly Available with Oracle Clusterware

• Explain the hivh availability components of Oracle Clusterware

• Explain policy-managed and administration-managed databases

• Create an application Virtual IP (VIP)

• Manage application resources

Automatic Storage Management (ASM) Administration

Overview of ASM

• Explain the Automatic Storage Management (ASM) architecture

• Describe the components of ASM

Administering ASM Instances

• Explain and apply initialization parameters for ASM instances

• Manage ASM instances and associated processes

• Monitor ASM instances using the V$ASM dynamic performance views

FLEX ASM

• Describe the architecture and components of Flex ASM

• Install and configure Flex ASM

• Manage Flex ASM

Administering ASM Disk Groups

• Create and delete 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

Administering ASM Files, Directories and Templates

• Use client tools to access ASM files

• Describe the format of a fully qualified ASM file name

• Explain how ASM files, directories and aliases are created and managed

• Describe and manage disk group templates

Administering Oracle CloudFS

• Administer ASM Dynamic Volume Manager

• Manage ASM volumes

• Implement ASM Cluster File System (ACFS)

• Use ACFS snapshots

Oracle CloudFS Advance Topics

• Configure ACFS auditing

• Implement ACFS encryption

• Configure and manage ACFC replication

• Implement ACFS tagging

• Describe the ASCF plug-in architecture

• Configure High Availability NFS