Plugin a Pluggable database using Database Configuration Assistant

We can plugin back a Pluggable database using Database Configuration Assistant OR manually from SQL prompt as sysdba privilege.

Here we covered Database Configuration Assistant to plugin back a Pluggable database.

 

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

Plugin_pluggdb_1

Plugin_pluggdb_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.

Plugin_pluggdb_3

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

& click Next.

Plugin_pluggdb_4

 

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

In my case, “orcl” is Container Database.

& click Next.

Plugin_pluggdb_5

 

On “Create Pluggable Database” prompt, select the “Create Pluggable Database using PDB file set” radio button.

In my case, I have created PDB file set at the time of unplug pluggable database, that’s why I would like to go with “Create Pluggable Database using PDB file set” option.

If you unplug your Pluggable database with the help of “Create Pluggable Database From PDB archive” then choose same for re-plug pluggable database.

& click Next.

Plugin_pluggdb_6

Choose .xml file of your Pluggable database that you want to plug in back.

& click Ok.

Plugin_pluggdb_7

 

On “Pluggable Database Option” prompt.

Enter the pluggable database name that you want to plugin back, also provide PDB user details as below.

& click Next.

Plugin_pluggdb_8

 

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

Plugin_pluggdb_9

 

Progress page will show you the progress of same.

Plugin_pluggdb_10

 

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

Plugin_pluggdb_11

PlugDB – Pluggable database has been plugin 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