Oracle Database: Managing Multitenant Architecture

User Avatar
John Watson
 4.9/5 (23)
$2,100.00

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. 

 

Course Features

  • Lectures 0
  • Quizzes 0
  • Duration 2 Days
  • Skill level All levels
  • Language English
  • Students 0
  • Certificate Yes
  • Assessments Yes

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
author avatar
John Watson

    https://skillbuilders.com/our_team/john-watson/

    Leave A Review

    Please provide as much detail as you can to justify your rating and to help others.




     5/5

    I thought the instructor was well-versed, informative, and presented in an easy-to-follow manner. You can tell he has a lot of experience with both Oracle and teaching.

    Some minor issues existed with the exercises.

    No
    laila.marker@ua.edu
    February 4, 2021
     5/5

    I really loved the amount of time and care that went into preparing the class exercises.

    I really can't think of anything that could add benefit to the class.

    None really.
    Hunter Standridge
    February 4, 2021
     5/5

    John's training style, of course. Apart from that, the course was well-structured, plenty of offline reading to do, and the workshops were especially useful in reinforcing learning acquired over the length of the course.


    No, everything worked extremely well. Will be back for more!
    Jes Challand
    December 17, 2020
     5/5

    John was an excellent trainer, he ensured that we were all caught up and understood the material. He moved at a pace that fit everyone and explained everything thoroughly.


    Xavier Western
    December 17, 2020
     5/5

    John was very knowledgeable and answered questions without hesitation.
    He was able to relieve some of my apprehensions about the multitenant architecture.

    You might add something on the subject of naming conventions for CDBs and PDMs.

    I believe the online software and delivery were both very good.
    Robert Harris
    December 17, 2020
     4.8/5

    DataGuard part


    Yiqun Zhou
    December 17, 2020
     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
    $2,100.00
    Details Price Qty
    06/14/21 - 06/17/21show details +$2,100.00 (USD)  

    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!

     

    ×

    Message modal