Pluggable Databases - Expert Consolidation in Oracle Database 12c - page 239

Table 7-1. ( continued )

Step Action to take for database creation

The dbca utility validates your choices against the system to ensure that all
pre-requisites such as free space to create the database are met. Normally the screen
should not be visible: if dbca does not find anything to complain about it moves
immediately on to the next screen.

12) Pre Requisite Checks

13) Summary On this page you are presented with the HTML-styled document summarizing

the options you chose. It lists the database components you selected and other
important information such as Oracle SID and whether or not the database to be
created is a CDB.

14) Process The process page informs you how far into the database creation you have

progressed. At the end of the database creation you are presented with account
management information in a pop-up window, which you confirm and then exit
dbca . The new database is ready for use.

After you have created the database it will be ready to accept user connections. If the database was installed on a
system with ASM, it will automatically be registered with Oracle Restart.

Creating a CDB using scripts
The method of creating an Oracle container database has changed with the introduction of the Container Database.
It would also appear that the process of creating a CDB from scripts takes longer, but this might be a subjective effect.
The below example scripts have been created using the Database Creation Assistant and should be modified for your
environment. Some parts of the scripts have already been adjusted. A common location has been chosen for all data
files, which could be a problem for production deployments on contended storage use but serves as a good example
regarding the location of the PDB files. By default dbca creates the scripts in

$ORACLE_BASE/admin/${ORACLE_SID}/scripts/

The main script to invoke when creating a database is a shell script named after the database. After creating the
supporting directory structure the CDB creation begins with the create database command. While using previously
mentioned common location for all data files, the following directories are created by the script, among others:

mkdir -p /u01/oradata/CDB1
mkdir -p /u01/oradata/CDB1/pdbseed

The shell script ${ORACLE_SID}.sh sets some environment variables for Oracle's perl implementation delivered
as part of the RDBMS installation. Before continuing you should heed the advice in the script and add an entry for the
new database in the oratab file.
You would expect the CDB$ROOT's files to be stored in /u01/oradata/CDB1, and the seed's files plus in
/u01/oradata/CDB1/pdbseed. After all administrative tasks have completed, this slightly modified “create database”
statement is executed:

CREATE DATABASE "CDB3"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16