Oracle CDBs and PDBs Explained (With Connections)

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

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

[@vinitkumarsingh8444]

Thank you for the video how can we connect you?

[@DatabaseStar]

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

[@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.

[@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.

[@miguelangelllanten8289]

How can I know the password of the user “SYS”?

[@TheCrimsonPain]

It is defined when you install the database, if I'm not wrong, both SYS and SYSTEM users use this password

[@DatabaseStar]

That’s right. You set this when you install the database. I don’t know if there’s a way to reset it if you don’t know it.

[@The_real_LoneWolf]

Great! That helps a lot. Thanks men!

[@DatabaseStar]

Glad it helped!

[@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?

[@DineshReddy-b4e]

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

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