Create PDB using DBCA (Simple)

Overview

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

References

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:

Step 1: Database Operation

Then click Next .

Manage Pluggable Databases

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

Step 2: Manage Pluggable Databases

Then click Next .

Database List

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

Step 3: Database List
Then click Next .

Create Pluggable Database

Choose Create a new Pluggable Database on the following screen:

Step 4: Create Pluggable Database

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
Step 5: Pluggable Database Operations

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.

Step 6: Summary

Then click Finish .

Progress Page

The following page appears:

Step 7: Progress Page

The following message then appears:

Error message saying that USERS tablespace already exists

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:

Step 8: Finish

Then click Close .