Create Pluggable Database using Database Configuration Assistant

We can create Pluggable database at the time of creation of Container database & we can also create Pluggable database with the help of Database Configuration Assistant.

Here we considered Container database already installed, if not then kindly follow my one of the post: Oracle 12c Installation

 

// To initiate database installer, start “Database Configuration Assistant” by issuing “dbca” command from bin library as shown below.

Create_plugdb_1

Create_plugdb_2

 

On “Database Operation” prompt, select the “Manage Pluggable Databases”

In this we can create new pluggable database as well as manage existing pluggable databases.

Click Next to continue.

Create_plugdb_3

 

On “Manage Pluggable Databases” prompt, select the “Create a Pluggable Database”

& click Next.

Create_plugdb_4

 

On “Database List” prompt, select the Container Database.

In my case, “orcl” is Container Database.

& click Next.

Create_plugdb_5

 

On “Create Pluggable Database” prompt, select “Create a new Pluggable Database” radio button.

& click Next.

Create_plugdb_6

 

On “Pluggable Database Option” prompt.

Enter the pluggable database name, database location & admin credentials.

& click Next.

Create_plugdb_7

 

Ensure the summary about your provided database, if u wish to continue click Finish button.

Create_plugdb_8

 

Progress page will show you the progress of same.

On completion of installation, click the “OK” button on the message dialog and the “Close” button on the main screen.

Create_plugdb_9

Pluggable database has been created successfully.

***********************************************************************

Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a easy life ahead.

Leave a Reply