
Explore Oracle 19c multitenant architecture by creating and managing pluggable databases within a container database, and performing backup, recovery, and resource management tasks.
Set up an Oracle Linux 7.8 virtual machine in Oracle VirtualBox, configure two networks, attach the installation ISO, and begin the Oracle software installation to prepare for creating databases.
Install Oracle database 19c software in a virtualized environment, complete with preinstalled setup, password changes, installer execution, VM cloning, network configuration, and final login readiness.
Create CDB and non-CDB databases in Oracle 19c, install and configure the database, manage shared memory, set up the listener, and use the interface manager to monitor performance.
Create PDBs from the seed in Oracle 19c multi-tenant architecture, configure and manage pluggable databases to support scalable, isolated tenant environments.
Explore basic CDB administration tasks in Oracle 19c multi-tenant architecture, including starting and stopping the container, opening and closing PDBs, and managing parameters, global names, and data files.
Create a pluggable database by cloning from local and remote PDBs, then start up the database to establish the new PDB.
Learn to plug an unplugged PDB into the database, verify compatibility, open the PDB, and confirm it remains integrated and functional after the plug-in.
Create a pluggable database from non-cdb, copy the required data, clone the pdb, open it, and use database links to complete the migration.
Learn how to create a PDB by relocating it, achieving high availability with minimal downtime, and perform planning, DNS updates, and testing during the transition.
Oracle 12c introduced a new architecture - Multi-tenant database. It simplified database consolidation and eased maintenance of mutiple databases regarding upgrade, patching and day-to-day maintenance. From 20c the non-CDB architecture will be de-supported. So it is very important for the DBA to learn Oracle Multi-tenant architecture and administration. This course aims at providing an in-depth explanation of Multi-tenant dba with 100% hands-on approach.