Database Reference
In-Depth Information
This chapter is divided into two sections; the first section is an
introduction to the concepts of the Oracle multitenant architec-
ture, new to Oracle Database 12
c
. The second—and larger—
section is an introduction to creating multitenant container databases (CDBs) and pluggable
databases (PDBs).
In the first section we will describe the components, advantages, and fundamentals of the
multitenant architecture and explain at a high level how to provision new pluggable databases.
In the second section we will introduce and demonstrate the different methods used to
create CDBs and PDBs. You should already be familiar with the tools used to create CDBs
and PDBs, since they're the same as for creating non-CDBs, but they've been updated to
work with the multitenant architecture. We'll also discuss unplugging and dropping PDBs,
as well as migrating Oracle databases that were created in a previous version into the new
multitenant architecture.
Exam objectives are subject to change at any time without prior notice and
at Oracle's sole discretion. Please visit Oracle's Training and Certification
website (
http://www.oracle.com/education/certification/
) for the
most current exam-objectives listing.
Multitenant Container and Pluggable
Database Architecture
New to Oracle 12
c
, the Oracle multitenant architecture is designed to allow an Oracle data-
base to host multiple Oracle databases within one overall structure. The multitenant container
database (CDB) can include zero, one, or many DBA-created pluggable databases (PDBs).
From a client connection perspective, a PDB looks like a traditional Oracle database and com-
prises schemas, schema objects, and non-schema objects. Oracle databases prior to Oracle 12
c
were non-CDBs.
Describing the Multitenant Architecture
The basic components of the multitenant architecture are the multitenant container data-
base (CDB) and its zero to many DBA-created pluggable databases (PDBs). Consider the CDB
the host for zero to many PDBs. In the multitenant architecture, a PDB doesn't have the neces-
sary structures to stand independently as an Oracle database: it must reside within a CDB.
Search WWH ::
Custom Search