Oracle CDBs and PDBs Explained (With Connections)

📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql...
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/

[@TriveniPydi]

Valid information is useful in a hard time to understand between container and pluggable databases.

[@DatabaseStar]

Yeah it's pretty confusing, I don't see the value that CDBs and PDBs add for developers.

[@-.-smile]

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!

[@DatabaseStar]

Thanks! Glad it was helpful and glad you like the videos.

[@GS-hc5zp]

Hi Database Star, you make understanding concepts so easy to a newbie. Thanks a lot and keep posting videos.

[@DatabaseStar]

Thanks, glad you found it helpful!

[@adityaprasad465]

Really well done video. Thanks!

[@DatabaseStar]

Glad you liked it!

[@Munder_AL-Jbaly]

Thank you , We hope you continue

[@DatabaseStar]

Thanks! I sure will

[@The_real_LoneWolf]

Great! That helps a lot. Thanks men!

[@DatabaseStar]

Glad it helped!

[@oracle_professor]

Thank you!

[@DatabaseStar]

You're welcome!

[@victorray9369]

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?

[@DatabaseStar]

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.

[@DatabaseStar]

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.

[@victorray9369]

@@DatabaseStar awesome

[@ambattha]

Hi, How can we create a new user which is not a sysdba and then login using that

[@DatabaseStar]

I've got a video on creating a user on my channel, but I can create one in the future based on this PDB and CDB concept. I believe you log into the PDB as a SYS yser and create the new user.

[@vinitkumarsingh8444]

Thank you for the video how can we connect you?

[@DatabaseStar]

Thanks! You can email me from my website, databasestar.com

[@PlaceTickets]

Please , How connect for .PDB file?

[@DatabaseStar]

I'm not sure what a .pdb file is or how it can be used with Oracle unfortunately.

[@dineshreddy9048]

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 🙏🙏🙏🙏🙏🙏🙏

[@DatabaseStar]

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?

[@user-xx5xk1wv1z]

@@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”

[@Blazs120gl]

@@user-xx5xk1wv1z I'm hit by the same issue. Did you find a solution for it?