Tag Archives: multitenant

Multitenant : PDB CONTAINERS Clause

I forgot to mention, I put another multitenant article live at the weekend. Multitenant : PDB CONTAINERS Clause in Oracle Database 12c Release 1 (12.1.0.2) I’m not sure I will ever use it, but it’s good to know it’s there. I was originally working on an article on a completely different multitenant feature, but the […]

To PDB or not to PDB : The final decision

After yesterday’s to PDB or not to PDB post, I decided the answer was “to PDB”. Here’s what I did… Installed the Oracle 12c (12.1.0.2) software. There is an installation article here, but all I had to do was a software-only installation because the OS already met all the prerequisites because of the existing 11.2.0.3 […]

To PDB or not to PDB

I’m about to start a Proof of Concept (POC) for a 12c upgrade of one of our databases. The production database in question is running on Oracle Linux inside a VMware virtual machine, so the starting point I’ve been given for the POC is a clone of the whole VM… Probably the biggest decision I’ve got to […]

More Oracle Multitenant Changes (12.1.0.2)

When I wrote about the remote cloning of PDBs, I said I would probably be changing some existing articles. Here’s a change I’ve done already. Preserve PDB Startup State (12.1.0.2 onward) There are also new articles. Multitenant : Metadata Only PDB Clones in Oracle Database 12c Release 1 (12.1.0.2) Multitenant : PDB Subset Cloning in Oracle Database […]

Remote Cloning of PDBs and Non-CDBs (12.1.0.2)

I mentioned in a previous post that I would be revisiting some of my existing multitenant articles to include some of the features introduced in the 12.1.0.2 patch. Here’s one of them. Multitenant : Clone a Remote PDB or Non-CDB in Oracle Database 12c (12.1.0.2) Not only have Oracle fixed the bug in 12.1.0.1 that […]

Articles on Oracle Database 12c Multitenant Option

From a technology perspective, the Multitenant option is really cool, but it can be rather difficult to get to grips with some aspects of it. Everything is so intertwined and every feature in 12c somehow links back to the Multitentant option. As I’ve been working my way through the features the same pattern keeps repeating. […]

Quick Pluggable Database (PDB) Update…

I’ve been playing around with using SQL Developer and Cloud Control 12cR3 for managing pluggable databases (PDBs) this morning. I’ve added a couple of quick references to my PDB article. Multitenant : Create and Configure a Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.1) If you understand the DBCA and SQL*Plus approach, the […]

Oracle 12c Multitenant Option : CDBs and PDBs…

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 […]