Database Reference
In-Depth Information
50 SGAs on multiple servers, possibly running several different operating systems and
versions of Oracle Database.
Explaining Pluggable Database Provisioning
In Oracle Database 12
c
, the DBA has the option to create a new database as a container
database, a pluggable database that exists within a CDB, or a non-container database. The
non-container database is conceptually the same as databases created in versions prior to
Oracle Database 12.1.
In this section we will explain the concepts fundamental to creating a CDB and then
discuss the concepts behind creating PDBs.
Concepts of CDB Creation
As mentioned previously, the CDB is the building block for PDBs, so the DBA needs to cre-
ate a CDB prior to plugging in or creating new PDBs. The initial planning steps for the CDB
are the same as for traditional non-CDBs. That is, you'll need the base software, sufficient
storage to build, and sufficient memory and CPU to run a CDB. Consider that your CDB
will most likely host multiple PDBs, so sufficient server resources are critical to planning a
successful multitenant implementation.
Methods to Create a CDB
In the next section we will go into detail about how to create CDBs and PDBs using dif-
ferent methods. For now, you need to know that the same tools used to create non-CDBs
are used to create CDBs. At the command line, SQL*Plus is the primary tool used to cre-
ate a new CDB. The preferred GUI method is to use the Database Configuration Assistant
(DBCA). Oracle recommends that you use the DBCA to create and configure CDBs, PDBs,
and non-CDBs. Also, the DBA can create a new CDB using Enterprise Manager Cloud
Control 12
c
(EM12
c
).
Methods to Create a PDB
As with CDBs and non-CDBs, the tools used to create PDBs are fundamentally the same:
SQL*Plus at the command line and the DBCA. But with PDBs you can also create new PDBs
from different sources:
Using the seed database in the CDB:
PDB$SEED
■
Cloning an existing PDB
■
Plugging an unplugged PDB into a CDB
■
Creating a PDB by moving a non-CDB into a PDB
Also, the DBA can create a new PDB using EM12
c
.
■
Search WWH ::
Custom Search