1 / 27

Dell Shares Tips on Using Oracle Database 12 c Multitenancy in a Private Cloud (CON6331)

Dell Shares Tips on Using Oracle Database 12 c Multitenancy in a Private Cloud (CON6331). Janardhana Korapala Database Admin Consultant. Nirmal Harshah Oracle Support Account Manager. Kurian Abraham Oracle ACS. Agenda. Overview of Current DB Consolidation at Dell

gerd
Download Presentation

Dell Shares Tips on Using Oracle Database 12 c Multitenancy in a Private Cloud (CON6331)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Dell Shares Tips on Using Oracle Database 12cMultitenancy in a Private Cloud(CON6331) Janardhana Korapala Database Admin Consultant Nirmal Harshah Oracle Support Account Manager Kurian Abraham Oracle ACS

  2. Agenda • Overview of Current DB Consolidation at Dell • Current MegaGrid Architecture • Challenges with Current Solution • Proposed Architecture with Private Cloud • Next Generation – MegaGrid • Overview EM Architecture in Dell • Tips for transitioning to Private Cloud • Summary

  3. Overview of Current DB Consolidation at Dell FOCUS ONDatabase-as-a-Service What is Dell’s MegaGrid? • Consolidated Database environment • Reduce costs • Manage Growth • Standardize • Many Oracle Databases sharing infrastructure • Leverage RAC ( Real Application Clusters) • Large clusters on low cost hardware • Do More with Less

  4. Current MegaGrid Architecture • 43 env (16, 8 and 4-node RACs) • M620 Servers • 32G RAM per node • Each cluster hosts ~50 DBs • 11.2 GI 10.2, 11.1 and 11.2 DBs Homes Node1 Node2 Node3 Node4 Node5 Node8 Node6 Node7 PDB PDB PDB PDB PDB PDB PDB PDB DB DB DB DB DB DB DB DB 11.2 GI 11.2 GI 11.2 GI 11.2 GI 11.2 GI 11.2 GI 11.2 GI 11.2 GI OH 10.2 OH 11.1 OH 11.2 OH 10.2 OH 11.1 OH 11.2 OH 10.2 OH 11.1 OH 11.2 OH 10.2 OH 11.1 OH 11.2 OH 10.2 OH 11.1 OH 11.2 OH 10.2 OH 11.1 OH 11.2 OH 10.2 OH 11.1 OH 11.2 OH 10.2 OH 11.1 OH 11.2 ASM Confidential

  5. Challenges with Current Solution • Challenges • Mixed BU’s causes coordination nightmare • Patching and upgrade difficult • Provisioning takes longer • Backup DB individually • DB cloning takes longer time • Resource management difficult Oracle Support Challenges • Large cluster means larger diagnostic files • Leads to extended resolution time • Falling behind on PSU recommendations Confidential

  6. Proposed Architecture with Private Cloud • EM 12c as an Orchestration tool • DB Multitenant option • ACFS filesystem • 7 BUs with 5-node 12c Clusters each • 4 Container DB’s created based on environment • (DEV/SIT/UAT/PERF) • Each container to host ~20-40 PDBs • Increase consolidation Density Confidential

  7. Next Generation - MegaGrid SVC - BU Class 3 no DR Class 2 no DR Class 1 with DR DEV CDB DEV CDB DEV CDB SIT CDB SIT CDB SIT CDB UAT CDB UAT CDB UAT CDB PERF CDB PERF CDB PERF CDB ACFS Confidential

  8. Overview of EM Architecture in DELL

  9. Tips for transitioning to Private Cloud Confidential

  10. Tip 1: Birds of a feather flock together (DB Grouping) Confidential

  11. Tips for transitioning to Private Cloud Confidential

  12. Tip 2: Enable Self-Service Provisioning (Pre-Req’s) • Versions • EM 12c 12.1.0.4.1 • DB 12c Rel 1 • Define Roles and Assign Users • EM_CLOUD_ADMINISTRATOR • EM_SSA_ADMINISTRATOR • EM_SSA_USER • Patches • Patch 19391521 on OMS Home • Patch 19391503 DB Plug-in on OMS and AGENT_HOME • Patch 19051570 Agent Bundle • Plug-ins • Oracle Cloud Application in Self Update • Oracle Virtualization in Self Update • Oracle Consolidation Planning and Chargeback in Self Update • Oracle Database in Self Update • Oracle Storage Management Framework in Self Update • Oracle Cloud Framework in Self Update

  13. Tip 2: Enable Self-Service Provisioning EM12c Setup Cloud Process Flow Confidential

  14. Step 1: Infrastructure Cloud Setup Confidential

  15. Tip 2: Enable Self-Service Provisioning EM12c Setup Cloud Process Flow Confidential

  16. Step 2: Define PaaS Zone Confidential

  17. Tip 2: Enable Self-Service Provisioning EM12c Setup Cloud Process Flow Confidential

  18. Step 3: Create Database Pool Confidential

  19. Tip 2: Enable Self-Service Provisioning EM12c Setup Cloud Process Flow Confidential

  20. Tip 2: Enable Self-Service Provisioning EM12c Setup Cloud Process Flow Confidential

  21. Step 5: Define Service Template Confidential

  22. Tips for transitioning to Private Cloud Confidential

  23. Tip 3: Use Policy Based Architecture Class 1 Server Pool Class 3 Server Pool Class 2 Server Pool Min 2, Max 3, Imp 30 Min 1, Max 2, Imp 10 Min 2, Max 2, Imp 20 ACFS Confidential

  24. Tips for transitioning to Private Cloud Confidential

  25. Summary • Self Service • End-users can provision, monitor & manage for greater agility • Portability (via pluggability) • Applications run unchanged • Reduce CapEx • Shared memory and background processes • More applications per server • Reduce OpEx and Increased Agility • Common operations performed at CDB level • Manage many as one • upgrade, • Backup • Patching • High Density Database Consolidation • Overcome challenges with current solution • Increased Server Utilization • Improve overall Customer Experience

  26. Thank you Nirmal Harshah Oracle Support Account Manager Kurian Abraham Oracle ACS Janardhana Korapala Database Admin Consultant

More Related