Oracle multitenant database architecture gives the ability to virtualize oracle database implementations, similarly to OS virtualization. The multitenant architecture has two main components: The CDB – Container Database and PDB – Pluggable database. These two components have many aspects which help to describe their architecture and are detailed below:
CDB – Container Database
- CDB is commonly referred to as the root container.
- One root container in any implementation and contains all oracle provided metadata and common user.
- CDB$ROOT is the name of the root container.
- All PDBs belong to a single root container.
- User or application data should never stored in the root.
- You can have common users for system administration in root that crosses all PDB in the root container.
- One seed PDB exist in all root containers, Oracle supplies this template to create new PDB.
PDB – Pluggable Database
- PDB$SEED is the name of the seed PDB in all root container databases.
- You cannot add or modify objects in PDB$SEED.
- Zero or more user-created PDBs in CDB.
- PDBs are entities that contain application data and code for specific features.
- PDBs do not contain oracle supplied metadata or common users.
- No PDBs exist at CDB creation.
- PDBs are uniquely named in a CDB.
- PDBs name must be unique across multiple CDB if using the same listener.
Larry Catt
OCP