Multinenant:
The multitenant option introduced in Oracle Database 12c allows a single container database (CDB) to host multiple separate pluggable databases (PDB).
The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB).
A CDB includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and non schema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs.
Why Multitenant Concept?
In 11g,sometimes we need to create numerous databases in single host which resulted below side effects and eventually slowed down whole system.
1.Too many background processes.
2.High shared memory.
3.Many copies of oracle metadata.
Now what Oracle 12c PDB concepts bring to us
1.Multiple databases in centralized managed platform.
a.Less instance overhead.
b.Less storage.
2.Fast and easy provisioning.
3.Time savings for patch and upgrade.
4.Separation of duties.
5.Ensure full backward compatibility with Non-CDB.
6.Fully operate on RAC.
Create Container Database using DBCA method:
select create database option then click next button
Provide required Global Database name and password and select create as container database option with giving pluggable database name
click Finish button to complete database creation
Now the database has been created.We can check by logging in.
Successfully database opened.
we can check the cdb and pdb name by providing this command.
select name,pdb from v$services order by name;
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
