Oracle Database Multitenant Administration (12c to 19c)

By the end of this lecture, you should be able to:

• Understand the business challenges that the Multitenant option is addressing
• Understand the basic structure of the Oracle Multitenant
• and finally describe the benefits of Oracle Multitenant 

• Describe the difference between the CDB and PDB
• Describe the Multitenant Architecture components
• Describe the difference between the shared undo and the local undo configuration
• Describe the difference between the local users and common users
• Understand the impact of implementing a multitenant configuration

By the end of this lecture, you should be able to:

• Describe the changes introduced in Oracle Multitenant Architecture release 12.2.
• Describe the new components:
  
  • Application root
  • Application
  • Application PDB
• Describe the advantage of using application PDBs.

By the end of this lecture, you should be able to:

• Describe the methods and the options to create an Oracle 12c R2 CDB database

This practice guides you to prepare the environment that you will use in the course practices. The practices in the course were designed using virtual machines. You will build two Linux-based virtual machines. One of them will be the main machine that you will use in most of the course practices and the other machine will be used only in a few practices.

This practice guides through creating two databases in the appliances that you created in the previous practice.

• You will create a CDB in the appliance srv1. 
• You will create a non-CDB database in the appliance srv2. 
• Perform the following configuration settings:
  
  • Enable the automatic database startup and shutdown
  • Getting the Enterprise Manager Database Express working in the VM appliance
  • Run and test the SQL Developer

This is a continue to the previous video.

By the end of this lecture, you should be able to:

• List the tools to create a PDB
• List the options to create a PDB
• List the options to define the location of PDB file locations
• Create a PDB from the seed using the SQL*Plus.

In this practice, you will create PDB databases from the seed using two methods.

• Create a PDB using SQL*Plus
• Create a PDB using the DBCA
• Add the created Pluggable Database net service name in the tnsnames.ora file 
• Perform basic exploring to the created PDBs.

By the end of this lecture, you should be able to:

• Understand the licenses needed to use the Multitenant option
• Describe the pros and cons of using the Multitenant option
• Learn more about the changes in the Multitenant architecture
• Describe the PDB identifiers

By the end of this lecture, you should be able to:

• Switch the current container
• Change the CDB and PDB states
• Save the PDB open states
• Change a PDB initialization parameter
• Drop a PDB

In this practice, you will implement the regular tasks that you may need to do when managing the PDBs. The target is to explore and get familiar with the CDB architecture.

• Various ways of changing the states of the CDB and the PDBs.
• Modify the PDB restart states.
• Modify a parameter in a PDB
• Change the Global Database Name of a PDB 
• Explore the CDB tablespaces and datafiles

This is to continue the previous video.

• Create a new PDB by cloning from a local PDB
• Create a new PDB by cloning from a remote PDB

In this practice you will perform the following:

• Create a PDB by cloning a local PDB
• Create a PDB by cloning a remote PDB

By the end of this lecture, you should be able to:

• Create a PDB by plugging in an unplugged PDB
• Create a PDB by cloning a non-CDB
• Create a PDB using DBMS_PDB on a non-CDB

In this practice you will perform the following:

• Create a PDB by plugging in an unplugged PDB using xml file.
• Create a PDB by plugging in an unplugged PDB using the archived pdb file.

In this practice you will perform the following:

• Create a new PDB by cloning from non-CDB
• Create a new PDB using the DBMS_PDB package on a non-CDB database.

By the end of this lecture, you should be able to:

• Relocate a PDB
• Create a proxy PDB
• Create a refreshable PDB

In this practice you will relocate a PDB from a CDB to another CDB.

In this practice you will create a proxy PDB. You will then perform basic testing on it.

In this practice you will create a refreshable PDB and perform basic testing on it.

By the end of this lecture, you should be able to:

• Manage services in a multitenant container
• Dedicate a Listener to a PDB

By the end of this lecture, you should be able to:

• Describe the difference between Local and Common Users
• Create local and common users
• Describe the difference between common and local grants
• Enable Common Users to Query Data in Specific PDBs
• Describe the difference between common and local roles

In this practice you will examine the principles that govern managing the common and local users in CDB and PDBs.

• How to manage common users
• How to manage local users
• How to manage common and local roles
• Granting privileges as common or local
• Enabling common users to view information about specific PDBs

This is to continue the previous practice.

By the end of this lecture, you should be able to:

• Describe when you should use Lockdown profiles
• How to use PDB lockdown profiles
• How to configure an OS user for a PDB

In this practice you will use the PDB lockdown profile to:

• Disable a database option in a PDB
• Force a policy on using the ALTER SYSTEM statement in a PDB

By the end of this lecture, you should be able to:

• Understand when to use the SYSBACKUP privilege
• Use RMAN to manage CDB and PDB backup and recovery

In this practice you will use RMAN to do the following:

• Take backup of the whole CDB
• Take backup of the whole PDB
• Take partial backup of a PDB
• Implement recovery procedure form SYSTEM datafile loss
• Implement recovery procedure form non-SYSTEM datafile loss
• Use the Data Recovery Advisor commands

This is to continue the previous lecture.

By the end of this lecture, you should be able to:

• Perform PITR in CDBs and PDBs
• Perform Flashback database on CDBs and PDBs

In this practice you will perform the following:

• Point-in-time Recovery (PITR) in a Pluggable Database
• PITR on a Tablespace in a PDB
• Flashback at the CDB level
• Flashback at the PDB level

By the end of this lecture, you should be able to:

• Describe the difference between using the Resource Manager in a CDB container and a non-CDB database.
• Use the Resource Manager to manage allocating the resources to the PDBs

This is to continue the previous lecture.

In this practice, you will create two CDB Resource Manager plans and associated directives to limit the CPU time used by two PDBs.

By the end of this lecture, you should be able to:

• Query from a table in multiple containers
• Use the CONTAINERS clause with DML statements
• Specify the CONTAINERS DEFAULT TARGET
• Use Data Pump utility in a multitenant container
• Apply audit policies in a multitenant container

In this practice, you will perform the following:

• Query the data owned by common users in multiple PDBs.
• Change the data owned by common users in multiple PDBs.
• Specify the Default Container target and test it.
• Apply an auditing policy in PDB1.

In this practice, you will perform the following:

• Export the data from a non-CDB database and import it into a PDB.
• Export the data from a PDB and import it into another PDB within the same CDB.