Oracle Container Database (CDB) vs Pluggable Database (PDB)
HTML-код
- Опубликовано: 5 авг 2024
- Container Database (CDB): The primary database that contains multiple plugged-in databases. Many operations can be performed at the container level to reduce management costs. A #database is created as either a #CDB or a non-CDB.
Pluggable Database (PDB): A set of #schemas, #objects, and non-schema objects that can be plugged and unplugged from a container database. The PDB appears to #OracleNet and end users as a database in and of itself but is actually managed within a container that may have many PDBs.
00:00 Non-CDB
01:29 What is CDB?
03:47 How to create PDBs?
07:52 What is PDB?
10:07 Roles changed in PDB
Website: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis - Наука
Great video, simple explanation! thanks for posting!
Glad you enjoyed it!
Nice and simple , thanks.
Welcome 😊
Thank you for the explanation
You are welcome!
great video, thanks
Glad you liked it!
Many Thanks
Welcome!
may you please describe the other clauses like path_prefix, TEMPFILE REUSE and others
great explanation ❤️❤️❤️❤️
Glad you liked it!
nicely explained
Keep watching
thanks for the presentation. what's the next video right after this? can you please post the video link for the next one?
if we are using 19c .. then we are working on CDB & PDBs I think. so we can say blindly we are working on cdbs. sorry if I am wrong..!! please advise..
Some ome pls tell me where is pdb and cdb are used... in RAc or other environment??
When we are cloning sales pdb to new pdb does it copy sales data also?
yes
thank you finally a simple expalation
Glad it helped!
@@dbagenesis again thank you so much!
I am trying to connect to the oracle pluggable database container 'orclpdb' created during installation process in oracle 19c through JDBC using URL con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orclpdb","ot@orclpdb","orcl1234");
But i am not able to do so... i am getting error [Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor]
I have also configured orclpdb service name through Oracle Net Manger but its not working still..
Plz help i am totally stuck into it 🤷♀️🤷♀️
Is it possible to create greater than two or more CDB in one Architecture???
Only one CDB and Multiple PDBs
So when you are saying we are creating PDB's like HR database , Sales Database , are you referring to HR schema's and Sales Schema
Nope, independent databases!