Oracle Database 12c: Managing Multitenant Architecture

Course DateLocationDaysPriceRegister
Dec 14, 2017Ottawa2 $1,930Register
Dec 14, 2017Toronto2 $1,930Register


Course DateLocationDaysPriceRegister
Call for Live Virtual Class Dates2 $1,840Register


Course DateLocationDaysPriceRegister
Self-Paced Learning2 $1,700Register


Oracle Database 12c: Managing Multitenant Architecture

Description: During this two day course, gain a conceptual understanding of the multitenant architecture. Learn how to manage an Oracle multitenant container database and any associated pluggable databases in an effective and efficient manner.

Duration: 2 Days

Learn To:

  • Understand the multitenant architecture.
  • Create and manage a multitenant container database and pluggable databases.
  • Manage storage within a multitenant container database and pluggable databases.
  • Manage security within a multitenant container database and pluggable databases.
  • Monitor performance and manage resources within a multitenant container database and pluggable databases.
  • Perform backup, recover and flashback operations on a multitenant container database and pluggable databases.
  • Manage the CDB and PDBs in specific configurations like Data Guard, Database Vault.
  • Perform particular operations like Oracle Data Pump transportation, loading, encryption, auditing.

Audience:

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

Required Prerequisites:

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

Suggested Prerequisites:

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

Course Objectives:

  • Manage the multitenant container database and pluggable databases performance
  • 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

Topics:

Introduction

  • Course Objectives
  • Course Schedule
  • Tools

Container and Pluggable Database Architecture

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

CDB and PDB Creation

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

Managing a CDB and PDBs

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

Managing Storage in a CDB and PDBs

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

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

Managing Availability

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

Managing Performance

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

Miscellaneous

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

 

Course DateLocationDaysPriceRegister
Dec 14, 2017Ottawa2 $1,930Register
Dec 14, 2017Toronto2 $1,930Register


Course DateLocationDaysPriceRegister
Call for Live Virtual Class Dates2 $1,840Register


Course DateLocationDaysPriceRegister
Self-Paced Learning2 $1,700Register