• Home
  • Oracle
  • Oracle Database 23ai: Multitenant Architecture Training

Oracle Database 23ai: Multitenant Architecture Training

Download Course Brochure Interview Questions

Instructor-Led Training Parameters

Course Highlights

  • Instructor-led Online Training
  • Project Based Learning
  • Certified & Experienced Trainers
  • Course Completion Certificate
  • Lifetime e-Learning Access
  • 24x7 After Training Support

Oracle Database 23ai: Multitenant Architecture Training Course Overview

The Oracle Database 23ai: Multitenant Architecture Training by Multisoft Systems is designed to provide an in-depth understanding of Oracle’s advanced multitenant features. This course focuses on helping database professionals master the management of container databases (CDBs) and pluggable databases (PDBs), which are essential for database consolidation, scalability, and simplified administration in modern enterprise environments. Participants will learn how to create, clone, relocate, and unplug PDBs, manage security across multiple tenants, and optimize performance using resource management techniques. The course also covers advanced topics such as backup and recovery in a multitenant environment, patching procedures, and best practices for high availability and disaster recovery strategies. Delivered by Oracle-certified experts, this hands-on training ensures participants gain practical experience in setting up and maintaining multitenant configurations, both in on-premises and cloud-based deployments. Whether you're preparing for Oracle certification exams or aiming to enhance your career as a Database Administrator (DBA) or Cloud Architect, this course equips you with the latest Oracle 23ai multitenant capabilities essential for today’s IT landscape.

Multisoft Systems offers flexible learning modes, including instructor-led online classes, self-paced learning, and corporate training options, making it easier for working professionals to upgrade their skills effectively.

Instructor-led Training Live Online Classes

Suitable batches for you

May, 2025 Weekdays Mon-Fri Enquire Now
Weekend Sat-Sun Enquire Now
Jun, 2025 Weekdays Mon-Fri Enquire Now
Weekend Sat-Sun Enquire Now

Share details to upskills your team


Build Your Own Customize Schedule


Oracle Database 23ai: Multitenant Architecture Training Course curriculum

Curriculum Designed by Experts

Download Curriculum DOWNLOAD CURRICULUM

The Oracle Database 23ai: Multitenant Architecture Training by Multisoft Systems is designed to provide an in-depth understanding of Oracle’s advanced multitenant features. This course focuses on helping database professionals master the management of container databases (CDBs) and pluggable databases (PDBs), which are essential for database consolidation, scalability, and simplified administration in modern enterprise environments. Participants will learn how to create, clone, relocate, and unplug PDBs, manage security across multiple tenants, and optimize performance using resource management techniques. The course also covers advanced topics such as backup and recovery in a multitenant environment, patching procedures, and best practices for high availability and disaster recovery strategies. Delivered by Oracle-certified experts, this hands-on training ensures participants gain practical experience in setting up and maintaining multitenant configurations, both in on-premises and cloud-based deployments. Whether you're preparing for Oracle certification exams or aiming to enhance your career as a Database Administrator (DBA) or Cloud Architect, this course equips you with the latest Oracle 23ai multitenant capabilities essential for today’s IT landscape.

Multisoft Systems offers flexible learning modes, including instructor-led online classes, self-paced learning, and corporate training options, making it easier for working professionals to upgrade their skills effectively.

  • Understand the core concepts of Oracle Multitenant Architecture, including CDBs and PDBs.
  • Learn how to create, manage, clone, unplug, and relocate pluggable databases (PDBs).
  • Configure and administer container databases (CDBs) efficiently in different environments.
  • Implement resource management for optimizing workload across multiple PDBs.
  • Perform backup, recovery, and patching in a multitenant environment.
  • Secure and manage user access across containers and pluggable databases.
  • Explore methods for upgrading and migrating multitenant databases to Oracle Database 23ai.

Course Prerequisite

  • Basic understanding of Oracle Database architecture
  • Experience with SQL and PL/SQL programming
  • Familiarity with Oracle Database Administration tasks

Course Target Audience

  • Database Administrators (DBAs)
  • Cloud Architects
  • System Administrators
  • Database Developers
  • IT Infrastructure Engineers
  • Oracle Certified Professionals
  • Data Architects
  • Solutions Architects
  • IT Managers

Course Content

  • Objectives
  • Challenges 
  • Multitenant Architecture: Benefits 
  • Other Benefits of Multitenant Architecture 
  • Oracle Multitenant Container Database 
  • Configurations 
  • SYSTEM Objects in the USER Container 
  • Provisioning a Pluggable Database 
  • Multitenant Container Database Architecture 
  • Containers 
  • Tools 
  • Data Dictionary and Dynamic Views 
  • Terminology 
  • Impacts
  • Summary 
  • Multitenant Architecture Poster 

Download Curriculum DOWNLOAD CURRICULUM

  • Objectives 
  • Goals 
  • Creating a CDB 
  • Creating a CDB: Using SQL*Plus 
  • Clause: SEED FILE_NAME_CONVERT 
  • Clause: ENABLE PLUGGABLE DATABASE 
  • After CDB Creation 
  • Data Dictionary Views: DBA_xxx 
  • Data Dictionary Views: CDB_xxx 
  • Data Dictionary Views: Examples 
  • Data Dictionary Views: V$xxx Views 
  • After CDB Creation: To Do List 
  • Automatic Diagnostic Repository 
  • Automatic Diagnostic Repository: alert.log File 
  • Provisioning New Pluggable Databases 
  • Tools 
  • Creating New PDB from PDB$SEED 
  • Steps: With FILE_NAME_CONVERT 
  • Steps: Without FILE_NAME_CONVERT 
  • Summary 

Download Curriculum DOWNLOAD CURRICULUM

  • Objectives 
  • Regular PDBs 
  • PDBs and Applications 
  • Application Containers 
  • Application Containers: Other Features 
  • Types of Containers 
  • Creating Application PDBs 
  • Application Name and Version 
  • Installing Applications 
  • Patching and Upgrading Applications 
  • Application Common Objects 
  • Use Cases for Application Containers 
  • Use Case: Pure PDB-Based Vs Hybrid Model 
  • Container Map 
  • Container Map: Example 
  • Query Routed Appropriately 
  • Dynamic Container Map 
  • Container Map and Containers Default 
  • Query Across CDBs Using Application Root Replica 
  • Durable Location Transparency 
  • Data Dictionary Views 
  • Terminology in Application Container Context 
  • Commonality in Application Containers 
  • Impacts 
  • Summary 

Download Curriculum DOWNLOAD CURRICULUM

  • Objectives 
  • Cloning Regular PDBs 
  • Cloning Application Containers 
  • Plugging a Non-CDB into CDB 
  • Plugging a Non-CDB into CDB as PDB Using DBMS_PDB 
  • Replicating Non-CDB into CDB 
  • Cloning a Non-CDB or Remote PDB 
  • Plugging an Unplugged Regular PDB into CDB 
  • Flow 
  • Plugging Using Archive File 
  • Unplugging and Plugging Application PDBs 
  • Converting Regular PDBs to Application PDBs 
  • Unplugging and Plugging a PDB with Encrypted Data 
  • Local UNDO Mode Vs Shared UNDO Mode 
  • Cloning Remote PDBs in Hot Mode 
  • Near-Zero Downtime PDB Relocation 
  • Proxy PDB: Query Across CDBs Proxying Root Replica 
  • Creating a Proxy PDB 
  • Using DBCA to Clone a Remote PDB 
  • Using DBCA to Relocate a Remote PDB 
  • Using DBCA to Duplicate a CDB 
  • Dropping PDBs 
  • Summary 

Download Curriculum DOWNLOAD CURRICULUM

  • Objectives 
  • Connection 
  • Switching Connection 
  • Creating Services 
  • Renaming Services 
  • Starting Up a CDB Instance 
  • Mounting a CDB 
  • Opening a CDB 
  • Opening a PDB 
  • Pluggable Database Hybrid Read-Only Mode 
  • Automatic PDB Opening 
  • Closing a PDB 
  • Shutting Down a CDB Instance 
  • Changing PDB Mode 
  • Modifying PDB Settings 
  • Instance Parameter Change Impact 
  • Instance Parameter Change Impact: Example 
  • Using ALTER SYSTEM Statement on PDB 
  • Configuring Host Name and Port Number per PDB 
  • Summary 

Download Curriculum DOWNLOAD CURRICULUM

  • Objectives 
  • Objects in Tablespaces 
  • Tablespaces Created During PDB Creation 
  • Defining Default Permanent Tablespaces 
  • Temporary Tablespaces 
  • UNDO Tablespaces 
  • Summary 

Download Curriculum DOWNLOAD CURRICULUM

  • Objectives 
  • Creating Common Users in the CDB and PDBs 
  • Creating Common Roles in the CDB and PDBs 
  • Granting Privileges Commonly in the CDB and PDBs 
  • Creating Common Profiles in the CDB and PDBs 
  • Common Objects in Application Containers 
  • Operations on Data-Linked Objects 
  • Enabling Common Users to Access Data in PDBs 
  • Finding Information About CONTAINER_DATA Attributes 
  • Restricting Operations with PDB Lockdown Profiles 
  • Restricting Operations in a PDB Lockdown Profile 
  • PDB Lockdown Profiles Inheritance 
  • Static and Dynamic PDB Lockdown Profiles 
  • Auditing Actions in the CDB and PDBs 
  • Managing Other Types of Security Policies in Application Containers 
  • Securing Data with Oracle Database Vault 
  • Oracle Database Vault-Enabled Strict Mode 
  • Managing Keystore in the CDB and PDBs 
  • Creating and Opening a Keystore 
  • Setting TDE Master Encryption Keys 
  • Managing Keystore in the CDB and PDBs 
  • Keystore Management Changes for PDBs 
  • Defining the Keystore Type 
  • Isolating a PDB Keystore 
  • Converting a PDB to Run in Isolated Mode 
  • Converting a PDB to Run in United Mode 
  • Migrating a PDB Between Keystore Types 
  • Unplugging and Plugging a PDB with Encrypted Data 
  • Per-PDB Wallet for PDB Certificates 
  • Summary 

Download Curriculum DOWNLOAD CURRICULUM

  • Objectives
  • Goals 
  • Syntax and Clauses in RMAN 
  • CDB Backup: Whole CDB Backup 
  • CDB Backup: Partial CDB Backup 
  • PDB Backup: Partial PDB Backup 
  • Using RMAN Backup to Plug an Unplugged PDB 
  • Duplicating Pluggable Databases 
  • Cloning Active PDB into an Existing CDB 
  • Example: 1 
  • Example: 2 
  • Duplicating On-Premises CDB as Cloud Encrypted CDB 
  • Duplicating On-Premises Encrypted CDB as Cloud Encrypted CDB 
  • Migrating Cloud Encrypted CDB as On-Premises CDB 
  • Checking for Block Corruption 
  • Summary 

Download Curriculum DOWNLOAD CURRICULUM

  • Objectives 
  • Goals 
  • Instance Failure and Instance Recovery 
  • NOARCHIVELOG Mode 
  • CDB and PDB Tempfile Recovery 
  • CDB SYSTEM or UNDO Tablespace Recovery 
  • PDB SYSTEM or UNDO Tablespace Recovery 
  • CDB or PDB Non-SYSTEM Tablespace Recovery 
  • PITR 
  • Migrating a Non-CDB to a CDB 
  • Migrating a Non-CDB and Transporting Non-CDB Backups to a CDB
  • Relocating/Plugging a PDB into Another CDB 
  • Plugging a PDB and Transporting PDB Backups to a CDB: 1 
  • Plugging a PDB and Transporting PDB Backups to a CDB: 2 
  • Using PrePlug-in Backups 
  • Considerations 
  • Example 
  • CDB and PDB Flashback 
  • PDB Flashback and Clean Restore Point 
  • Creating a PDB Snapshot from a PDB 
  • PDB Snapshot Carousel 
  • Creating PDB Snapshots 
  • Creating PDBs Using PDB Snapshots 
  • Dropping PDB Snapshots 
  • Flashbacking PDBs Using PDB Snapshots 
  • Switching Over a Refreshable Cloned PDB 
  • Unplanned Switchover 
  • Summary 

Download Curriculum DOWNLOAD CURRICULUM

  • Objectives 
  • Tuning a CDB
  • Sizing the CDB 
  • Testing the Estimates 
  • Managing SGA for PDBs 
  • Managing PGA for PDBs 
  • Monitoring PDB Memory Usage 
  • AWR and ADDM Behavior 
  • PDB-Level Snapshot Views 
  • Configuring Automatic ADDM Analysis at the PDB Level 
  • Enabling ADDM in a Pluggable Database 
  • ADDM Data Visibility 
  • Basic Rules: Statistics for Common Objects 
  • Controlling the Degree of Parallelism of Queries 
  • Heat Map and ADO Support 
  • Managing Heat Map and ADO Policies in PDB 
  • CDB Fleet 
  • CDB Lead and CDB Members 
  • Use Cases 
  • DB Replay: The Big Picture 
  • Capturing and Replaying in a CDB and PDBs 
  • Reporting 
  • Consolidated Database Replay Use Cases 
  • Use Cases: Source Workloads 
  • The Big Picture 
  • Step 1 
  • Step 2 
  • Step 3 
  • Step 4 
  • Summary 

Download Curriculum DOWNLOAD CURRICULUM

  • Objectives 
  • Allocating Resources in the CDB 
  • Resource Manager and Pluggable Databases 
  • Managing Resources Between PDBs 
  • CDB Resource Plan Basics: Limits 
  • PDB IO Rate Limit 
  • CDB Resource Plan: Full Example 
  • Maintaining a CDB Resource Plan 
  • Managing Resources Within a PDB 
  • Putting It Together 
  • Considerations 
  • PDB-Level Parallel Statement Queuing 
  • PDB-Level Parallel Statement Queuing: CPU_COUNT 
  • Session PGA Limit 
  • Performance Profiles 
  • Summary 

Download Curriculum DOWNLOAD CURRICULUM

  • Objectives 
  • Using Oracle Data Pump with PDBs 
  • Exporting from Non-CDB and Importing into PDB 
  • Exporting and Importing Between PDBs 
  • Full Transportable Export/Import: Overview 
  • Full Transportable Export/Import: Usage 
  • Full Transportable Export/Import: Example 
  • Transporting a Database Over the Network: Example 
  • Additional Features of Oracle Data Pump 
  • Using SQL*Loader with PDBs 
  • Summary 

Download Curriculum DOWNLOAD CURRICULUM

  • Objectives 
  • Upgrading CDB and PDBs to 23ai: Methods 
  • Upgrading CDB and PDBs to 23ai 
  • Installing Oracle Database 23ai Software Using OUI 
  • AutoUpgrade Utility System Checks 
  • Running AutoUpgrade Fixups 
  • Configuration File to Run AutoUpgrade Prechecks 
  • Upgrading Using the AutoUpgrade Utility 
  • AutoUpgrade with Source and Target Database Homes on the Same Server 
  • AutoUpgrade with Source and Target Database Homes on Different Servers 
  • Overview of AutoUpgrade Job Stages 
  • AutoUpgrade Command-Line Parameters and Options 
  • AutoUpgrade Command-Line Syntax 
  • AutoUpgrade Configuration File 
  • Using Replay Upgrade’s Automatic Upgrade on PDB Plug-In to a CDB23ai 
  • How to Disable or Enable Replay Upgrade 
  • Converting and Upgrading Regular PDBs to Application PDBs 
  • Cross-Platform Transportable PDB 
  • Cross-Platform PDB Transport: Phase 1 
  • Cross-Platform PDB Transport: Phase 2 
  • Summary 

Download Curriculum DOWNLOAD CURRICULUM

  • Consolidated Replay Steps 
  • Procedures for Steps 4 and 5 
  • Procedures for Steps 6 and 7 
  • Procedure to Remap Connections with PDBs 
  • Procedure to Prepare the Replay 
  • Modes of Synchronization 
  • Procedure to Start Replay 
  • Views 

Download Curriculum DOWNLOAD CURRICULUM
video-img

Request for Enquiry

assessment_img

Oracle Database 23ai: Multitenant Architecture Training (MCQ) Assessment

This assessment tests understanding of course content through MCQ and short answers, analytical thinking, problem-solving abilities, and effective communication of ideas. Some Multisoft Assessment Features :

  • User-friendly interface for easy navigation
  • Secure login and authentication measures to protect data
  • Automated scoring and grading to save time
  • Time limits and countdown timers to manage duration.
Try It Now

Oracle Database 23ai: Multitenant Architecture Corporate Training

Employee training and development programs are essential to the success of businesses worldwide. With our best-in-class corporate trainings you can enhance employee productivity and increase efficiency of your organization. Created by global subject matter experts, we offer highest quality content that are tailored to match your company’s learning goals and budget.

500+
Global Clients
4.5 Client Satisfaction
Explore More

Customized Training

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements

Expert
Mentors

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements

360º Learning Solution

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements

Learning Assessment

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements

zoom-in Zoom-in

Certification Training Achievements: Recognizing Professional Expertise

Multisoft Systems is the “one-top learning platform” for everyone. Get trained with certified industry experts and receive a globally-recognized training certificate. Some Multisoft Training Certificate Features :

  • Globally recognized certificate
  • Course ID & Course Name
  • Certificate with Date of Issuance
  • Name and Digital Signature of the Awardee
Request for Certificate

Oracle Database 23ai: Multitenant Architecture Training FAQ's

This training focuses on teaching how to manage container databases (CDBs) and pluggable databases (PDBs) efficiently using Oracle 23ai, covering topics like database creation, cloning, resource management, security, backup, and recovery.

Database Administrators (DBAs), Cloud Architects, System Administrators, Database Developers, and IT Professionals involved in database management, consolidation, or cloud migrations should attend this training.

Learners will gain expertise in consolidating databases, reducing infrastructure costs, improving scalability, simplifying database administration, and preparing for Oracle certifications related to multitenant database management.

Yes, participants should have a basic understanding of Oracle Database architecture, experience with SQL/PLSQL, and prior knowledge of database administration tasks like backup and recovery.

To contact Multisoft Systems you can mail us on info@multisoftsystems.com or can call for course enquiry on this number +91 9810306956

What Attendees are Saying

Our clients love working with us! They appreciate our expertise, excellent communication, and exceptional results. Trustworthy partners for business success.

Share Feedback
  WhatsApp Chat

+91-9810-306-956

Available 24x7 for your queries

For Career Assistance : contact +91-9810306956