This note describes the new features related to the Oracle Database Multitenant option which have been introduced in Oracle 12c Release 2 (220.127.116.11). The hands-on exercises included in the note demonstrates the use of the following new multitenancy features: Hot Cloning Refreshable Pluggable Databases Support for pluggable databases with multiple You need to be logged […]
In a CDB since we have multiple pluggable databases sharing a set of common resources, we can prevent multiple workloads to compete with each other for both system as well as CDB resources by using Resource Manager. Let us look at an example of managing resources for Pluggable Databases (between PDB’s) at the multitenant Container […]
Until very recently I had really believed the marketing hype and sales pitch about how in 12c database upgrades are so much faster and easier than earlier releases – just unplug the PDB from one container and plug it in to another container and bingo you have an upgraded database! Partly true …. maybe about […]
Heres a quick look at some of the new features introduced in 18.104.22.168 around Pluggable and Container databases. PDB CONTAINERS Clause Using the CONTAINERS clause, from the root container we can issue a query which selects or aggregates data across multiple pluggable databases. For example each pluggable data can contain data for a specific geographic […]
Prior to oracle database 12c, the procedures for converting from single-instance databases to Real Application Clusters involved following steps: Configure the control file attributes and move control file to shared storage Make the initialization parameter file entries for cluster-enabled environments and move SPfile to shared storage Create an undo tablespace for each additional instance Create redo threads for each additional… Continue Reading →
In this article, I will demonstrate how to quickly create a standby database for a non-multitenant container database (NCDB) by plugging it as a pluggable database (PDB) into primary CDB (BOSTON). This method tremendously simplifies and speeds up the procedure to create a standby database without the need to set various initialization parameters or take backup or configure tnsnames.ora entries… Continue Reading →
Here are a few examples of backup and recovery in an Oracle 12c multitenant environment with Container and Pluggable databases involved.
The first thing to keep in mind is the structure of a 12c Container and Pluggable database. There is only one set o…
在Oracle 22.214.171.124版本中,在cdb数据库启动过程中,业务pdb无法 … 继续阅读 →
I started trying to play with the Oracle multitenant option (all that pluggable database stuff) a little while ago and gave up. It’s wasn’t that it was that difficult. More than anything my problem was I didn’t know what to focus on first. There is so much to it and it’s all interrelated, so you start […]
Oracle 12c Multitenant Option : CDBs and PDBs… was first posted on August 22, 2013 at 11:05 pm.
©2012 “The ORACLE-BASE Blog“. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.
In one of my earlier posts we had seen how we can create a 12c CDB (container database) using DBCA and we had also seen how we can upgrade a database from 126.96.36.199 to Oracle 12c Release 1.
The Container database cdb12c originally has one pluggable d…