Oracle 12c Database: Managing PDBs using Database Configuration Assistant

In 12c, the database configuration assistant can also be used to manage the PDB’s alongside the CDB and non-CDB databases. In this article we will look at managing the PDBs, using the database configuration assistant.


Related Articles
SGA Instance Parameters in CDB and PDB
Managing CDB and PDB tablespaces
Flashback a CDB Database
Managing Common and Local Users, Roles and Privileges for CDB and PDB
Create 12c CDB PDB Using OUI

Managing PDBs

When you launch DBCA, you will see a new option “Manage Pluggable Databases”, as shown below.

Manage PDB

The new Manage Pluggable databases option can be used to manage the PDBs inside the different CDBs. The following sections demonstrate the different options available in DBCA, with respect to PDB management.

Create PDB Database

You can create a new PDB by clicking Next once the Manage Pluggable Databases option is selected in the DBCA. The following screens will guide you through the process of creating a new PDB database.

Create PDB 1


Choose the Create option and click Next.

Create PDB 2


Choose the CDB container for which the new PDB database should be part of. You will also have to provide the SYSDBA credentials for the CDB chosen. Then click on Next.

Create PDB 3


You can create a new database from scratch or you can create a database as a clone of some other PDB, for which you either have an archive or you unplugged earlier. So effectively, this option allows you to clone a PDB. We will create a new database. Click on Next.

Create PDB 4


Specify the name of the PDB database, the file location and the admin username and password for it. You can also optionally configure the Vault and Label security if you want to. Click Next.

Create PDB 5


Review the summary screen and Click Finish once you are OK with it.

Create PDB 6


The new PDB has been created.

Unplug the PDB Database

The DBCA can also be used to unplug a PDB from a CDB container. This is required if you want to migrate the PDB database from the current CDB container to some other or you want to clone it.

Unplug PDB 1


Select the “Unplug a database” option and then click on Next.

Unplug PDB 2


Select the CDB of which the PDB is currently part of. Provide the SYSDBA credentials and click on Next.

Unplug PDB 3


Select the PDB that you want to unplug. You can generate an archive of the PDB or you can generate an XML manifest file along with the database backup. Both will ensure that PDB can be attached later on. Provide the location where you want to store these files. Click on Next.

Unplug PDB 4


Review the summary screen and Click on Finish to start the unplugging process.

Unplug PDB 5


The PDB has been unplugged and as a result would have been deleted from its current CDB.

Delete the PDB Database

You can delete a PDB as well using the DBCA. The following screens will show you how.

Delete PDB 1


Select the delete option and click on Next.

Delete PDB 2


Select the CDB of which the target PDB is part of. Provide the SYS username and password and then click on Next.

Delete PDB 3


Select the PDB that you wish to remove. Click on Next.

Delete PDB 4


Review the details and click on on Finish, to start the removal process.

Delete PDB 5


The selected PDB has been successfully deleted.

Configure a PDB Database

The last option is to configure your already existing PDB.

Configure PDB 1


Choose the last option and then click on Next.

Configure PDB 2


Choose the CDB container which contains your PDB. Provide the SYS username and password and click on Next.

Configure PDB 3


Choose the PDB that you want to configure. Then click on Next.

Configure PDB 4


You can configure the Label security and/or database Vault. Choose the desired option and click on Next.

Configure PDB 5


Review the summary screen and click “Finish”, to start the configuration process.

Configure PDB 6


Click OK once and the configuration is completed!


External Links
CDB and PDB Information in Views
Using the ALTER SYSTEM Statement to Modify a PDB