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

Hello Friends,
Here with one more topic on.
12c Oracle Multitenant Architecture - CDB - PDB Implementation:
=========================================================
Oracle Multitenant: Concepts and Implementation
Multitenant Architecture
Multitenant Implementation
Horizontally Partitioned Data Dictionary
Local and Common Users
Data Dictionary Views
Modifying Initialization Parameters
Plug into Oracle Multitenant
• Multitenant container database
- Administration from CDB
• A CDB can contain one or
many pluggable databases
- Data and code in PDBs
- Applications connect to PDBs
• Simple and fast provisioning,
cloning, plugin, patching and
upgrade
Pluggable Databases
Multitenant Container Database
• Multitenant architecture can currently support up to 252 PDBs
• PDB / non-CDB compatibility guarantee:
You cannot tell, from the viewpoint of a connected client, if you’re using a PDB or a non-CDB
Different Methods of creating a PDB
Clone from PDB$SEED
Clone from another PDB
Clone from a Remote CDB
Convert a non-CDB to PDB
Plug a unplugged PDB
#12c #PDB #CDB #12cArchitecture #MultitenantArchitecture #RAC #exadata #oracle #oracledatabase #oracledba #database #databaseperformanceIssue #databases
Please do follow me and support me on,
Blog: mallik034.blog...
LinkedIn: / mallikarjun-ramadurg-3...
twitter: / mallik034
instagram: / mallik034
UA-cam: / @vismotechnologies
Regards,
Mallikarjun Ramadurg
Mobile: [phone]
WhatsApp: [phone]
Blog: mallik034.blog...
LinkedIn: / mallikarjun-ramadurg-3...
twitter: / mallik034
Instagram: / mallik034
UA-cam: / @vismotechnologies

[@ericksonezekiel4104]

awesome session mallik sir

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

[@murtazarasool6395]

Amazing Learning stuff 👍

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

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

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