noncdb_to_pdb.sql

3 Live Seminars: Multitenant Seminar 3 Questions answered

Posted on May 3, 2020 by Mike.Dietrich Workshop 0

This is the third and final QA blog post for the Seminars we did in the last week of April 2020. Thank you for your attendance. I will publish the replay recordings as soon as they are available and link them as well. For now, please find here 3 Live Seminars: Multitenant Seminar 3 Questions answered.

3 Live Seminars: Multitenant Seminar 3 Questions answered

Photo by Holger Link on Unsplash

Your Questions, our Answers for Seminar 3: Multitenant

103	We are in the process of migrating to Oracle Cloud using the xtts method for cross platform migration and we seem to be encountering an issue with it

OJVM datapatch fails with ORA-29532 – but the root cause is noncdb_to_pdb.sql

Posted on April 20, 2020 by Mike.Dietrich Flaws and Pitfalls JVM 2

Kudos to Robert Ortel who brought this nice misbehavior to my attention. And even though it looks like this would be an OJVM issue, it is caused by noncdb_to_pdb,sql, the script which is used to convert a non-CDB to a PDB. When you apply an OJVM patch, OJVM datapatch fails with ORA-29532 – but the root cause is noncdb_to_pdb.sql.

OJVM datapatch fails with ORA-29532 - but the root cause is noncdb_to_pdb.sql

Photo by Alexandra Gorn on Unsplash

It’s a bit tricky

First things first. This is not a blog post to blame OJVM. The problem just happens because datapatch for an OJVM patch touches data in the dictionary which hasn’t …

Database Migration from non-CDB to PDB – Plug in, upgrade, convert

Posted on July 24, 2019 by Mike.Dietrich Single-/Multitenant 2

This is my next blog post about Database Migration from non-CDB to PDB – Plug in, upgrade, convert. But what is different from the previous one? And why is it necessary? Since Oracle Database 12.2.0.1 you can plugin a non-CDB at first, the upgrade and convert it. And I’ll show you this technique here.

Photo by Dan Freeman on Unsplash

High Level Overview

Endianness change possible:	No
Source database versions:	Oracle 12.2.0.1 or newer (or 12.1.0.2 when CDB has shared UNDO or with a patch adding the UNDO commands to DBMS_PDB.DESCRIBE in 12.1.0.2)
Characteristic:	Plugin into CDB first
Upgrade

noncdb_to_pdb.sql – why does it take so long?

Posted on June 8, 2017 by Mike.Dietrich Single-/Multitenant 16

What is noncdb_to_pdb.sql?

noncdb_to_pdb.sql - Why does it take so long? The script noncdb_to_pdb.sql gets run only once in the life span of your database. It gets executed when a regular Oracle database (non-CDB) gets move to become part of a Single-/Multitenant deployment as a pluggable database (PDB). But why does it take so long?

You will never run this script again for this database. The script is a sanity script to clean up and change things in a non-CDB, and unite it finally and irreversible with the CDB.

How long does it take to complete?

Runtime varies a lot. It depends mainly on the number of objects …

Upgrade to Oracle Database 12.2 and Converting it into an 12.2 PDB (plugin)

Posted on March 8, 2017 by Mike.Dietrich catctl.pl Oracle Database 12.2.0.1 Oracle Database 12c Single-/Multitenant Upgrade / Migration 18

2 customers requested a bit more explanation on how to:
Convert and Plugin an Oracle 12.1 non-CDB database into an Oracle 12.2 container database

Cool, I like that 🙂 I will do this right away and use the approach to Upgrade first, then Plugin afterwards.

Upgrading an Oracle 12.1.0.2 database to Oracle 12.2.0.1

First the preupgrade.jar must be executed – please download always the most recent version from MOS Note:884522.1 as the version we publish is usually newer including important improvements (and fixes) than the version you’ll get with the release drop. We are working on including always the …

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 …

noncdb_to_pdb.sql

3 Live Seminars: Multitenant Seminar 3 Questions answered

Your Questions, our Answers for Seminar 3: Multitenant

OJVM datapatch fails with ORA-29532 – but the root cause is noncdb_to_pdb.sql

It’s a bit tricky

Database Migration from non-CDB to PDB – Plug in, upgrade, convert

High Level Overview

noncdb_to_pdb.sql – why does it take so long?

What is noncdb_to_pdb.sql?

How long does it take to complete?

Upgrade to Oracle Database 12.2 and Converting it into an 12.2 PDB (plugin)

Upgrading an Oracle 12.1.0.2 database to Oracle 12.2.0.1

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

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Follow me on Twitter

Recent Posts