Workshop
digicode: ODBMT
Oracle Multitenant Database Workshop
Course facts
Download as PDF- Understanding the architecture of Oracle Multitenant with Container Database (CDB) and Pluggable Databases (PDBs)
- Understanding the advantages and disadvantages of the multitenant architecture compared to non-CDB databases
- Migrating existing non-CDB databases to a multitenant architecture
- Administering multitenant environments, including PDB management, backup and recovery, and upgrade processes
- Applying security and schema concepts and working with application containers
Oracle Multitenant is an option for the Oracle database in which the database is divided into so-called containers and thus a physical separation of the metadata of the database (CDB$ROOT) from the metadata and data of the applications (pluggable databases, or PDBs for short) takes place.
The topics range from the architecture of the container database and pluggable databases to local and common objects, creation and administration of PDBs and application containers.
It is a course that requires prior knowledge of data administration. The workshop offers sufficient space for exercises in which the newly acquired knowledge can be implemented or existing knowledge can be deepened.
Topics:
- Architecture of the Oracle multitenant database
- Security and schema concept of the multitenant database
- The advantages and disadvantages of the multitenant database architecture
- Administration - differences to non-CDB databases
- PDB management (creating and cloning PDBs)
- Migration of non-CDB databases to Multitenant
- Application Container
- Backup and recovery
- Administration - other topics
- Upgrade in Multitenant Environments
Prospective Oracle database administrators, as well as Oracle developers or architects who want to know more about the inner workings of the database.
You have knowledge of SQL as well as a basic understanding of servers and operating systems.
You are familiar with terms such as CPU, memory, storage space, IP address, etc.
This workshop is based on Oracle Database 23ai, but is not tied to any specific Oracle version; 26ai is also included. Further information about the course environment and Oracle licensing can be found here.
SQL*Plus is used as the front end. While it is possible to use Oracle SQL*Developer or one of the many third-party tools (Toad, SolarWinds, etc.) in some cases, this will result in different exercise procedures.