In this article, we will see how we can plug the Non-CDB database as a Pluggable Database in a Container Database.

Step 1: Check non-cdb Database

Step 2: Gracefully shut down Non-CDB database and open it in READ ONLY stage

Step 3 : Call DBMS_PDB.DESCRIBE procedure, that will create the XML file

Step 4: Shut down the non-cdb database

Step 5: Connect to the CDB database

Step 6: Create the new pluggable database using XML file we have created with a non-cdb database

Step 7: Connect to PDB1

Step 8: Run noncdb_to_pdb.sql file this file will delete redundant metadata and convert non-cdb to pluggable database:

Step 9: Connect to CDB or PDB and open pluggable database :

Step 10: Connect to PDB1 and check database details :

Stay tuned for More articles on Oracle Multitenant

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

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