Oracle CDBs and PDBs Explained (With Connections)
ฝัง
- เผยแพร่เมื่อ 1 มิ.ย. 2024
- Oracle has a concept of "container databases" (CDB) and "pluggable databases" (PDB). This is unlike any of the other vendors, and it can be a little confusing if you're new to Oracle.
If you're having issues connecting to a database, or strange errors when running Create User commands or other commands, it could be because you are connected to the wrong database.
In this video, you'll learn what a container and pluggable database is, how to connect to each of them, and how to resolve a common error that happens when creating users.
⏱ TIMESTAMPS:
00:00 - Introduction
00:51 - What is a Container Database?
01:10 - What is a Pluggable Database?
03:18 - Connecting to a PDB
05:22 - Connecting to a CDB
07:12 - Create user error and solution
🔗 VIDEO LINKS:
Check out my guide to Oracle Container Databases and Pluggable Databases here: www.databasestar.com/oracle-pdb/
🔗 RESOURCES:
📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🧭 SQL Roadmap from basics to advanced: www.databasestar.com/sql-road...
✍️ Learn how to design a database: databasestar.mykajabi.com/edd
📧 Contact me here: www.databasestar.com/contact/
📝 Database Design Exercises: bbrumm.gumroad.com/l/hqsxi
📝 SQL Practice Questions: bbrumm.gumroad.com/l/ulekqk
📝 SQL Performance Quick Guide: bbrumm.gumroad.com/l/fcvny
📝 Ultimate SQL How-To Guide: bbrumm.gumroad.com/l/oqggau - วิทยาศาสตร์และเทคโนโลยี
Valid information is useful in a hard time to understand between container and pluggable databases.
Yeah it's pretty confusing, I don't see the value that CDBs and PDBs add for developers.
Really well done video. Thanks!
Glad you liked it!
Your videos are amazing! Really helpful. Pls do continue them. Been working with oracle sql at work and I’ve been following your tutorials for help. Thanks!
Thanks! Glad it was helpful and glad you like the videos.
Great! That helps a lot. Thanks men!
Glad it helped!
Hi Database Star, you make understanding concepts so easy to a newbie. Thanks a lot and keep posting videos.
Thanks, glad you found it helpful!
Thank you , We hope you continue
Thanks! I sure will
Your course is awesome. I'm planning to buy your course. But, it's mostly based on sqlserver and oracle. I've been using Postgres in my work. Do you have any plan for postgres for your course?
Thanks! You’re right, more of my courses are focused on Oracle and SQL Server as that’s what I originally focused on. But my newer courses and all courses I create in the future will also be focused MySQL and Postgres.
There are some that are database specific such as oracle plsql. However I plan on creating Postgres equivalent courses such as stored procedures and more.
@@DatabaseStar awesome
Thank you!
You're welcome!
Thank you for the video how can we connect you?
Thanks! You can email me from my website, databasestar.com
Please , How connect for .PDB file?
I'm not sure what a .pdb file is or how it can be used with Oracle unfortunately.
Hello Database Star, I installed Oracle 21c and created a connection to my sql developer and I created a user, But now when i am trying to create a connection with the user I just created I a getting an error ORA-01017 invalid username or password; logon denied, Please help me Database star 🙏🙏🙏🙏🙏🙏🙏
Oh that's strange. Oracle connections can be tricky to get right. Are you connecting to the right SID or Service Name? Did you create the user on the correct database?
@@DatabaseStar I made a connection to my sql developer with my oracle 21c credentials as systemdba. In that connection I went to other users and created a user and trying to make a connection. My SID is taken as “xe”
@@user-xx5xk1wv1z I'm hit by the same issue. Did you find a solution for it?