12c Architecture - 12c Multitenant Architecture - CDB & PDB Implementation - 12c Container Database

[@ericksonezekiel4104]

awesome session mallik sir

[@murtazarasool6395]

Amazing Learning stuff 👍

[@SureshKumar-no3eo]

i want to give u 10000000 likes for you super bro. i like your videos. and u will get more like also..

[@VismoTechnologies]

Thank you bro.🍷🍷

[@imraangrace3830]

I was impressed in the first 10 minutes. This is a great job and well explained.

[@arunsarangi6210]

So nicely explained in 10 Min

[@ma466]

Very nice video.Thanks.

[@shanshaikh1365]

Nicely explained sir.

[@VismoTechnologies]

Thanks

[@bharathkumar-ds8cd]

Good session sir, please make more videos pdb_plugin_voilations, common user, local user, none can to pdb migrations and pdb hot cloning methods also. Your every session is unique.

[@VismoTechnologies]

Yeah I will try to cover come complete administration guide on PDB management.

[@anujsharma9952]

Hi malik thank you so much for explanation its clean and clear. We want more videos like this. On this video one suggestion from my end, when you are explaining that use cml files inorder to unplug/plug or convert non cdb to cdb. Please also explain that what that xml files carrying inside. I believe this kind of details is really helpful for all even senior dbas

[@VismoTechnologies]

Noted. Sure I will do it more and more sessions with in dept concepts.

[@ashokreddythumma3801]

Thanks for the good session. Could you please share the presentation document

[@sureshparekh6847]

Hi, very nice explanation. I have question, in demo you are showing two windows, purple and green with two different CDB, testcdb and devcdb.. my question is can we create two CDB on same machine and same oracle install? I guess we can, as long as different SID… How is your setup?

[@SANDATA764]

Please provide the related documents. A BIG thanks to you bro

[@VismoTechnologies]

Please message me in whatsapp or gmail. I can share the documents no big deal in that 😀😀

[@SANDATA764]

@@VismoTechnologies please provide your WhatsApp number

[@VismoTechnologies]

WhatsApp [phone]

[@RaviManam]

Please do session on RMAN scenarios in multitenant architecture

[@VismoTechnologies]

Sure I will do it.

[@RaviManam]

What are Pre-requisites before unplug the PDB, do we need to unplug the pdb when it in mount state or close

[@VismoTechnologies]

You have to close PDB and then unplug it so that data will be consistent and this is the best practice. Even you can unplug your database in mount state, their might be chances of data curuption which is not recommend.

[@trsafi]

for connecting PDB user directly .. should we add entry in TNS? I tried to connect as you said not working for me .. like ...sqlplus demo/demo@pdbname

[@VismoTechnologies]

Connect to PDB and check for service name 1) Connect to PDB 2) Show parameter service, If no Service found add one service using alter system set service_name 3) Add that service name in TNS names it should work.

[@trsafi]

@@VismoTechnologies 1. After connecting PDB, Show parameter service..showing CDB service name not PDB 2. But SELECT SYS_CONTEXT('USERENV', 'CON_ID') AS con_id, SYS_CONTEXT('USERENV', 'SERVICE_NAME') AS service_name FROM dual; Above query showing PDB service name...once added to TNS its working.

[@mayanktripathi4u]

This may be a silly question, however wanted to clear it. When we install Oracle, is CDB or Container already been created? Also is it possible to create our own CDB?

[@VismoTechnologies]

while creating CDB --- You can create CDB as non-container/ non-multitenant --- You can create CDB as container/multitenant Point here is >>> if you create CDB as container/multitenant then you can create PDB on >>> if you create CDB as non-container/non-multitenant then you can create PDB on it >>> once you create CDB as non-container/non-multitennt then you can not convert it back to container/multitenant

[@RaviManam]

what about archivelogs in PDBS, it will be common for cdb and pdb or different If it is same for both I want to recover my pdb, how can we do Please do one session on that

[@VismoTechnologies]

As I said, PDB itself does not have any redo logs or controlfiles or any SGA or any background process. Its not possible to have archivelog mode at PDB level. It is going to be at CDB level only. Sure I will take one session on restore and recovery of PDB