Webinar-03 - Multitenant Architecture - CDB & PDB Implementation - 12c & 19c
Vložit
- čas přidán 4. 02. 2021
- 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
show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB READ WRITE NO
SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;
NAME CON_ID DBID CON_UID GUID
-------- ---------- ---------- ---------- --------------------------------
CDB$ROOT 1 1591536784 1 86B637B62FDF7A65E053F706E80A27CA
PDB$SEED 2 3680827711 3680827711 BA9BE798A5647436E053E524230AE0BD
PDB 3 2635452016 2635452016 BA9C19DC75CF1DC2E053E524230A9483
SELECT PDB_ID, PDB_NAME, STATUS FROM DBA_PDBS ORDER BY PDB_ID;
PDB_ID PDB_NAME STATUS
---------- --------------- ----------
2 PDB$SEED NORMAL
3 PDB NORMAL
#CDB #PDB #MultitenantArchitecture #RACArchitecture #SCAN #OCR #Exadata #RAC #ASM #Oracle
Please do follow me and support me on,
LinkedIn: / mallik034
CZcams: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: malluramadurg@gmail.com
LinkedIn: / mallik034
CZcams: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg - Věda a technologie
Excellent !!
Explained Very well, very useful, thank you 🙏🙏
Mallikarjun, Videos are excellent. Keep sharing the knowledge which helps you and others to grow.
Thank you so much
Nice session
What exactly that noncdb_to_pdb.sql script will do ? It will convert non cdb to pdb but inside what it will do I mean any specific log to review.
Rebuilding metadata and create cdb and pdb dynamic performance views nad data dictionary
Hi Malik, what about the alert log & archive log of all PDBs ? is common for all or individual ? [watched till 15:40]
time 46:50 - after conversion, does it create empty/db skeleton ? do we need to import the data from non-cdb ? Does this xml file will be large in size ? what does it contains ?
time 19:44 --- while plugging and unplugging of PDB, does source & target CDB requires to on same version ?
time : 17:50 --- if db is on OCI cloud [ where multi-tenant arch is compulsory] , how we can make sure that, none of common user access to our database [PDB] ?
time 34:45 - Which users does have access to CDB level ?
Hi Malik do you provide traininings ?
No not at the moment
Can you please share this ppt for everyone's reference. that would be really helpful.
Is it possbile to install a RAC 19c (ASM) database with 2 PDBs but each PDB with diffrent +DATA disk group? Or should I use 2 CDB?
Its possible. any combination you can install
your pronunciation is bit confusing. please don't be in a rush while explaining. please be clear with your words. Or else you are explaining very well.