Creating new CDB using DBCA in 12cR1

Oracle Database 12c allows single container database (CDB) to host multiple separate pluggable databases (PDB). This post covers creating a new CDB using DBCA.

Follow below steps to create new container database using DBCA:

Step 1: Set the base parameters and Invoke DBCA

 

Step 2: Database Operation - Select "Create Database". Click Next.

 Step 3: Creation Mode - Select "Advanced Mode". Click Next.

Step 4: Database Template - Select "General Purpose or Transaction Processing". Click Next.

Step 5: Database Identification - Enter Global Database Name: cdb2

SID: cdb2

Select "Create As Container Database"

Select "Create An Empty Container Database"

Click Next.

Step 6: Management Options - Deselect "Configure Enterprise Manager (EM) Database Express". Click Next.

Step 7: Database Credentials - Select "Use same Administrative password for all accounts" and Enter Password and Confirm password. Click Next.

Step 8: Network Configuration - Click Next.

Step 9: Storage Locations - Confirm Storage type is "File System". Select "Use Common Location for All Database Files". Click Next. 

Step 10: Database Options - Click Next. 

Step 11: Initialization Parameters - Select "Character Sets", Select "Use Unicode (AL32UTF8)". Click Next.

Step 12: Creation Options - Select "Create Database". Click Next.

Step 13: Pre Requisite Checks and Summary - Click Finish

Database creation is in progress

Database creation completed. Click close

Thats it. Hope this article will help you :-)

Thanks,

Chowdari