Oracle Multitenant Architecture and Database Administration

A warm welcome to the Oracle Multitenant Architecture and Database Administration course by Uplatz.

Post Oracle 12c, Oracle came up with new architecture called Multitenant Architecture.

In previous versions of Oracle database versions, there was a major problem - if the user starts a new instance there are particular background processes for each instance and each of these process wasted a lot of memory and resources thus affecting the system performance badly. Hence, Oracle came up with a new idea to connect different databases into one database technique. That idea is called “Multitenant Architecture.”

That one main database is called CDB (Container Database) and other databases which are used to connect the main database are called PDB (Pluggable Database). A pluggable database is fully compatible with a non-CDB. In fact, Oracle has something called the PDB/non-CDB compatibility guarantee, which states that anything you would do in a non-CDB would also work in a PDB. This compatibility guarantee is important when it comes to certifying things like third-party vendor products to work in a multitenant architecture.

How to create a multitenant database environment in Oracle 12c

When creating a database, you must designate it as a CDB or non-CDB for it to be able to support the multitenant architecture. The next set of examples walks you through the steps to create a container database with the DBCA. There is only one step that differentiates a CDB from a non-CDB when using the DBCA.

The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. The Oracle Multitenant Database Architecture is designed to host multiple “PLUGGABLE DATABASE” PDB databases within a single CDB “CONTAINER DATABASE” container instance. The architecture of the CDB instance maintains more PDBs within it, using the same set of processes and the same SGA (System Global Area).

Key Concepts of Oracle Multitenant Architecture

1. Container Database (CDB) – The main database that contains multiple Pluggable Databases (PDBs).

2. Pluggable Database (PDB) – A self-contained database that can be plugged into or unplugged from a CDB.

3. Root Container (CDB$ROOT) – The central container that holds common metadata, users, and shared components.

4. Seed PDB (PDB$SEED) – A template used for creating new PDBs.

5. Application Containers – Used for managing multiple PDBs as a single unit.

Advantages of Oracle Multitenant

• Efficient Consolidation – Multiple PDBs share the same database instance, reducing resource overhead.

• Simplified Management – DBA tasks like patching, backup, and recovery are performed at the CDB level.

• Rapid Provisioning – New databases can be created quickly by cloning PDBs.

• Resource Management – CPU, memory, and storage can be allocated to individual PDBs.

• High Availability – Works with Oracle Data Guard and RAC for disaster recovery and performance.

The Multitenant architecture facilitates the following:

• High consolidation density: Many databases can share memory and background processes.

• Provisioning: A database can be unplugged from one environment and plugged into another or cloned with SQL commands in just a few seconds. They can even be plugged across operating systems and chipsets.

• Patching and upgrades: You can patch a database simply by unplugging from one unpatched container and plugging it into another patched container.

• Manage many databases concurrently: You can do tasks such as backing up and patching on the primary container database instead of the individual pluggable databases.

• Resource management: The Oracle Resource Manager feature can work at the pluggable database level for you to manage resource competition among the databases in your environment.

This Oracle Multitenant Architecture and Database Administration course by Uplatz will help you learn the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs). You will understand the process of installing Oracle Database 19c followed by the creation of CDB and non-CDB databases. Oracle Database 19c Multitenant Architecture course explores the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs). In this Oracle Multitenant Database Administration course, you will be creating a PDB through different methods, managing users, understanding the back-up and recovery processes in CDB and PDBs. You will also gain knowledge of the various utilities used for e.g. resource manager, data pump utility, and so on. Overall, you'll become a professional Oracle Multitenant DBA with end-to-end skills on managing applications and application containers.

Oracle Multitenant Architecture and Database Administration - Course Curriculum

1. Overview of Oracle Multitenant DBA

2. Installing Oracle Linux 7.8 in Oracle Virtual Box

3. Installing Oracle Database 19c Software

4. Creating CDB and non-CDB databases

5. Creating PDBs from the Seed

6. Performing Basic CDB Administration Tasks

7. Creating a PDB by Cloning from Local and Remote PDBs

8. Creating PDB by Plugging in an Unplugged PDB

9. Creating a PDB from non-CDB

10. Creating a PDB by Relocating a PDB

11. Managing Common and Local Users

12. Backup and Recovery in CDB and PDBs

13. Flashback and Point-in-time Recovery

14. Using Resource Manager with CDB and PDBs

15. Using Data Pump Utility with PDBs

16. Managing Applications and Application Containers

17. Installation Of Oracle Linux 8 on Oracle VM

18. Introduction to Oracle 21c DBA

19. Oracle 21c Architecture

20. Practice 1 - Creating a CDB

21. Practice 2 - Creating PDBs from the Seed

22. Practice 3 - Performing Basic CDB Administration Tasks

23. Practice 4 - Managing Common and Local Users

24. Practice 5 - Backup and Recovery in CDB and PDBs

25. Practice 6 - Flashback and Point-in-time Recovery