Oracle Database Multitenant Administration (12c to 19c)

Obtain the skills to mater Oracle Multitenant Architecture (in releases 12c, 18c, and 19c)

Learn how to build and manage Oracle Multitenant Architecture (including releases 12.1, 12.2, 18c, and 19c)

What you’ll learn

  • Describe the Oracle multitenant architecture.
  • Create multitenant container database.
  • Create a pluggable database using different methods.
  • Create and manage common and local user accounts.
  • Manage PDB lockdown profiles.
  • Perform backup and recovery.
  • Perform PITR and flashback.
  • Use the Resource Manager in a container database.
  • Use Data Pump utility with PDBs.
  • Manage the applications and application containers.
  • Manage the Oracle 18c and 19c Multitenant New Features.

Course Content

  • Introduction –> 1 lecture • 6min.
  • Oracle Database Multitenant Architecture –> 3 lectures • 38min.
  • Create CBD containers and PDB containers –> 8 lectures • 1hr 37min.
  • Basic Oracle Multitenant Database Administration –> 4 lectures • 56min.
  • Creating PDBs, All the Methods –> 9 lectures • 1hr 44min.
  • Managing Connectivity and Services in Oracle Multitenant –> 1 lecture • 8min.
  • Managing Security in Oracle Multitenant Database –> 5 lectures • 1hr.
  • Managing Backup, Recovery, and Flashback Database –> 6 lectures • 1hr 16min.
  • Using Resource Manager in Oracle Multitenant Database –> 3 lectures • 39min.
  • Miscellaneous Topics on Oracle Multitenant Database –> 3 lectures • 53min.
  • Managing Applications and Application Containers –> 5 lectures • 1hr 23min.
  • Introduction to Oracle Database Multitenant New Features in 18c and 19c –> 4 lectures • 31min.
  • Managing CDB Fleet –> 4 lectures • 29min.
  • Managing a PDB Snapshot Carousel –> 7 lectures • 57min.
  • Switching Over a Refreshable Clone PDB –> 2 lectures • 20min.
  • PDB Cloning and Relocation using DBCA –> 6 lectures • 38min.
  • Download Course Slides and Practices –> 1 lecture • 1min.

Auto Draft

Requirements

Learn how to build and manage Oracle Multitenant Architecture (including releases 12.1, 12.2, 18c, and 19c)

Not only the course will demonstrate the concepts for you, you will also gain practical experience on implementing the them.

  • Describe the Oracle multitenant architecture
  • Create multitenant container database
  • Create a pluggable database using different methods:
    • Creating a PDB from the seed
    • Cloning PDBs from local or remote PDBs including the refreshable PDBs
    • Plugging in an Unplugged PDB
    • Relocating a PDB
    • Creating a PDB from a non-CDB database
    • Creating Proxy PDBs
  • Manage the security in a multitenant container:
    • Create and manage common and local user accounts and roles
    • Manage PDB lockdown profiles
  • Perform backup and recovery, PITR and flashback database in a multitenant container
  • Use the Resource Manager in a multitenant container
  • Use Data Pump utility with PDBs
  • Manage the applications, application containers, application PDBs, and common objects
  • Manage Oracle database 18c and 19c multitenant new features:
    • Manage CDB fleet
    • Managing a PDB Snapshot Carousel
    • Switching Over a Refreshable Clone PDB
    • PDB Cloning and Relocation using DBCA

Content and Overview 

Information presented in this course, will get the Oracle Database Administrators ready for the next generation of Oracle database. Through this course of 72 lectures and more than 13 hours of video-based sessions, you’ll learn all of the managing Oracle Multitenant Architecture. After every concepts lecture, you will implement a hands-on practical exercise. To guide you on implementing the practices, the practice lectures are supported by video-based demonstrations and the downloadable guide documents.

Starting with introducing the Oracle Multitenant Architecture, this course will take you all the away from creating an Oracle 12c multitenant CDB container on a Linux platform, creating new PDBs using all the possible methods of creating them, managing the security in a multitenant container,  implementing the backup and recovery, flashback database, PITR, using the Resource Manager, applying the auditing policies, using the data pump utility, up to managing the applications, application containers, and common objects. The course will cover the multitenant capabilities in the releases: 12.1, 12.2, 18c, and 19c.

This is an opportunity for the students to gain practical experience on this new Oracle cutting-edge technology, and get themselves ready for managing Oracle databases on the cloud.

Upon completing this course, you will be able to build up an Oracle multitenant container and have the knowledge and experience to manage it.

Join the author in this learning journey to experience this amazing technology!