Oracle CDBs and PDBs Explained (With Connections)

[@DatabaseStar]

Want to easily remember the SQL commands for your database? Get my free SQL Cheat Sheets here: databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?

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

[@adityaprasad465]

Really well done video. Thanks!

[@DatabaseStar]

Glad you liked it!

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

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

[@michaellebediev6715]

you and your channel are awesome) so happy i've found it)

[@DatabaseStar]

Thanks!

[@Munder_AL-Jbaly]

Thank you , We hope you continue

[@DatabaseStar]

Thanks! I sure will

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

[@ibrahimsherif6648]

Very useful, thanks

[@DatabaseStar]

Glad it helped

[@clairelee9719]

Why when I run the sept 6, the rerult will be an error as below, and how to fix it ? Thanks in advance! Cause: An attempt was made to open a pluggable database that was already opened. *Action: Check the OPEN_MODE column in V$PDBS view. --1 Show con_name; --2 Select name, con_id from v$pdbs; --3 alter session set container=FREEpdb1 --4 Show con_name; --5 Select name, open_mode from v$pdbs; --6 alter PLUGGABLE DATABASE open;

[@DatabaseStar]

Perhaps the database is already open, so you don't need to re-open it?

[@guilhermeakyl]

Hi Ben! Please, I'm still don't understand it, and It still have been pretty though to me know a meaningful of these all, e.g :"SID". Could you please advise me where can I find out more information to dig into it, in order to use know how situation I've must be? Thanks for the video BTW! Greetings from Brazil!

[@DatabaseStar]

Thanks for the comment! As mentioned in the other comment, I'm not sure where the terms come from (perhaps from older versions of Oracle). There may be some docs on the Oracle website that explain more.

[@guilhermeakyl]

@DatabaseStar thanks, Ben!

[@oracle_professor]

Thank you!

[@DatabaseStar]

You're welcome!

[@The_real_LoneWolf]

Great! That helps a lot. Thanks men!

[@DatabaseStar]

Glad it helped!

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

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

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

[@Roy-Shill0303]

Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=XCTtIq4pQ0mKFxS8hh+1xw==) THIS IS THE ERROR WHEN I TRY CONNECTING TO THE DATABASE WITH EXACTLY SAME PARAMETER

[@DatabaseStar]

I've gotten the same error in the past, but haven't documented how to solve it yet.

[@DatabaseStar]

I've gotten the same error in the past, but haven't documented how to solve it yet.