Oracle Database Managing Multitenant Architecture

In this demo, you are going to access Oracle Enterprise Manager Cloud Control 13c and basic Summary of your home page. We will add the cdb12 CDB as a monitored target.

In this demo, you are going to verify the existence of the CREDORCL credential used for any connection as SYS user sharable in the multitenant container database instance ORCL.

In this demo, we are going to show some important topic:

Find HTTPS port number on which ORCL listens to Oracle Enterprise Manager Database Express (EM Express).

How to Enable the global port for your ORCL CDB so that we can start EM Express for a PDB.

Start EM Express for the ORCL CDB.

Start EM Express for PDB1.

Explore the differences in the EM Express interface when connected to a CDB versus a PDB.

In this demo, we will create a new CDB, CDB18, with DBCA in silent mode. The CDB dedicated for test purposes.

In this demo, we will create a pluggable database (PDB) from the CDB seed in CDB18 by using SQL*Plus.

In this Demo, you install the toys_app application in the toys_root application container

for both robots and dolls application PDBs so that both application PDBs can benefit from

common entities such as application common users and schemas, application common roles,

granted privileges, and application shared objects.

In this Demo, you will upgrade the TOYS_APP application to create the

toys_owner.new_tab table shared by both application PDBs.

In this demo, you will use the dynamic container maps. In Oracle Database 12c, a container

map enables a session connected to an application root to issue SQL statements that are

routed to the appropriate PDB, depending on the value of a predicate used in the SQL

statement. Container maps enable the partitioning of data at the application PDB level when the

data is not physically partitioned at the table level. In Oracle Database 18c, a container map can

be dynamically updated when new PDBs are created or dropped.

In this practice, you shut down ORCL and start up ORCL.

In this practice, you will open and close application PDBs.

In this practice, you will change the open mode of PDBs for specific operations.

In this practice, you will discover the impact of instance parameter changes on PDBs.

In this practice, you will manage possible conflicts with names of existing services in CDBs.

In this practice, you manage UNDO tablespaces in PDBs.

In this practice, you will learn to manage the common and local users in CDB and PDBs, regular and application PDBs, and the common and local privileges and roles granted in CDB and PDBs, regular and application PDBs.

In this practice, you will manage local and common objects in application PDBs.

In this practice, you will manage the CONTAINER_DATA attributes of common users to enable common users to view information about PDB objects in specific PDBs.

In this practice, you will observe how lockdown profiles in the CDB root, in application roots, and application PDBs behave regarding inheritance. You will create and alter lockdown profiles and set the profiles at different PDB levels in a CDB. You will also discover the behavior of static and dynamic lockdown profiles created from base lockdown profiles.

Duplicate CDB from on premises to Cloud.

Duplicate PDB from CDB