25,000+ Courses Nationwide
0345 4506120

Oracle Essential Multitenant Administration

Prior to 19c, Oracle only allowed a single user-defined pluggable database (without having to license the full multitenant option). Oracle have announced that from 19c onward there can be 3 user-defined PDBs, without having the multitenant option. The non-CDB architecture has been deprecated from 12.1.0.2. From Oracle 20c the non-CDB architecture will be de-supported. An upgrade to 20c will also include a migration to the multitenant architecture. Now is the time for DBAs to move to Oracle 19c multitenant. When the move to the next long term Oracle 20c support release is made, the basic multitenant features will be understood by the DBAs and can be taken advantage of immediately.

This Oracle Essential Multitenant Administration course is designed to give experienced Oracle Database Administrators practical experience creating Container and Pluggable databases, upgrading a non-container database to a Pluggable database and carrying out essential administration tasks in a multitenant environment. Delegates will also gain an appreciation of how the Multitenant features may be implemented at their own sites.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Notes: The focus of this course is on the basic functionality of container and pluggable databases. Delegates who require a more comprehensive understanding of all the Multitenant Architecture functionality should attend the 4 day Oracle Multitenant Administration course. The Oracle Database 12cR2, 18c and 19c New Features for Administrators course covers the general new features that have been introduced in Oracle Database 12cR2, 18c and 19c.

Versions supported 19c, 18c, 12c.

The course aims to provide the delegate with practical experience of carrying out essential tasks in administering and managing container and pluggable databases.

Who will the Course Benefit?

This Oracle Essential Multitenant Administration course is designed for Oracle professionals who need to upgrade their database skills to implement the essential Multitenant Architecture features and functionality in Oracle 19c.

Select specific date to see price, venue and full details.

Learning Objectives

  • Understand Oracle Multitenant licensing
  • Create a container and pluggable database with the DBCA
  • Use different methods to create Pluggable databases
  • Upgrade a non-CDB database to a 19c PDB
  • Configure a CDB and PDBs
  • Manage container and pluggable databases
  • Administer tablespaces and data files in container databases
  • Manage common and local users, roles and privileges at CDB and PDB level
  • Plug and unplug a database with a PDB XML or archive file
  • Backup a Container and Pluggable Databases
  • Restore, recover and flashback at CDB and PDB level

Pre-Requisites

Requirements

Delegates who wish to attend this Oracle Essential Multitenant Administration course should have administration experience of Oracle Database. This knowledge can be gained by attendance on the pre-requisite Oracle Database 19c Administration course. Knowledge of using PL/SQL packages is strongly recommended.

This course is run on a Linux operating system, therefore a good working knowledge of UNIX/Linux is required. This knowledge can be gained by attendance on the pre-requisite Linux Introduction course.

Where Oracle 19c courses are listed in the Pre-requisite Courses section equivalent Oracle 18c or Oracle 12c courses would also suffice.

Pre-Requisite Courses

  • Linux Introduction
  • UNIX Introduction
  • Oracle Database 19c Administration

Course Content

DAY 1   

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: ORACLE DATABASE MULTITENANT ARCHITECTURE

  • Overview of the Oracle Database architecture
  • Change of MTA licencing at 19c
  • An overview of a container Database (CDB)
  • The benefits of Multitenant Architecture
  • The Root container and pluggable database containers
  • The structure of the root Container
  • The structure of a pluggable Database (PDB)
  • CDB_xxx and DBA_xxx Views
  • Multitenant Administrators Guide
  • System requirements and operating system prerequisites
  • Install the Oracle Database 19c software with the OUI
  • The Oracle Inventory
  • Workshop Exercises

Session 2: CREATE A CDB AND PDBs WITH THE DBCA

  • Create a Container and Pluggable databases with the DBCA
  • Create a database using DBCA Silent Mode
  • Create a database using a response file with DBCA Silent Mode
  • Create a demonstration database using the Pre-Install RPM
  • Create a database using a response File with DBCA Silent Mode
  • Create a duplicate database with DBCA Silent Mode
  • Delete a Database with the DBCA Silent Mode
  • Post database creation tasks
  • Workshop Exercises

Session 3: MANAGE A CDB AND PDBs

  • Connect to a CDB as an administrator
  • Connect to a CDB using a service name
  • Connect to a pluggable database
  • Display the current container
  • Switch between containers
  • Startup and shutdown a CDB
  • Open and close a PDB
  • Open and close all PDBs
  • Automatic startup of pluggable databases
  • Preserve or discard the PDB open mode after a CDB restart
  • Change the state of a PDB

Session 4: CDB AND PDB ADMINISTRATION

  • Administer a CDB and PDBs using EM Express and SQL Developer
  • Multitenant data storage overview
  • Create and manage tablespaces in the CDB and PDBs
  • Online rename and relocation of an active datafile
  • Configure instance parameters in a CDB and a PDB
  • The PDB LOGGING and NOLOGGING clauses
  • Manage Undo tablespaces in a PDB
  • Upgrade a PDB from shared undo mode to local undo mode
  • Query temporary undo information
  • Set the default tablespaces in a PDB
  • Query container data objects (CONTAINER_DATA)
  • Configure Unified Auditing
  • Workshop Exercises

Session 5: MANAGE COMMON AND LOCAL USERS, ROLES AND PRIVILEGES

  • Overview of common and local user management
  • Create and manage common users
  • Create and manage local users
  • Create common roles
  • Create local roles
  • Grant roles and privileges to common and local users
  • Use profiles with common and local users
  • Use the PDB CONTAINERS clause with common and local users
  • Use the CONTAINER_DATA attribute of a common user
  • Audit users in a CDB and PDBs
  • Block common users from accessing local data with Oracle Database Vault
  • Workshop Exercises

Session 8: RECOVERY AND FLASHBACK AT PDB LEVEL

  • Local and Shared UNDO mode
  • Enable and disable flashback database
  • Create a restore point at CDB and PDB level
  • Create a clean restore point
  • Flashback a container database
  • Flashback a pluggable database
  • Flashback a PDB in local and shared undo mode
  • Flashback a PDB without influencing a CDB
  • Restrictions on point in time recovery of a pluggable database
  • Workshop Exercises

Notes:

  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

Follow-On Courses

  • Oracle Database 12cR2, 18c and 19c New Features for Administrators
  • Oracle Database 19c DBA Performance Tuning & Management
  • Oracle Database 19c Backup and Recovery with RMAN
  • Oracle Database 19c Install & Upgrade

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best