Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Oracle Database 12c RAC Administration

This course covers the architecture, installation, maintenance and tuning of Oracle Database 12c RAC.

GK# 7624

Course Overview

TOP

Oracle Real Application Clusters (Oracle RAC) is a clustered version of the Oracle Database providing high availability, scalability and flexibility. This learning path covers the architecture, installation, maintenance and tuning of Oracle Database 12c RAC, essential skills for DBAs supporting highly available Oracle systems and covers a portion of the objectives for exam 1Z0-068 Oracle Database 12c: RAC and Grid Infrastructure.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Oracle Database 12c RAC Administration: Introduction to Oracle RAC
  • Oracle Database 12c RAC Administration: Installing, Configuring, and Patching
  • Oracle Database 12c RAC Administration: Day-to-Day Administration
  • Oracle Database 12c RAC Administration: Backup and Recovery
  • Oracle Database 12c RAC Administration: Global Resource Management
  • Oracle Database 12c RAC Administration: Monitoring and Tuning
  • Oracle Database 12c RAC Administration: Client Connections and QoS
  • Oracle Database 12c RAC Administration: Services and Multitenant Architecture

Outline

TOP
Viewing outline for:

On-Demand Outline

Oracle Database 12c RAC Administration: Introduction to Oracle RAC

  • Define Clusters and Clusterware
  • Describe Oracle Clusterware as a component of Oracle Grid Infrastructure
  • Describe the Oracle Clusterware architecture and the services it includes
  • Describe the Grid Plug and Play (GPnP) architecture it's benefits in rapid provisioning
  • Describe the startup process in a Grid Plug and Play (GPnP) environment
  • Define the role Grid Naming Service (GNS) plays in dynamic provisioning
  • Describe how clients connect to the database using the single-client access name (SCAN)
  • Describe Oracle ASM as a volume manager and the benefits it brings to RAC
  • Describe the ASM CloudFS and ACFS architecture and the benefits it leverages from Oracle ASM functionality
  • List the features and benefits of Oracle ASM and describe the concepts of Oracle Flex ASM
  • Install and configure a new cluster including ASM configuration
  • Install and configure a new cluster including ASM configuration
  • Define the concept of Oracle RAC and list the differences between Oracle RAC databases and noncluster Oracle databases
  • Describe the typical Oracle RAC architecture and some of the variations available
  • Describe the role Oracle RAC One Node plays in server consolidation including its high availability benefits
  • Describe the requirement for cluster-aware storage when using Oracle RAC and list the supported cluster-aware storage solutions
  • Describe the network requirements of Oracle RAC
  • List the benefits of using Oracle RAC
  • Describe the scalability potential of Oracle RAC and differentiate between scale-up or speed-up
  • List some of the I/O and memory requirements of Oracle RAC
  • Describe the necessity of inter-node synchronization
  • Describe the impact of parallel execution in Oracle RAC
  • Install and configure a new cluster including ASM

Oracle Database 12c RAC Administration: Installing, Configuring, and Patching

  • 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
  • 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
  • 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
  • Use DBCA to convert a single-instance database to a RAC database

Oracle Database 12c RAC Administration: Day-to-Day Administration

  • 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
  • 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
  • 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
  • Change the processes parameter for one RAC instance and confirm the change with Enterprise Manager

Oracle Database 12c RAC Administration: Backup and Recovery

  • Describe the process of instance recovery by a surviving RAC instance after one or more instances fail
  • Describe the degree of database availability during each step of instance recovery
  • Describe ways to make instance recovery faster in a RAC environment
  • Describe ways to protect against media failure
  • Describe the process of media recovery in Oracle RAC
  • List the stages of recovery where parallelism can be used
  • Use a fast recovery area in RAC
  • Configure RAC recovery settings with Enterprise Manager
  • Configure RAC backup settings with Enterprise Manager
  • List the benefits Oracle Recovery Manager (RMAN) provides for RAC
  • Configure spfile and controlfile backups in Oracle RAC
  • Describe why all cluster nodes should be able to access all backups
  • Configure multiple channels to connect to different instances in the cluster
  • Describe backup configurations for RAC and how RMAN automatically locates files needed for recovery on the cluster
  • Configure archived redo log parameters for RAC
  • Configure the way RMAN backs up and restores archived redo logs on a shared file system
  • Configure archiving to non-cluster local file systems
  • Configure archiving to a cluster file system
  • List considerations when restoring and recovering archived log file
  • Configure RMAN to automatically back up the controlfile and make an RMAN backup with multiple channels to different instances

Oracle Database 12c RAC Administration: Global Resource Management

  • Describe the need for concurrency control in a RAC database and the role of the Global Resource Directory (GRD) in global concurrency control
  • Describe how global resources are managed and list the background processes involved in global concurrency control
  • Describe the process of allocating control of the master metadata for a specific entity to another instance
  • Describe the roles of global enqueues and global instance locks
  • Describe how global enqueues are used to control access to resources
  • List the objects that are subject to instance-wide locks
  • Describe how concurrency is managed across multiple buffer caches
  • Describe the important buffer states for cache fusion
  • List the scenarios where Global Cache Management controls concurrency for single-block reads
  • Describe the steps involved when an instance wants to read a block that is not in the buffer cache
  • Describe the steps involved when an instance wants to update a block that exists in at least one buffer cache in shared current state
  • Describe the steps involved when an instance wants to update a block that exists in at least one buffer cache in exclusive current state
  • Describe the steps involved when an instance wants to read a block which exists in at least one buffer cache in exclusive current state
  • Describe multi-block read requests and identify some useful Global Cache Management views
  • Use the GV$BH to explore the buffer states of a block being updated and read by multiple instances

Oracle Database 12c RAC Administration: Monitoring and Tuning

  • Describe the approach when tuning a RAC database
  • Describe the impact of accessing blocks in the global cache and maintaining cache coherency
  • Describe the importance of using wait events to diagnose performance problems and list some of the important wait event views
  • Describe the main global cache wait events for current and consistent read blocks
  • Describe the most frequent enqueue waits and how global enqueue wait events can impact an Oracle RAC database
  • List some of the most common tuning techniques that are particularly important for RAC
  • Describe reasons for index block contention and list ways to mitigate the problem
  • Describe the impact of frequently allocating space to a segment in RAC
  • Describe tuning considerations relating to undo blocks, and serialized cross-instance calls
  • Use Enterprise Manager to get an overview of the performance statistics for the database
  • Use the Enterprise Manager Cluster Database Performance Page to view problems inside and outside the database
  • Use the Enterprise Manager Cluster Database Performance Page to view database throughput and drill down to view throughput for specific instances
  • Use the Oracle Enterprise Manager cloud control cluster cache coherency page to view statistics relating to global cache throughput
  • Use additional monitoring links in Enterprise Manager to view database locks and to access the top activity page for the database
  • Use EM Database Express Performance Hub to view both historical and real-time performance data
  • Describe how AWR manages snapshots in RAC
  • Identify RAC-specific sections in an AWR report
  • Diagnose performance problems with the RAC-specific sections of the Active Session History Report
  • Use the Automatic Database Diagnostic Monitor to analyze performance for the entire cluster or for individual instances
  • List what ADDM diagnoses for RAC and use ADDM-specific pages in Enterprise Manager to diagnose RAC database performance
  • Use Enterprise Manager to view database performance and find RAC-specific information in an AWR report

Oracle Database 12c RAC Administration: Client Connections and QoS

  • Describe the types of workload distribution methods
  • Describe the Fast Application Notification (FAN) mechanism and list its benefits
  • Identify the Oracle clients that are integrated with FAN
  • List the types and statuses of FAN events
  • Implement a basic server-side callout script to parse and filter event arguments
  • Describe the server-side Oracle Notification Services (ONS) configuration and how to add additional mid-tier ONS daemons into the configuration
  • Describe the automatic connection management of Fast Connection Failover
  • Describe how the Load Balancing Advisory balances work across RAC instances
  • Describe how to configure server-side load balancing to direct client connections appropriately
  • Describe the two failover methods Transparent Application Failover (TAF) supports
  • Configure basic Transparent Application Failover on the server and client-side
  • Configure preconnect Transparent Application Failover on the client-side
  • Describe the Transaction Guard API
  • Describe how Transaction Guard works
  • Describe Application Continuity works and its benefits
  • Describe how to configure Application Continuity in a RAC service
  • Describe the concept of QoS Management in the context of Oracle RAC
  • List the benefits of QoS Management
  • Describe how QoS Management attempts to meet Performance Objectives and list the components that make up QoS Management
  • Define a Policy Set
  • Define the purpose of server pools and how server pools are used by QoS Management
  • Define Performance Classes and describe how work requests are tagged to identify the Performance Classes they belong to
  • Describe Performance Policies and their relationship with Performance Objectives
  • Define how performance objectives specify the level of optimal performance for business purposes
  • Describe server pool directive overrides and Performance Class ranks as components of Performance Policies
  • Describe the metrics used by QoS Management to identify performance issues
  • Describe how QoS Management generates recommendations and how to implement a recommended action
  • Configure and test client-side connect-time load balancing and TAF

Oracle Database 12c RAC Administration: Services and Multitenant Architecture

  • Define Oracle services and describe how services are used in a RAC database
  • Describe the characteristics that can be specified when creating a service
  • List the default services in a database and describe how Restricted Service Registration improves RAC security
  • Create a service using Enterprise Manager and perform common service management tasks
  • Create a service using SRVCTL and perform common service management tasks
  • Use a service in a client connect string and configure a service for load balancing
  • Configure services for use with Transparent Application Failover
  • Configure Resource Manager to prioritize sessions according to the services that clients use to connect
  • Configure scheduled jobs to classes to assign a job to a service, to bring the benefits of services in RAC to the Scheduler
  • Configure singleton services for distributed transactions to maximize application throughput
  • Specify performance thresholds and generate alerts for services
  • Describe how statistics can be aggregated and how workloads can be traced when sessions are shared
  • View performance-related information for services with Enterprise Manager
  • Use the DBMS_MONITOR package to enable or disable aggregation and tracing at finer levels of granularity
  • Describe the service-related performance views
  • Distinguish between a non-container database and a multitenant container database (CBD), and list the benefits of multitenant CBDs
  • Describe the architecture of a container database (CDB) in a non-RAC environment
  • Define the terminology used when talking about container databases and list the data dictionary views relating to CDB
  • Connect to a non-RAC CDB and switch between containers
  • List the configuration options for a database in 12c and describe the architecture of a multitenant RAC database
  • Create a RAC CDB including a pluggable database
  • Connect using CDB/PDB services and open and close a PDB
  • Identify the types of services in a CDB and assign a PDB service to a server pool
  • Create a new PDB from the seed or clone it from another PDB and drop a PDB
  • Connect to the database using a new service and schedule a job that runs under a specific service

 

Who Should Attend

TOP

This course is designed for Oracle Database Administrators, Systems Administrators, and Technical Consultants.

Course Delivery

This course is available in the following formats:

On-Demand

Train at your own pace with 24/7 access to courses that help you acquire must-have technology skills.



Request this course in a different delivery format.
Enroll