New Year Offer - Flat 15% Off + 20% Cashback | OFFER ENDING IN :

Oracle Database 23ai: Multitenant Architecture Training

10265 Learners

Download Course Brochure INTERVIEW QUESTIONS Unlock June Offer

Advance your expertise with Oracle Database 23ai: Multitenant Architecture training by Multisoft Virtual Academy. This course covers PDB and CDB configuration, resource allocation, backup strategies, and migration techniques. Designed for DBAs and IT professionals, the program offers expert-led sessions to help you optimize Oracle’s multitenant features for enterprise environments.

Download Course Brochure

Ready to Up-Skill yourself !

Share your details for best career advice.

Contact Training Adviser Enroll Now

Instructor-led Training Live Online Classes

Suitable batches for you

	07 Jun 2025	24	06:00 PM - 09:00 PM	Sat, Sun
	08 Jun 2025	24	06:00 PM - 09:00 PM	Sat, Sun

Course Price At

$ 550

Enroll Now

Secure Transaction

Talk to our training advisor

Name*

Email ID*

Company Name*

Phone Number*

Query

Build Your Own Schedule

Instructor-led Training Live Online Classes

	07 Jun 2025	24	06:00 PM - 09:00 PM	Sat, Sun
	08 Jun 2025	24	06:00 PM - 09:00 PM	Sat, Sun

Course Price At

$ 550

Enroll Now

Secure Transaction

Online Self Learning Courses are designed for self-directed training, allowing participants to begin at their convenience with structured training and review exercises to reinforce learning. You’ll learn through videos, PPTs and complete assignments, projects and other activities designed to enhance learning outcomes, all at times that are most convenient to you.

Course Price At

$ 550

Enroll Now

Secure Transaction

Talk to our training advisor

Name*

Email ID*

Company Name*

Phone Number*

Query*

Build Your Own Schedule

Instructor-Led Online Training Parameters

Course Highlights

Duration: 24 Hrs
Subject Matter Expert
After Training Support
Lifetime E-Learning Access
Recorded Sessions
Free Online Assessments

One to One Training

Oracle Database 23ai: Multitenant Architecture Training Course Syllabus

Curriculum Designed by Experts

DOWNLOAD CURRICULUM

The Oracle Database 23ai: Multitenant Architecture training course by Multisoft Virtual Academy is designed to equip database administrators, IT professionals, and developers with comprehensive knowledge of Oracle’s multitenant architecture—a key feature for modern database consolidation and cloud readiness. This instructor-led program delves into the concepts and implementation of container databases (CDBs) and pluggable databases (PDBs), enabling participants to manage multiple databases efficiently within a single Oracle instance. The course covers essential topics such as creating and managing CDBs and PDBs, performing backup and recovery operations in a multitenant environment, resource management among pluggable databases, cloning PDBs, unplugging and plugging databases, and managing application containers. Emphasis is placed on real-world scenarios and hands-on labs to ensure participants can apply their skills in production environments.

Participants will gain insights into performance tuning, security management, and high availability in a multitenant setup. This training aligns with Oracle’s latest innovations in database technology and helps professionals stay competitive in the evolving IT landscape. Whether migrating existing systems or designing new solutions, this course empowers learners with the skills to optimize and manage Oracle Database 23ai multitenant environments effectively.

Oracle Database 23ai: Multitenant Architecture training teaches participants how to manage container databases (CDBs) and pluggable databases (PDBs) effectively. It covers creation, cloning, security, backup, recovery, and resource management within a multitenant environment. The training is ideal for database administrators and IT professionals seeking to master Oracle’s latest database consolidation and management techniques.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Free Career Counselling

We are happy to help you 24/7

Name*

Email*

Number*

Oracle Database 23ai: Multitenant Architecture Training Description

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.

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

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

Oracle Database 23ai: Multitenant Architecture Training Certification

Multisoft Virtual Academy provides a globally recognized training certificate to the participants, after successful completion of a training program. The training certificates are recognized and accepted across the world.

Multisoft Virtual Academy's training certificate comes with lifetime validity.

Aspirants can directly enroll for the desired course from the Book Now Button in the course page. You can also connect on Whatsapp at +91 8130666206 to talk with a training advisor. Multisoft Virtual Academy also offers customized training programs on a wide range of domains and skills.

All training programs offered by Multisoft Virtual Academy are delivered by certified industry experts, who have years of experience in the relevant domains. Multisoft Global Subject Matter Experts impart knowledge on a wide variety of training courses through one –on-one and corporate training sessions.

Multisoft Virtual Academy training certification can help participants stand out in the competitive job market. Since the training certificates are internationally accepted, participants can showcase their skills and knowledge to employers across the world.

Zoom-in

GET A SAMPLE CERTIFICATE

Oracle Database 23ai: Multitenant Architecture Corporate Training Certification

Interactive Virtual Training

Global Subject Matter Experts
Step-by –Step Learning Approach
Instant Doubt Clearing

Lifetime Access

Lifetime E-learning Access
Recorded Training Session Videos
Free Access to Practice Tests

24x7 Assistance

Help Desk Support
Doubt Resolution in Real-time
After Training Support

Hands on Experience

Project Based Learning
Learning based on real-life examples
Assignments and Practice Tests

Globally Recognized Certificate

Multisoft Training Certificate
Globally Recognized and Accepted
Lifetime Validity

Like what you hear from our learners?

Take the first step!

Drop us Query

Enroll Now Or, Learn More

Oracle Database 23ai: Multitenant Architecture Training FAQ's

Yes, the training is delivered online through live instructor-led sessions for flexible learning.

Participants should have a basic understanding of Oracle database administration and SQL. Prior experience with Oracle Database 12c or later is recommended.

Key topics include CDB and PDB architecture, creation and management of containers, resource allocation, PDB cloning, unplug/plug operations, backup/recovery in multitenant environments, and application containers.

Yes, participants will receive a certificate of completion from Multisoft Virtual Academy after successfully completing the course.

To contact Multisoft Virtual Academy you can mail us on enquiry@multisoftvirtualacademy.com or can call for course enquiry on this number +91 8130666206