Oracle Database 12c: Managing Multitenant Architecture

Course code:ORAP03


Duration: 6 Days / 48 Hours

This Oracle Database 12c: Managing Multitenant Architecture training helps you gain a conceptual understanding of the multitenant architecture. You'll practice plugging and unplugging databases in multi-tenant container databases, while learning how to create common and local users and administer database security to meet your business requirements.In this course, you will be introduced to Oracle Database Cloud Service. During the course, you'll explore all aspects of the multi-tenant architecture, providing detailed information on the components of an Oracle multi-tenant container database and any associated pluggable databases. You'll learn why and how to create and manage a multi-tenant container database and any associated pluggable databases with storage structures appropriate for the business applications. This course will also prepare the students for the certification Oracle Database 12c Administrator Certified Professional.

Audience

  • Database Administrators
  • Database Designers
  • Support Engineer
  • Technical Administrator
  • Data Warehouse Administrator

Prerequisites

Required Prerequisites:

  • Working knowledge of SQL and use of PL/SQL packages
  • Working knowledge of tools like SQL*Plus or Enterprise Manager Cloud Control
  • Knowledge of non-CDB configuration and management
  • Oracle Database 12c : Administration Workshop
  • Oracle Database 12c : Backup and Recovery Workshop

Suggested Prerequisites:

  • Basic knowledge of Linux operating system
  • Oracle Database 12c: Install and Upgrade Workshop
 

Objective

After completing this course, students will be able to:
  • Configure resource manager to share resources within a multitenant container database between containers and within a pluggable database
  • Implement unified auditing in a multitenant container database and its pluggable databases
  • Use Oracle Data Pump, SQL*Loader in pluggable databases
  • Monitor the multitenant container database and pluggable databases
  • Describe the multitenant architecture
  • Create a multitenant container database
  • Create a pluggable database using different methods
  • Plug a non-CDB into a multitenant container database
  • Manage multitenant container databases and pluggable databases
  • Administer multitenant container database and pluggable database storage structures
  • Create and administer common and local user accounts
  • Manage common and local privileges and roles
  • Configure multitenant container databases and pluggable databases backup and recovery operations
  • Manage the multitenant container database and pluggable databases performance
  • Gain an understanding of the Oracle Database Cloud Service

Education Criteria

None

Module 1: Introduction

  • Course Objectives
  • Course Schedule
  • Tools

Module 2: Container and Pluggable Database Architecture

  • Challenges and Benefits
  • Multitenant Architecture
  • Provisioning PDBs
  • Terminology

Module 3: CDB and PDB Creation

  • Using Tools
  • Configuring and Creating a CDB
  • Creating PDBs
  • Dropping PDBs
  • Migrating PDBs

Module 4: Managing a CDB and PDBs

  • Connection
  • Managing a CDB and PDBs
  • Managing PDBs Open Mode and Settings
  • Configuring CDB and PDBs Initialization Parameters

Module 5: Managing Storage in a CDB and PDBs

  • Managing Permanent Tablespaces in CDB and PDBs
  • Managing Temporary Tablespaces in CDB and PDBs

Module 6: Managing Security in a CDB and PDBs

  • Managing Common and Local Users
  • Managing Common and Local Privileges
  • Managing Common and Local Roles
  • Understanding Shared and Non-Shared Objects
  • Managing Common and Local Profiles

Module 7: Managing Availability

  • Managing Backups
  • Managing Recovery Operations
  • Managing Flashback Database
  • Duplicating PDBs
  • Special Situations and Views

Module 8: Managing Performance

  • Managing Performance
  • Managing Resource Allocation
  • Maximizing Consolidated Database Replay

Module 9: Miscellaneous

  • Exporting and Importing Data
  • Loading Data
  • Auditing Operations
  • Scheduling Jobs
  • Using Other Products

Module 10: Oracle Database Cloud Service: Overview

  • Database as a Service Architecture, Features and Tooling
  • Software Editions: Included Database Options and Management Packs
  • Accessing the Oracle Database Cloud Service Console & Automated Database Provisioning
  • Managing the Compute Node Associated with a Database Deployment
  • Managing Network Access to Database as a Service & Scaling a Database Deployment
  • Patching Database as a Service & Using the Oracle Database Cloud Service Console to Manage Patches
  • Migrating from On-premises to Oracle Cloud Database
  • Gather Information for Migration

Course Review

Exam Preparation