• Database Blog
  • GoldenGate 12c
    • Top 50 Oracle Goldengate Interview Questions To Get the Job!
  • Master Oracle 12c DBA
  • Oracle Tutorials
    • Oracle Tips & Tricks
    • Oracle VirtualBox
  • Learn Excel

VitalSoftTech

Database Administration | Oracle | Oracle Training | DBA Support | Oracle 12c DBA | GoldenGate | GoldenGate 12c | DBA Interview Questions | Goldengate Interview Questions | Natik Ameen

  • Digital Marketing
  • Blogging Tutorial and Tips
  • Cool Names
  •   Login

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

  • Oracle 12cDatabase New Features
  • Oracle 12cSoftware Installations
  • Oracle 12cMultitenant Administration
  • Oracle 12c12c Database on VirtualBox
  • Oracle 12cRAC Administration
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

Cloning a database used to be a difficult, if not a hectic process. Before 12c the most efficient method to create the clone required using RMAN. However even this method has quite a number of steps inlvolved. In 12c too, the effort required to clone the CDB database is almost same as before but not for PDBs. Cloning PDB is as easy as executing three to four simple commands. Learn more about it here.

Managing Oracle 12c Database: Container and Plugable Databases
The Oracle 12c Database has the most new features ever released with any version of any database. As you might have guessed from it’s name, the new version is more focused on Cloud Computing. Learn more about it here.

Oracle 12c Database: Managing PDBs using Database Configuration Assistant
In 12c, the database configuration assistant can also be used to manage the PDB’s alongside the CDB and non-CDB databases. In this article we will look at managing the PDBs, using the database configuration assistant.

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.

Join over 3,000 others My posts. Your Inbox. Beautiful.

Database    GoldenGate

Natik Ameen

About Natik Ameen

Natik Ameen is an Oracle Production DBA, Oracle Certified RAC Expert and a DBA track Certification trainer for over 17 years. He is an Oracle Evangelist and has presented at IOUG & UTOUG conferences. He writes on topics such as Database Administration, RAC, GoldenGate and the Cloud.

Who is Natik Ameen?

Guides

  • My GoldenGate Tutorials
  • Oracle 12c Database Tutorials
  • GoldenGate GGSCI Command Series
  • My OraTips and Tricks

Popular Blogs

  • My GoldenGate Home Page
  • Top 50 Oracle Goldengate Interview Questions To Get the Job!
  • Top 30 RAC Interview Questions That Helped Me. Are You Prepared?
  • Oracle GoldenGate Concepts and Architecture Made Simple!
  • Virtualize Oracle RAC 12c on My Laptop
  • Step by Step Oracle 12c Database Install on Virtual Box

Popular Oracle Articles

Oracle Announces Beta Availability of Oracle Database 12c Release 2
Top 5 Announcements at Oracle Open World
News on Oracle Database STANDARD EDITION 12.1.0.2

Technology Centers

Oracle Business Intelligence and DW
Cloud Computing, SOA, Virtualization
Big data, Java, Linux, PLSQL, Security
Enterprise Architecture, Digital Experience

Oracle Documentation

10g R1, 10g R2, 11g R1, 11g R2, 12c R1
Oracle CPU's, EM 11g, EM 12c
GoldenGate 12c, Oracle VM, VirtualBox

Copyright ©2021

BLOGOracle Tutorials