CREATION OF PLUGGABLE DATABASE USING DBCA 19c

We can create only one pluggable database during the installation of oracle database for creating additional pluggable database we can use DBCA or SQL query. Let’s use DBCA and create a pluggable database.

For easy GUI and overcome display related issues use MobaXterm and ensure you are logged in as oracle user.

1. run the following command as oracle user

$dbca

OR

$cd $ORACLE_HOME/bin

$./dbca

 2. Select the option “Manage pluggable databases” and click the Next button.

3. Select the option “Create pluggable database” and click Next.

4. Select the container and enter the sys user credentials and click Next.

 

5. Select the option "Cretae a new pluggable database from another PDB" and in "Select pluggable database" drop-down choose PDB$SEED. If you want to create a pluggable database from the existing database then you can choose that existing pluggable database from the drop-down and click Next.

  6. Enter name and administrator username and password for pluggable database and click Next.

  7. Select the Storage type as File System if ASM then select ASM from the drop-down and enter the database location for storing the datafiles of pluggable database.

8. Review the Database configuration assistant summary if happy click on Finish.

   9. Creation of new PDB starts as shown in below screenshot and wait until completes.

 

10. Once installation is completed successfully the below wizard pops up and click on close button.