Gain a comprehensive introduction to managing container and pluggable databases introduced in Oracle 12c and enhanced in subsequent versions. This training equips you with the skills needed to confidently administer multitenant environments.
Oracle Multitenant Administration
Master Oracle’s multitenant architecture
Gain practical experience creating, configuring and managing CDBs and PDBs. This course offers a deep dive into the architecture and functionality of container and pluggable databases, helping Oracle Database Administrators move beyond traditional setups to adopt the multitenant model.
Learning objectives
- Create and manage container databases (CDBs) and pluggable databases (PDBs)
- Migrate non-container databases (non-CDBs) to multitenant architecture
- Backup and recover at PDB level using RMAN
- Manage security in container and pluggable databases
- Tune performance across container databases using Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM)
- Apply lockdown policies to restrict functionality in PDBs
- Use Oracle Data Pump for flexible data migrations
- Prepare and carry out upgrades to Oracle Database 19c using the Database Upgrade Assistant (DBUA)
What you’ll learn
Understand how to manage Oracle’s multitenant architecture, working with both container and pluggable databases. You’ll gain experience performing key administrative tasks including backup, recovery, performance tuning, and security management in multitenant environments.
User and role administration
Learn how to keep things secure and well organised across your databases. You’ll work with common and local users, manage access using roles, and understand how to apply privileges across CDBs and PDBs. You’ll also explore Oracle Database Vault and auditing options to help you lock things down and stay compliant.
Performance monitoring and tuning
This course shows you how to monitor and optimise performance within Oracle’s multitenant architecture. Discover how to manage memory usage across PDBs, apply resource limits, and configure performance profiles. Using tools like Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM), you’ll learn how to analyse system behaviour and make informed adjustments to improve overall efficiency.
Security management and lockdown profiles
Our trainers will explain how to secure Oracle multitenant environments by managing user access and applying lockdown profiles. The course covers the difference between common and local users, the use of roles and privileges, and how to isolate PDBs effectively. You’ll also explore how to restrict features within pluggable databases and apply security best practices using tools like Oracle Database Vault and Unified Auditing.
Application containers and common objects
You’ll explore how to work with application containers within Oracle’s multitenant architecture, including how to create application roots and seed containers. The course explains how to install, upgrade and uninstall applications, and how to manage common objects, users, roles, and privileges across application PDBs. Also, learn how to maintain consistency and control within application-level environments.
What’s included
- 4 days of instructor-led training in a live virtual classroom
- Interactive hands-on live labs
- All relevant course materials
- Course completion certificate
Key facts
Ideal for
Experienced Oracle Database Administrators who need practical skills to manage multitenant environments across Oracle 12c, 18c and 19c.
Prerequisites
You’ll need an understanding of Oracle database administration and should have first completed our Linux Introduction or Oracle Database 19c Administration course.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
Develop the skills to manage Oracle’s multitenant architecture effectively, from initial setup through to upgrades. The course provides practical experience with container and pluggable databases, including areas such as security, performance optimisation, and data migration.
Do I need to have used multitenant databases before?
Not at all. If you’re familiar with Oracle database administration, we’ll guide you through the multitenant features step by step. Through practical exercises in our live labs, you’ll quickly build your confidence with CDBs and PDBs.
What’s the difference between a CDB and a PDB?
A container database (CDB) serves as the main structure that hosts one or more pluggable databases (PDBs). Each PDB is self-contained and can be managed independently, while operating within the CDB framework. This architecture streamlines administration and simplifies the process of upgrades and performance tuning.
Will I learn how to move data between databases?
Yes, you’ll get experience using Oracle Data Pump and other tools to move data between PDBs and across different CDBs. We also cover best practices to avoid downtime and make migrations smoother.
What are the benefits of using Oracle’s multitenant architecture?
Oracle’s multitenant architecture simplifies database management by allowing multiple pluggable databases (PDBs) to be hosted within a single container database (CDB). This structure reduces overheads, improves resource utilisation, and enables faster provisioning and patching. It also supports streamlined backup, recovery, and upgrades, helping administrators manage multiple databases more efficiently while maintaining isolation and control.
What our customers say
“I really enjoyed this course, it was clear the instructor had in-depth knowledge about the subject and was keen on answering questions and explaining problems thoroughly. I also appreciated learning about the principles, best practice standards, and the reasoning behind these.”
Michaela, Government
“Always good courses from StayAhead. The tutor explained the course very well.”
Paul, Development Analyst, Application Support - Transport
Why study with StayAhead
96% customer satisfaction
We combine experience and passion to deliver training that meets the highest standards
30+ years’ experience
Industry-leading specialists delivering high-impact IT training
Experiential instructor-led training
Courses are delivered by experienced instructors using hands-on, practical live labs