Creating Oracle Multitenant Databases - OCP: Oracle Database 12c Administrator Certified Professional - page 508

Creating Multitenant Container
Databases and Pluggable Databases
In the following sections, you will learn how to configure and create multitenant CDBs
and PDBs. You will learn the different tools and methods for creating CDBs and PDBs.
We will teach you how to unplug and drop a PDB, and we will teach you how to migrate
non-CDB databases to CDBs. Remember, all databases created prior to version 12.1 are
considered non-CDBs.
As mentioned before, the tools available to create CDBs and PDBs are familiar: SQL*Plus,
the Database Creation Assistant (DBCA), and EM12 c .
Creating and Configuring a CDB
The method to create a CDB is almost identical to the one for creating a non-CDB, so if
you're familiar with previous versions of Oracle Database, there's not a completely new set
of commands and concepts to learn. As with all new database installations, planning for
growth and overall performance is key to the success of the implementation.
In this chapter we will not go into great detail about how to create a new
database. We will focus on the differences associated with creating CDBs
and PDBs in the multitenant architecture. The examples in this chapter
were performed with Oracle Database 12 c 64-bit on Windows 7 64-bit.
Creating a CDB Using the DBCA
From the Windows Start menu, navigate to the Oracle 12 c folder and then the
Configuration and Migration folder.
1. Select the Database Configuration Assistant. The DBCA GUI launches, and you will be
placed on the Database Operation screen, as shown in Figure 11.1.
2. On the Database Operation screen, choose the first item, Create Database. Familiarize
yourself with the other options, and notice that the last item allows you to use the DBCA
to manage pluggable databases.
3. Click Next and you will progress to the Creation Mode screen, which allows you to
specify the details of the new database, as shown in Figure 11.2.
On the Creation Mode screen, enter the name of the new database, storage type, file
locations, character set, and the administrative password for the SYS account.
4. For this lesson, we're most interested in the Create As Container Database option.
Check this box, and enter the name of your first DBA-created pluggable database.