13 Lessons on How to Manage Oracle 12c Multi Tenant Database

ORACLE 12c

13 Lessons on How to Manage Oracle 12c Multi Tenant Database

Oracle 12c Pluggable Database

Oracle has modified its architecture by introducing the concept of containers. The main component of this architecture is the CDB container. It is a container which owns the memory structure, the background processes and SYSTEM, SYSAUX tablespaces which are all shareable with other databases which are “plugged” into it.

The SGA for the CDB consists of the traditional memory components such as the Buffer cache and Shared pool, DBWR and LGWR processes, which access the SYSTEM, SYAUX and UNDO tablespaces.

These ‘plugged-in’ databases are also called PDB databases. While the CDB container stores most of the metadata information, the user data is stored in the user tablespace which is part of the PDB database.

This ensures that the system metadata is totally segregated and that the individual tablespaces in the PDB is only visible within the PDB that the tablespace is a part of.

Read more details in the articles below.

Benefits of Multitenant Databases in Oracle 12c
With Oracle 12c Oracle has introduced the new multitenant architecture. The benefits of Multitenant databases in Oracle 12c using the new Multi tenant Architecture include solving the many problems and reducing resources associated with the large infrastructure deployments.

Managing Oracle 12c Database: Container and Plugable Databases
Introduction to the most talked about Oracle 12c database feature. Learn more about the concept of Containers, Pluggable databases. Cloning etc.

Managing Oracle 12c CDB and PDB – Getting started – Part 1
Managing Oracle 12c CDB and PDB is different in many ways. That’s mainly because of architectural changes introduced 12c. Learn the new features and how to manage the CDB and PDB databases.

Managing Oracle 12c CDB’s and PDB’s – Plugging and Unpluggging PDB’s – Part 2
One of the main features of the Oracle Database 12c is the portable nature of the pluggable databases (PDBs). You can easily unplug a PDB from a CDB and then plug it into a different Container database (CDB). This ease of Plugging in and Unplugging PDBs makes the 12c database truly Cloud ready. If you have just downloaded the Oracle Database software you may want to read the following articles I have written previously.

Managing Oracle 12c CDB’s and PDB’s – Cloning PDB’s – Part 3

Oracle 12c – Manage Multitenant CDB and PDBs with EM Express
Manage Multitenant CDB and PDBs with EM Express. Quick and easy steps to create, setup and deploy EM Express.

Oracle 12c Database: Create 12c CDB, PDB Databases Using OUI
When installing Oracle Software, you can create 12c CDB, PDB Databases using OUI, just like you used to do in the previous versions of the Oracle database. Read how to create the database.

Oracle 12c Database: Create CDB Database with DBCA
The database configuration assistant is the preferred tool for creating and configuring databases. It has been available for years and with every database version, it’s getting better and better.

Oracle 12c Database: SGA Instance Parameters in CDB and PDB
The new multitenant architecture in Oracle 12c poses a few different concepts which we need to be familiar with when modifying instance parameters. As the instance in the multitenant architecture only belongs to the CDB container, all PDB’s inherit these CDB instance parameters. In this article we will look at changing the instance parameters for both CDB and PDB.

Oracle 12c Database: Managing CDB and PDB tablespaces
In Oracle 12c the tablespace management mostly remains unchanged and the basic operations are performed in a similar way as in 11g. This is because Oracle has made sure that every PDB, though it is a subset of the CDB, in itself functions as a standalone, complete database. In this article we will look at managing the tablespaces in the CDB container and the PDB database.

Oracle 12c Database: Managing Common and Local Users, Roles and Privileges
Managing users, roles and privileges is a very important aspect of the database administration. With Oracle 12c there is a second dimension to controlling this user access and privileges.

Backup of PDB and CDB in Oracle 12c
There are two approaches to managing Backup of PDB and CDB in Oracle 12c Multitenant Environment. The first one is to maintain backups of CDB as a whole. The complete backup of CDB would include the backup of ALL PDBs.

Oracle 12c Database: Flashback a CDB Database
The Flashback feature provides a convenient method to undo mistakes, including reverting DML and dropping of a table.Flashback a CDB Database in Oracle 12c to recover from a logical error.