In the previous article, we can see that the architecture of multitenant. In this post, we will configure manually CDB and PDB.

Introduction of Multitenant Architecture

Step 1: create initmycdb.ora

Step 2: Create necessary directories.

Step 3: export ORACLE_SID and start the database in the nomount stage

Step 4: Create a script to create a manual database using create database command with ENABLE PLUGGABLE DATABASE clause.

Step 5: Run this script on sql prompt :

you will get Database created output after successful completion of this script.

Now run catcdb.sql

Creating pdb as I have used OMF, I don’t need to use file_name_convert parameter

Check using show pdbs command

Open pluggable database

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: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

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