Single Tenant

Can you have Oracle Multitenant in Oracle 12.1.0.2 SE2?

Posted on September 3, 2015 by Mike.Dietrich SE2 - Standard Edition 2 Single-/Multitenant 3

Please find all our articles about Oracle Database Standard Edition 12.1.0.2 SE2:

Can you have Oracle Multitenant in Oracle Standard Edition 12.1.0.2 SE2?

No, you can’t as Oracle Multitenant is a licensable option for Enterprise Edition (EE) databases only.

But wait a second …

You can do Oracle Single …

Create a PDB directly from a stand-alone database?

Posted on May 18, 2015 by Mike.Dietrich Single-/Multitenant 11

The documentation offers a well hidden feature for migrating a database into the universe of Oracle Single-/Multitenant:

Remote Cloning with the NON$CDB option.

If you’ll read the documentation it doesn’t say much about this option, neither the requirements nor the exact syntax or an example:
http://docs.oracle.com/database/121/SQLRF/statements_6010.htm#SQLRF55686

Scroll down to the FROM clause:

… FROM NON$CDB@dblink … this option will be able to plugin a stand-alone database and make it a pluggable database. Sounds interesting, let’s try it.

Test 1 – Try to plugin an Oracle 11.2.0.4 database

Well, the documentation doesn’t say anywhere anything about source release limitans. So …

Applying a PSU or BP to a Single-/Multitenant Environment

Posted on March 9, 2015 by Mike.Dietrich Patch Recommendation Single-/Multitenant 0

I have already explained in broad details a while ago how to:

Upgrade a Multitenant Environment – Everything at Once
https://mikedietrichde.com/2014/08/06/upgrade-pdbs-everything-at-once-full-cdb-upgrade/
Upgrade in a Single-/Multitenant Environment – One/Many at a time
or also known as unplug/plug/upgrade strategy
https://mikedietrichde.com/2014/08/05/upgrade-pdbs-one-at-a-time-unplugplug/

But one may miss the steps for applying a PSU (Patch Set Update) or BP (Bundled Patch) to a Single-/Multitenant Environment.

At first everything will work just the same if you choose the Everything-at-Once strategy as datapatch will adjust all the required things regardless of being executed in a stand-alone or a singe/Multitenant environment.

But what happens if you apply a …

Upgrade to 12c and Plugin – one fast way to move into the world of Oracle Multitenant

Posted on January 29, 2015 by Mike.Dietrich Oracle Database 12c Single-/Multitenant Upgrade / Migration 0

What is the best way to move into Oracle Multitenant (which includes Single Tenant with just one PDB) as well?

This question came up on the blog, it’s part of the Multitenant chapter in our big slide deck but let me elaborate this a bit more in detail. Of course there are several ways to move a database into a Single/Multitenant environment such as Data Pump but one fact is for sure: You can’t convert a stand-alone database to become a container database (CDB$ROOT). A container database has to be built up from scratch as first step. Please …

New MOS Notes on Database Upgrades for 12c with or without Oracle Multitenant

Posted on January 13, 2015 by Mike.Dietrich MyOracle Support Oracle Database 12c Single-/Multitenant 1

Please find some new MyOracle Support (MOS) Notes about Database Upgrades to Oracle Database 12c, with or without Oracle Multitenant:

MOS Note: 1503653.1
Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1)
.
MOS Note: 1932762.1
Complete checklist for manual upgrade from 12.1.0.1 to 12.1.0.N (Full CDB Upgrade)
.
MOS Note: 1933391.1
Complete checklist for 12c R1 PDB upgrade (Upgrading single/multiple PDB)
.
MOS Note: 1932340.1
How to execute sql scripts in Multitenant environment (catcon.pl)
.
MOS Note: 1933011.1
Complete Checklist for DBUA Upgrade from 12.1.0.1 to 12.1.0.N
.

Credits for the CDB/PDB Notes go to

Automatic Maintenance Jobs in every PDB? New SPM Evolve Advisor Task in Oracle 12.1.0.2

Posted on August 22, 2014 by Mike.Dietrich Single-/Multitenant 8

A customer checking out our slides from the OTN Tour in August 2014 asked me a finicky question the other day:

“According to the documentation the Automatic SQL Tuning Advisor maintenance task gets executed only within the CDB$ROOT, but not within each PDB – but the slides are not clear here. So what is the truth?”

Ok, that’s good question. In my understanding all tasks will get executed within each PDB – that’s why we recommend (based on experience) to break up the default maintenance windows when using Oracle Multitenant. Otherwise all PDBs will have the same maintenance windows, and …

Upgrade PDBs – Everything At Once (Full CDB Upgrade)

Posted on August 6, 2014 by Mike.Dietrich Single-/Multitenant 18

As referred to it before there are two techniques to upgrade an Oracle Multitenant environment:

In this post I will explain the method of “Everything At Once” and describe all the steps. The benefit of this approach is simplicity and ease of maintenance. In an upgrade workshop in Melbourne earlier this year a DBA from Germany came by in one of the breaks explaining that he takes care on over 100 developer databases – and it would ease his life a lot if he could …

Upgrade PDBs – One at a Time via unplug/plug/upgrade

Posted on August 5, 2014 by Mike.Dietrich Single-/Multitenant 18

Basically there are two techniques to upgrade an Oracle Multitenant environment:Everything at Once and One (or many) at a Time. This blog post describes the case how to Upgrade PDBs – One at a Time via unplug/plug/upgrade. I will describe all necessary steps. During some presentations, discussions etc people were left with the impression that it will be a very simple approach to unplug one or many PDBs from a CDB in lets say Oracle 12.1.0.1 and plug it into an Oracle 12.1.0.2 Container Database. Bingo, upgraded!

Well, unfortunately this is not true. In fact it …

Remote Cloning of Pluggable Databases
in Oracle Database 12.1.0.1

Posted on July 7, 2014 by Mike.Dietrich Single-/Multitenant 0

Cloning of Pluggable Database in Oracle Multitenant is a great feature and very useful. It had just a tiny flaw in Oracle Database 12.1.0.1: Remote cloning from one to another CDB fails.

This will work flawless beginning with the first patch set Oracle 12.1.0.2 – but if you want to use that feature still in Oracle 12.1.0.1 you need to apply at least PSU3 or a single patch 18898403.

See the documentation:

–Mike…

Single Tenant

Can you have Oracle Multitenant in Oracle 12.1.0.2 SE2?

Can you have Oracle Multitenant in Oracle Standard Edition 12.1.0.2 SE2?

But wait a second …

Create a PDB directly from a stand-alone database?

Remote Cloning with the NON$CDB option.

Test 1 – Try to plugin an Oracle 11.2.0.4 database

Applying a PSU or BP to a Single-/Multitenant Environment

Upgrade to 12c and Plugin – one fast way to move into the world of Oracle Multitenant

New MOS Notes on Database Upgrades for 12c with or without Oracle Multitenant

Automatic Maintenance Jobs in every PDB? New SPM Evolve Advisor Task in Oracle 12.1.0.2

Upgrade PDBs – Everything At Once (Full CDB Upgrade)

Upgrade PDBs – One at a Time via unplug/plug/upgrade

Remote Cloning of Pluggable Databases
in Oracle Database 12.1.0.1

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Follow me on Twitter

Recent Posts