Create PDB using DBCA (Simple)

Overview

This procedure show how to create a 12.1 PDB using DBCA without using any advanced options.

References

• Oracle ^® 12.1 Database 2 Day DBA
• 2 Installing Oracle Database and Creating a Database
• 2.3 Creating and Managing a Database with DBCA
• 2.3.1 Starting DBCA
• 2.3.2 Creating a Database Using DBCA

Procedure

The procedure is in 2.3.2 Creating a Database Using DBCA .

Database Operation

After dbca is started , choose Manage Pluggable Databases as shown below:

Then click Next .

Manage Pluggable Databases

When the next screen appears, choose Create a Pluggable Database as shown below:

Then click Next .

Database List

From the following list, choose the existing container database, jar , and enter SYS and its password:

Create Pluggable Database

Choose Create a new Pluggable Database on the following screen:

Then click Next .

Pluggable Database Options

On the following screen,

1. Set Pluggable Database Name to newpdb
2. Select Use Oracle Managed Files
3. Select Create Default User Tablespace
4. Enter newdba as the Administrator Username
5. Enter the Administrator Password

Then click Next .

Summary

Verify that we are creating the PDB called newpdb in the container database, jar , from the default pluggable database source, and we are using Oracle Managed Files. Database Vault , Label Security , and OID are not configured.

Then click Finish .

Progress Page

The following page appears:

The following message then appears:

Then click Ignore as the USERS tablespace was part of the seed database.

Finish

Eventually, the Finish page appears indicating that the PDB creation was successful:

Then click Close .