Oracle Database: Managing Multitenant Architecture
Duration: 2 Days

John Watson

 4.8/5 (17)

This hands-on course covers all aspects of the multitenant architecture, providing detailed information on the components of a multitenant container database and its regular pluggable databases. You learn why and how to create and manage a multitenant container database and its regular pluggable databases. You practice creating, cloning, and plugging in pluggable databases, and converting from non-CDB to the multitenant environment.You learn how to create common and local users; manage encryption, security and audit; monitor and tune performance; perform backup and recovery operations with RMAN. Application and proxy pluggable databases are described but not covered in detail.

An additional workshop (optional, depending on time, interest, and pre-requisite knowledge) is included on configuring Data Guard in a Multitenant environment.

The current release of the database is used for exercises and demonstrations, and the content back-ported as necessary for previous releases. 

 

  • Call 1-401-783-6172 for Group or Alumni Discounts.
    If you are a student of an accredited academic institution call us for a 25% discount.

    • No Events Scheduled at this time. Call +1-401-783-6172 or email us to schedule this class.
    Multitenant architecture
    • Investigate the multitenant architecture
    • Describe the container types: root, seed, pluggable
    • Understand how Oracle Net establishes sessions
    • Query the views that describe the environment
    • Describe some features relevant to large deployments
    Set up a Multitenant environment
    • Create a container database
    • Create pluggable containers
    • Convert a non-CDB to a pluggable container
    • Relocate, unplug, and drop containers
    • Hot clones of PDBs and non-CDBs
    • Upgrade a CDB
    Multitenant administration
    • Startup and shutdown a CDB
    • Open and close pluggable containers
    • Tablespace management
    • Create local and common objects
    • Understand use of roles and privileges
    • Set instance parameters
    Backup and recovery
    • Backup the CDB and PDBs
    • Complete and incomplete restore and recovery
    • Database flashback
    • Data Guard in a Multitenant environment
    Performance
    • Resource management
    • Memory and IO limits
    • Use of the Resource Manager
    • Monitoring
    • The AWR and Statspack
    Security issues
    • Audit
    • Encryption
    • Data Vault
    • Some fine-control capabilities
    John Watson
    https://skillbuilders.com/our_team/john-watson/
     4.8/5

    Training content and details were shared ahead of time so enthusiastic students could prepare. The trainer was very well prepared, and provided us a comprehensive picture then dig into details. A mixture of theory and hands on labs were combined together.

    Sometimes I was lost in details. Maybe it would be good to refer back to the overall picture every time, when a very low level topic discussed. However, it is a minor thing, the overall picture is great.

    Voice was sometimes lost (however, other input sources always worked at the same time). Only solution was to exit from training then re-connecting.
    Sandor Toth
    June 25, 2020
     4.8/5

    Very detailed knownledge on each topic. He was able to answer our specific questions or willing to investigate it.

    Maybe less theoritical and more real world examples / excersises.

    Online software worked perfectly.
    krisztian.csorgo@ni.com Csorgo
    June 25, 2020
     5/5

    The exercises are fine and help to understand better the concepts.
    The teacher is very good, he answered all our questions and tried to demonstrate all the doubts with examples.

    I think that the course has all the necessary to be successful.
    Maybe a little more examples in the performance section, but in general the course is very good.

    For me, online software is fine.
    mcambronero
    June 25, 2020
     4.8/5

    John made it interesting and engaging, I particularly liked the practicals.


    All good from that end.
    Robin Neoh
    June 25, 2020
     5/5

    This course was specifically requested for our company and John was very prepared to answer all our questions related to our environments and setup.


    I had no issues with the online software for the course.
    Istvan Kis Nemet
    June 25, 2020
     5/5

    I enjoy the hands-on nature of the course with the labs that are given.

    I feel that John did a great job of moving in the direction that we wanted.

    The online experience is a good one and I can not think of any improvements that would be required.
    Brad Royer
    June 25, 2020
     5/5

    I really liked the content about real world examples, taking a look into performance topics and also having an environment where we were able to try out everything, even DataGuard setup

    I would like to see more guidelines if we are coming from singletenant and moving to multitenant. How to size those databases, official calculators, generic rules when we are setting sizes, how we should group databases etc.

    The software was working fine for me and the presentation is also great.
    Balazs Buka
    June 25, 2020
     5/5

    Specific examples and depth in each topic, went through few real world topics and he gave some great suggestions for our environment.

    More time for the excercises:).

    we never had issue with audio/video. It was just great!
    Sneha Koukuntla
    June 25, 2020
     4.9/5

    This course serves as a good preparation for DBAs making the move into multitenant. This course even provides valuable information for databases moving to 19/20c without the multitenant license (e.g. running maximum 3 PDBs in a CDB)


    Robin Burgess
    June 25, 2020
     4.5/5

    i like the hands on technical part and explanation.

    i was expecting more about 19C performance tuning explanation.
    for example how CBO & stats works to determine how oracle choose plans and some performance tuning hacks

    As of the tool, i\'m satisfied with the software and tool which being used to deliver the training\'s.
    Naveen Narasimalu
    June 25, 2020
     4.9/5

    John let's go in our own direction once we get the concepts down, especially when he knows the people he is teaching. We got a lot of answers on how we would implement this in our complex environment.

    None

    Nope, it worked perfectly.
    Jeremy Schleicher
    May 7, 2020
     5/5

    It\'s always great to be in a class with John. Since it was a small class (only 2 of us from SwRI and John) we could address some very specific topics related to our environment. We were able to drill down to some very specific, advanced issues.

    Can\'t think of anything to improve since it was very much tailored to our environment.

    No issues with the online delivery or presentation. All worked great, audio and video were good at any time.
    Chris Ermlich
    May 7, 2020
     4.7/5



    Barry Monroe
    September 15, 2018
     4.7/5



    Kyle Sheen
    September 15, 2018
     4.4/5

    The Labs

    None

    John Bezin
    September 15, 2018
     4.8/5

    Hands on Exercises


    Nina Jones
    September 15, 2018
     4.7/5

    Real Life Examples


    Encourage more student participation
    Joe Philips
    September 15, 2018

    You May Like

    Copyright © Skillbuilders.com

    Free Online Registration Required

    The tutorial session you want to view requires your registering with us.

    It’s fast and easy, and totally FREE.

    And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!

     

    ×