Creating a Container Database using DBCA

For Creating a Container Database using SQL Statements Please click here

Let’s us create a container database by name ICA and one pluggable database PDB1.

We will place all datafiles, logfiles,controlfile of CDB in /u02/oracle/ica directory and place seed database pdbseed database datafiles in ‘/u02/oracle/ica/pdbseed’ directory and pluggable database PDB1 files /u02/oracle/ica/pdb1 directory

Step 1: Make directories

$mkdir /u02/oracle/ica
$cd /u02/oracle/ica
$mkdir pdb1

Step 2. Start DBCA

Grant access to X-Windows by typing following command as root

#xhost +

Start DBCA as Oracle User

$ dbca

Choose "Create Database" option and click "Next" button

Enter or edit the given options like Files Location, Administrative Password etc and click Next

Next Page