Embark on a comprehensive journey through Oracle Multitenant architecture in this course. You will start with an introduction to its key concepts and create a robust Oracle 12c multitenant CDB container on a Linux platform. You will master the art of PDB creation, from establishing them from the seed and cloning them locally or remotely, even exploring the nuances of refreshable PDBs. You will then look at plugging in and relocating PDBs, along with creating them from non-CDB databases and setting up Proxy PDBs.
After that, you will create and manage common and local user accounts and roles. Gain expertise in managing PDB lockdown profiles to ensure a secure multitenant container.
Master backup and recovery techniques like PITR and database flashback and become adept at using the Resource Manager in multitenant containers. Harness the capabilities of the Data Pump utility with PDBs, and oversee applications, application containers, application PDBs, and common objects.
The course covers the latest features in Oracle 18c and 19c. Dive into managing the CDB fleet, navigating a PDB Snapshot Carousel, executing Switch Over actions for Refreshable Clone PDBs, and perfecting PDB cloning and relocation using DBCA.
By the end of the course, you will be able to build a reliable, secure, and easy-to-manage Oracle multitenant database.
Learn Oracle multitenant architecture and create multitenant CDB
Create a pluggable database using different methods
Create and manage common and local user accounts
Perform backup and recovery along with PITR and flashback
Use Resource Manager in a container database and data pump utility with PDBs
Manage applications, application containers, and PDB lockdown profiles
In the concept lectures, you will get comprehensive explanations of the subject, occasionally supported by practical implementation procedures. Each concept lecture is followed by a practice lecture, allowing for hands-on experience in the application of the newly acquired knowledge.
The other prerequisites are a basic knowledge of the Linux operating system and access to a computer with a minimum configuration of 16 GB RAM, 100 GB HDD, running a 64-bit version of Windows 7, 8, or 10 with Oracle VirtualBox installed.