Oracle Database Multitenant Administration (12c to 19c)

Master Oracle Multitenant architecture and manage CDBs and PDBs across 12c, 18c, and 19c

Learn how to build, manage, and administer Oracle Multitenant Architecture across Oracle Database releases 12.1, 12.2, 18c, and 19c, with a strong focus on real-world DBA tasks.

This course explains Oracle Multitenant concepts clearly and then guides you through hands-on implementation step by step. You will not only understand how multitenant works, but also gain practical experience managing Container Databases (CDBs) and Pluggable Databases (PDBs) in production-like environments.

You will learn how to:

• Understand and describe Oracle Multitenant architecture

• Create and manage container databases and pluggable databases

• Create PDBs using multiple methods, including:

  • Creating a PDB from the seed

  • Cloning local and remote PDBs, including refreshable PDBs

  • Plugging and unplugging PDBs

  • Relocating PDBs

  • Creating PDBs from non-CDB databases

  • Creating Proxy PDBs

• Manage security in multitenant environments, including:

  • Common and local users and roles

  • PDB lockdown profiles

• Perform backup and recovery, PITR, and Flashback Database in multitenant environments

• Use Resource Manager and Data Pump with PDBs

• Manage applications, application containers, application PDBs, and common objects

• Work with new multitenant features in Oracle 18c and 19c, including:

  • CDB fleet management

  • PDB Snapshot Carousel

  • Switchover of refreshable clone PDBs

  • PDB cloning and relocation using DBCA

The course consists of 72 lectures and more than 13 hours of video, combining concept explanations with fully demonstrated hands-on exercises. Every practical task is supported by video demonstrations and downloadable guide documents.

This course prepares Oracle Database Administrators for the next generation of Oracle databases, including cloud-based multitenant environments.

By the end of the course, you will be able to build, manage, and maintain Oracle Multitenant environments with confidence.

Join this learning journey and master one of Oracle’s most important database architectures.