Oracle 12cR1 and 12cR2 Container and Pluggable Database Administration

5 Day Course
Hands On
Code O12CCPA

Book Now - 2 Delivery Methods Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online


This Oracle 12cR1 and 12cR2 Container and Pluggable Database Administration course is designed to give experienced Oracle 11gR2 Database Administrators practical experience in using the new container and pluggable database features that have been introduced in Oracle Database 12cR1 and 12cR2. Delegates will gain an appreciation of how the Multitenant Architecture new features of Oracle Database 12c may be implemented at their own sites.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Note: The focus of this course is on the usage of container and pluggable databases. The Oracle Database 12cR1 and 12cR2 New Features for 11gR2 Administrators course covers the general new features that have been introduced in Oracle Database 12cR1 and 12cR2.


The delegate will learn and acquire skills as follows:

  • Install the Oracle Database 12cR2 software with the OUI
  • Create a container and pluggable database with the DBCA
  • Use different methods to create Pluggable databases /li>
  • Configure a CDB and PDBs
  • Create a PDB with Local UNDO
  • Hot Clone a PDB
  • Manage a container and pluggable databases
  • Use new tablespace and management features
  • Manage common and local users, roles and privileges
  • Create and manage Application Containers
  • Plug and unplug a database with a PDB archive file
  • Relocate a PDB to a new container
  • Backup a Container and Pluggable Database
  • Restore, recover and flashback at PDB level
  • Create and manage Application Containers
  • Create and manage and implement security in Application root and Application Container PDBs
  • Manage performance at a PDB level
  • Upgrade an Oracle 11.2. or 12.1 database to 12.2 Multitenant Architecture
  • Migrate Data with Data Pump
  • Upgrade multitenant and pluggable databases
  • Implement Unified Auditing New Features
  • Manage resources with Resource Manager performance profiles and memory directives
  • Use the Trace File Analyzer to collect and diagnose issues

Target Audience

This Oracle 12cR1 and 12cR2 Container and Pluggable Database Administration course is designed for Oracle professionals who need to gain an understanding of and implement the new Multitenant Architecture features and functionality introduced in Oracle Database 12cR1 and 12cR2.

Additional Information

  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.


Hide all

Changes to Database Management Tools (3 topics)

  • Enterprise Manager Express Home Page
  • SQL Developer new DBA management functionality
  • Changes to the OUI and the DBCA

Oracle Database 12cR2 Architecture (14 topics)

  • Overview of the Oracle Database 12cR2 architecture
  • An overview of a Container Database (CDB)
  • The benefits of Multitenant Architecture
  • The Root Container and Pluggable Database containers
  • The structure of the Root Container
  • The structure of a Pluggable Database (PDB)
  • CDB_xxx and DBA_xxx Views
  • Plan an installation
  • System requirements and operating system prerequisites
  • Install the Oracle Database 12cR2 software with the OUI
  • The Oracle Inventory
  • Silent mode installation
  • Database software de-install
  • Workshop Exercises

Create a Database with the Database Configuration Assistant (DBCA) (9 topics)

  • Create a Container and Pluggable databases with the OUI
  • Select a database storage method
  • Select a CDB or non-CDB database
  • Select a database type based on workload
  • Select a character set for the database
  • Set the NLS_LANG initialization parameter
  • Create a database with the DBCA
  • Manual Creation of a CDB
  • Workshop Exercises

Manage a Container Database and Pluggable Database (13 topics)

  • Introduction
  • Connect to a CDB as an administrator
  • Connect to a CDB using a service name
  • Connect to a Pluggable database
  • Display the current container
  • Switch between containers
  • Startup and shutdown a CDB
  • Open and close a PDB
  • Open and close all PDBs
  • Automatic startup of pluggable databases
  • Preserve or discard the PDB open mode after a CDB restart
  • Change the state of a PDB
  • Workshop Exercises

New Tablespace and Management Features (9 topics)

  • Introduction
  • Data storage overview
  • Create and manage tablespaces in the CDB and PDBs
  • Online rename and Relocation of an active datafile
  • Restrict PGA Size
  • Configure Instance Parameters in a CDB and a PDB
  • Enable and disable temporary undo
  • Query temporary undo information
  • Workshop Exercises

Manage Common and Local Users, Roles and Privileges (9 topics)

  • Introduction
  • Overview of common and local user management
  • Create and manage common users
  • Create and manage local users
  • Create common roles
  • Create local roles
  • Grant roles and privileges to common and local users
  • Use the PDB CONTAINERS clause with common and local users
  • Workshop Exercises

Configure a Container Database and Create and Clone Pluggable Databases (21 topics)

  • Configure a Container Database
  • Examine the structure of a CDB using CDB_XXX views
  • Administer the database using SQL Developer and EM Express
  • Create a new PDB from PDB$SEED
  • The PDB LOGGING and NOLOGGING clauses
  • Create a Metadata only PDB
  • Clone a PDB subset
  • Create a PDB from a non-CDB
  • Clone a PDB into the same CDB
  • Clone a PDB into the same CDB using database links
  • Clone a remote PDB or non-CDB
  • Plug and unplug a PDB
  • Parallel PDB creation
  • Create a PDB with a default tablespace
  • Use local UNDO mode with a PDB
  • Hot clone a PDB
  • Refresh a read only PDB
  • Plug and unplug a PDB using a PDB archive file
  • Relocate a PDB to a new container
  • Remote proxy PDBs
  • Workshop Exercises

Availability Enhancements (30 topics)

  • The SYSBACKUP privilege
  • Execute SQL statements in RMAN
  • Use the RMAN DESCRIBE Command
  • RMAN syntax enhancements
  • Container and Pluggable Database Backups
  • Backup a Container Database
  • Root Container Backup
  • Backup a Pluggable Database
  • Tablespace and Datafile Backups
  • Container and Pluggable Database Recovery
  • Container Database Complete Recovery
  • Root Container Complete Recovery
  • Pluggable Database Complete Recovery
  • Tablespace and Datafile Complete Recovery
  • Point in Time Recovery
  • Container Database Point in Time Recovery
  • Pluggable Database Point in Time Recovery
  • Table Point in Time Recovery
  • Recover a CDB from the Loss of Redo Logs, Control Files and Undo
  • Use Flashback at CDB Level
  • Restrictions on Point in Time Recovery of Pluggable Database
  • RMAN syntax enhancements
  • Recover a database after missing redo logs found
  • Enhanced table point in time recovery
  • The enhanced REPAIR FAILURE command
  • Enhanced table point in time recovery
  • Create multi-section backups
  • Backup and restore very large files
  • Recover a database after missing redo logs found
  • Workshop Exercises

Recovery and Flashback at PDB Level (5 topics)

  • Shutdown a PDB with critical datafiles missing
  • Flashback a pluggable database at PDB level
  • Create a restore point at CDB and PDB level
  • Create a clean restore point
  • Flashback a PDB in local and shared undo mode

Applications and Application Containers (12 topics)

  • Application Root and Application Container PDBs
  • Create an Application Container
  • Open an Application Container
  • Create network services
  • Drop an Application Container
  • Manage Applications
  • Install and uninstall an Application
  • Upgrade an Application
  • Drop an Application Container
  • Manage an Application seed
  • Application common objects
  • Application Container views

PDB Security (7 topics)

  • Create common and local users in an application
  • Grant common and local privileges in an application
  • Create and grant common and local roles in application containers
  • Use common and local objects and profiles in an application
  • Application common objects
  • Implement Lockdown Policies
  • Assign a lockdown profile to a PDB

PDB Performance Management (9 topics)

  • Automatic Workload Repository Data at CDB and PDB Level
  • Enable PDB snapshots
  • Disable AWR for a PDB with a Lockdown profile
  • Set SGA and PGA for a PDB
  • Share Resource between PDBs
  • PDB Profile Directives
  • Share Based Instance Caging
  • Limit I/O rates for PDBs
  • Use PDB Resource Plans

Resource Manager Enhancements (9 topics)

  • Memory Resource management for PDBs
  • Manage session PGA limit
  • Control memory usage for PDBs
  • PDB memory parameters
  • Set PDB memory parameters
  • Monitor memory usage for PDBs
  • The SESSION_PGA_LIMIT parameter
  • Limit session PGA with a resource plan
  • Manage session PGA limit

SQL Tuning Enhancements (9 topics)

  • New default values for OPTIMIZER_ADAPTIVE parameters
  • Adaptive Query optimization enhancements in 12.2
  • The Optimizer Statistics Advisor rules, findings, recommendations and actions
  • The Expression Statistics Store
  • Continuous Adaptive Query plans
  • Enhancements to the SQL Performance Analyzer
  • Enhancements to SQL Plan Management
  • Execution plan capture from AWR
  • Automatic Capture files

Diagnosability (7 topics)

  • Set an ADR retention target
  • The Retention Advisor
  • The TFA Collector
  • Install the TFA Collector
  • Manage the TFA daemon
  • Start and stop the TFA Collector
  • Dynamic Data Pump tracing

Preparation for Upgrade to Oracle Database 12cR2 (12 topics)

  • Methods used to perform upgrade
  • Methods of data migration
  • Direct upgrade supported releases
  • The Database Upgrade Assistant (dbua)
  • Upgrade process overview
  • Rolling upgrade
  • Create an upgrade test plan
  • Carry out performance testing
  • Run the Pre-Upgrade Information tool
  • Backup the database
  • Install the Oracle Database 12cR2 software
  • Create the new Oracle home

Upgrade to Oracle Database 12cR2 (7 topics)

  • Prepare to upgrade a database from or to 12.2
  • Execute preupgrade.jar
  • Upgrade a database with the Database Upgrade Assistant (DBUA)
  • Upgrade a database manually
  • Post upgrade tasks
  • Plugin an upgraded database as a PDB into a CDB
  • Deprecated database features and parameters

Post Upgrade Tasks (6 topics)

  • Common installation errors
  • Check the /etc/oratab file
  • Check the database version
  • Enterprise Manager Express configuration
  • Carry out post upgrade tasks after a manual upgrade
  • Migrate to unified auditing

Migrate Data with Data Pump (3 topics)

  • Migrate data with Data Pump
  • Transport a database
  • Import data using a Data Pump network link


Delegates who wish to attend this Oracle 12cR1 and 12cR2 Container and Pluggable Database Administration course should have administration experience of Oracle Database 11.2. Knowledge of using PL/SQL packages is strongly recommended.

This course is run on a Linux operating system, therefore a good working knowledge of UNIX/Linux is required. This knowledge can be gained by attendance on the pre-requisite Linux Introduction course.

Additional Learning

The courses below may help you meet the knowledge level required to take this course.

Scheduled Dates

Please select from the dates below to make an enquiry or booking.


Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.

Code Location Duration Price Aug Sep Oct Nov Dec Jan
Later scheduled dates may be available for this course.

Course PDF


Share this Course


Recommend this Course