Create PDB with DBCA utility in Oracle

Create PDB with DBCA utility in Oracle

1. Run the DBCA utility from Administrative Command Prompt.

2. Following screen appears, select manage pluggable databases option on Select database operation screen.

DBCA pluggable database.PNG

3. On manageable Pluggable databases screen, you can create, delete, unplug and configure the pluggable database.

Pluggable Create.PNG

4. Select the container database in which you want to create the pluggable database. In my example, i have one container database so that why i am see on CDB in my screen shot.

Choose container DB

5. Choose PDB template from which you want to create your new PDB database.
In my example, i choose default PDB$SEED template for fresh PDB database. If you want replica of another PDB like application db then you choose that one.

Create PDB

6. Give PDB database a name and give the admin username and password. Don’t use SYS default user in it otherwise you will get error message.

PDB Name

7. Choose the PDB storage location.

PDB storage.PNG

8. Verified the summary of parameter choose and press next for start.

Summary

9. Creation of Pluggable Database is in progress & press next it’s completed.

Progress page

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.