Plug

Unplug / Plug / Upgrade with AutoUpgrade

Posted on June 7, 2021 by Mike.Dietrich Single-/Multitenant 21

When we launched AutoUpgrade, it could upgrade non-CDBs and CDBs with all PDBs. Soon after, it learned to upgrade a non-CDB and plug it into an existing CDB as a new PDB. And then, as next step, we added Unplug / Plug / Upgrade with AutoUpgrade. In this case you have a PDB (or hopefully more than one), and you’d like to upgrade one or many PDBs by moving them to a new CDB with a higher database version.

Unplug / Plug / Upgrade with AutoUpgrade

Photo by Kelly Sikkema on Unsplash

Test Setup

As test setup I use our Hands-On Lab.

I will …

Oracle Multitenant: Be aware of the silent COMPATIBLE change

Posted on February 7, 2020 by Mike.Dietrich Single-/Multitenant 5

This topic is included in our Multitenant slides for a long time. But whenever I want to point somebody to the blog post, I realize that it’s not on the blog yet. Actually I discussed this topic recently during a customer visit again. It’s time to put it on the blog. When you use Oracle Multitenant: Be aware of the silent COMPATIBLE change.

Oracle Multitenant: Be aware of the silent COMPATIBLE change

Photo by Clint Patterson on Unsplash

Mixed version environments

When you work with Oracle Multitenant, the sooner or later you will have mixed version environments. This may be CDBs with Oracle 12.1.0.2 or Oracle 12.2.0.1 together with …

Unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud

Posted on April 5, 2018 by Mike.Dietrich Cloud Single-/Multitenant 6

There’s been silence for a while – but today I’d like to show you how to unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud. I’m doing this exercise because I’ve seen questions already. And I was curious if it works as I’d expect it.

Unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud

As usual I will use our hands-on lab environment – and a freshly deployed 18c OCI-Classic instance (formerly known as DBCS formerly known as DBaaS).

Unplug a 12.2.0.1 PDB and plugin into 18c inthe Cloud

It is a Single Tenant environment with one PDB. If you need for information about how to …

Can you simply switch from SE2 to EE with Oracle Multitenant

Posted on July 18, 2017 by Mike.Dietrich SE2 - Standard Edition 2 Single-/Multitenant Uncategorized 8

This question is coming up from time to time – and currently not covered in the official Oracle documentation as far as I know: “Can you simply switch from SE2 to EE with Oracle Multitenant?”

Yes, you can!

First of all, the switch is possible and tested. But you’ll have to satisfy a few requirements:

Both database versions must be the same
Both databases must have the same character set (in Oracle Database 12.1)

That’s it. Simply unplug your Standard Edition 2 PDB and plug it into your Enterprise Edition CDB.

In addition you may have to run several component …

PDB unplug/plug/patch with PSUs or BPs

Posted on August 1, 2016 by Mike.Dietrich Patch Recommendation Single-/Multitenant 2

This question was posted on the blog a few days ago referring to my previous blog posts describing the two techniques to upgrade in an Oracle Multitenant environment:

Question:

We are planning to upgrade from 12.1.0.2.1 to 12.1.0.2.5.
The plan is to create new 12.1.0.2.5 oracle home and
gradually moving PDB from 12.1.0.2.1 to 12.1.0.2.5.
Should I follow the same steps?
Is there any document for what we want to do?

And luckily there is a MOS Note out there describing the steps:

MOS Note:2102849.1
Unplug/Plug on different PSU

Plug

Unplug / Plug / Upgrade with AutoUpgrade

Test Setup

Oracle Multitenant: Be aware of the silent COMPATIBLE change

Mixed version environments

Can you simply switch from SE2 to EE with Oracle Multitenant

Yes, you can!

PDB unplug/plug/patch with PSUs or BPs

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts

Follow me on Twitter