Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Oracle Database 19c: Multitenant Architecture

via LinkedIn Learning

Go to class Write review

Details

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Duration & workload

1 hour 35 minutes
Sessions

On-Demand
Level

Intermediate

Found in

Udacity

Master AI & Data—50% Off Udacity (Code CC50)

CodeSignal

JavaScript Programming for Beginners

Overview

Coursera Flash Sale

40% Off Coursera Plus for 3 Months!

This course teaches database administrators to create and effectively utilize resources within multitenant databases.

Syllabus

Introduction

Multitenant
What you should know

1. Multitenant Architecture

Components of a multitenant environment
CDB root
PDB seed
Connecting to CDBs and PDBs
Multitenant data dictionary views
Challenge: Connect to the CDB and PDB
Solution: Connect to the CDB and PDB

2. Create and Clone PDBs and Users

Creating a container database
Creating a PDB from the seed database
Copying a PDB
Dropping a PDB
Creating and managing local and common users
Moving a PDB
Upgrading a PDB to a new database version
Challenge: Move a PDB to a new container with SQL Developer
Solution: Move a PDB to a new container with SQL Developer

3. Application PDBs

Creating application containers and application PDBs
Installing an application in an application PDB
Challenge: Upgrade an application PDB
Solution: Upgrade an application PDB

4. Multitenant Backup and Recovery

Back up a CDB and PDB with RMAN
Recover a CDB or one of the PDBs
Challenge: Recover a PDB tablespace
Solution: Recover a PDB tablespace
Refreshable PDB Clones

Conclusion

Next steps

Taught by

Bob Bryla

Reviews

4.7 rating at LinkedIn Learning based on 186 ratings

Start your review of Oracle Database 19c: Multitenant Architecture