Multitenant

Does AutoUpgrade support the MOVE option?

Sometimes you have different plans for the day. Or, in my case, the day just needs a few extra hours. Today, I received a very interesting question on the blog at first by a customer I know very well. Then we exchanged mails – and I was caught forgetting what I wrote on the blog a longer while ago. The core question is: Does AutoUpgrade support the MOVE option? But there was much more to discuss and figure out as you can read below.

Does AutoUpgrade support the MOVE option?

Photo by Arron Choi on Unsplash

Which options does AutoUpgrade offer?

The case here is …

Were you aware of the two hidden columns in CDB-Views?

Learning something new every day is the best part of my job. And as you can see and read on the blog, thanks to YOU, I learn a lot. This one I learned from Johannes Ahrends at my workshop for ora2know in Munich in early July this year. Were you aware of the two hidden columns in CDB-Views? I confess honestly: I wasn’t.

Photo by Steinar Engeland on Unsplash

Two hidden columns?

Johannes asked me whether I know the reason for the two hidden columns in every CDB-view. His question was more like: It’s super-useful but why are these hidden?…

OCW25 – Pre-Event Training: Mastering Oracle 23ai Upgrades

Posted on July 15, 2025 by Mike.Dietrich OCW OOW Workshop 0

Time flies so quickly. Soon we’ll get together again in Las Vegas for Oracle Cloud World 2025. This year, it will be in October where hopefully it’s a few degrees colder (or less hot) than in early September last year. And as in the past years, we’ll do at OCW25 – Pre-Event Training: Mastering Oracle 23ai Upgrades.

OCW25 - Pre-Event Training: Mastering Oracle 23ai Upgrades

Photo by Heather Gill on Unsplash

Will our pre-event training be different this year?

Of course, we won’t do the same training as we did in 2024. It will be a different training set with plenty of different exercises. …

Refreshable clone with AutoUpgrade but keep your RAC configuration?

Posted on February 19, 2025 by Mike.Dietrich AutoUpgrade Single-/Multitenant 0

I had to shorten the headline a bit. It got very bulky saying at first: Use a Refreshable Clone with AutoUpgrade from non-CDB to PDB but keep your RAC configuration alive. Well, you see, that’s bulky. But it describes the case I would like to briefly show you. Helmut Pfau, a colleague of mine here in Germany asked this the other day, and it took us a bit to get the correct answer to him – I confess, simply because I didn’t know the right AutoUpgrade parameter.

Refreshable clone with AutoUpgrade but keep your RAC configuration?

Photo by Adrian Infernus on Unsplash

We love Refreshable Clones

You’ve …

Queries on dictionary tables are slow in Oracle Multitenant?

Posted on February 10, 2025 by Mike.Dietrich Flaws and Pitfalls Single-/Multitenant 12

I love to learn something new every day. And on Friday afternoon last week I learned something new again. It started (as often) with a very simple question from a colleague working from the Oracle Malaga office in Spain. The customer has an issues with some queries being slower than before once they moved from on-prem to the cloud into a PDB. But are queries on dictionary tables are slow in Oracle Multitenant generally?

Queries on dictionary tables are slow in Oracle Multitenant?

Photo by Pascal van de Vendel on Unsplash

What was the case?

The customer ran some queries against dictionary views in the PDB in Oracle Database …

Virtual Classroom Seminar 20: Migration to Oracle Multitenant 23ai – Part 2

Posted on June 24, 2024 by Mike.Dietrich Workshop 0

Needed a long title here. And if you haven’t registered yet, please do so now. Thursday, June 27, 2024, we are going to deliver our (potentially last for this year) Virtual Classroom Seminar 20: Migration to Oracle Multitenant 23ai – Part 2. If you missed part 1, no worries, you can watch it on-demand anytime.

Virtual Classroom Seminar 20: Migration to Oracle Multitenant 23ai - Part 2

Photo by Benjamin Voros on Unsplash

Again, we have an exciting deep-dive tech agenda with lots of bits and pieces, and thinks you may not know yet. Hence, regardless if you are already in the Multitenant architecture, or whether you plan to migrate …

Virtual Classroom Seminar #19 “Move to Oracle 23ai” is available – and #20 is coming soon

Posted on May 23, 2024 by Mike.Dietrich Workshop 0

Thanks to the over 350 people who attended our Virtual Classroom Seminar #19 – Move to Oracle Database 23ai: Everything you need to know about Multitenant PART 1 on May 16, 2024. And thanks as well for asking so many questions during the seminar. In case you couldn’t attend, or you’ve had to leave earlier, we are sharing the recording with you, and of course the slides as well.

Virtual Classroom Seminar #19 - Move to Oracle Database 23ai - Multitenant Part 1

What were the topics in VC#19?

In VC#19 we talked about the Oracle Multitenant architecture, how to design a new deployment, how the dictionary is laid out. In addition, you will …

IMPORTANT: Location change for the Warsaw workshop

Posted on February 26, 2024 by Mike.Dietrich Workshop 0

Those of you who have received an email to attend the Upgrade / Migration / Performance / 19c / 23c workshop on Feb 27, 2024 in Warsaw, Poland, please note that we have changed the location to accommodate more people.

IMPORTANT: Location change for the Warsaw workshop

Photo by Łukasz Nieścioruk on Unsplash

Originally, the workshop was going to happen at the Oracle Office in Warsaw. But we moved it to:

HUB Convention Center
Crowne Plaza® Warsaw – The HUB
Holiday Inn Express® Warsaw – The HUB
Rondo Daszyńskiego 2
00-843 Warsaw

Please make sure to arrive at 9:00h, we will start straight at 9:30h and …

Your chance – in-person Oracle 23c upgrade workshops in Warsaw and Munich

Posted on January 24, 2024 by Mike.Dietrich Workshop 9

We have a rare offer for you. Not Santa but Daniel and I are coming to town. So, this is your chance – in-person Oracle 23c upgrade workshops in Warsaw and Munich. You are signing up for a packed day of tech. No marketing slides – just facts and features, not only Oracle Database 23c, the new upcoming long-term support release. But certainly we’ll have enough for all those you are just in the process of moving to Oracle Database 19c.

Your chance - in-person Oracle 23c upgrade workshops in Warsaw and Munich

Photo by Łukasz Nieścioruk on Unsplash

When?

We are absolutely excited to offer you a full-day in-person all-tech …

Migrating Flashback Data Archive (FDA) tables

Posted on April 8, 2022 by Mike.Dietrich Export - Import 17

This morning I received an email question from a customer asking whether there is support for the Migrating Flashback Data Archive (FDA) tables in Oracle 19c. And since this is not the first time I received this question, I thought it may be good to have a blog post about it.

Photo by Anita Jankovic on Unsplash

What is Flashback Data Archive (FDA)?

Well, google it. Actually I was looking for a link in our documentation but to my surprise I found the usual suspects such as Tim Hall’s excellent oracle-base page – but not much in our own doc …

UNDO_RETENTION not inherited to PDBs anymore since 19.9.0

Posted on July 12, 2021 by Mike.Dietrich Behavior Change 15

Behavior changes introduced via a bug fix may not be something you like a lot. And thanks to Sreedhar from one of our most important customers I learned on the weekend: UNDO_RETENTION not inherited to PDBs anymore since 19.9.0.

UNDO_RETENTION not inherited to PDBs anymore since 19.9.0

Photo by Ben Wicks on Unsplash

What is happening before 19.9.0?

Until Oracle 19.8.0 you could change the UNDO_RETENTION in the CDB$ROOT, and it applied to all PDBs automatically. You may or may not have cared. But there are cases when you’d like to change an undo related parameter in the CDB$ROOT without its propagation into all PDBs.

This behavior …

Data Pump Super Patch for Oracle 19.10 and newer

Posted on April 15, 2021 by Mike.Dietrich Data Pump Patch Recommendation 64

Just a few days we released a Data Pump Super Patch for Oracle 19.10 and newer. “Newer” refers to the fact that once 19.11.0 will be available, this merge patch I’m writing about will be available as well right away (sorry, got delayed a bit). And if you work with Data Pump, you may want to consider this performance patch collection.

Photo by paolo candelo on Unsplash

Why do you need this patch?

Many customer will know the issue that adding changes with datapatch may take a long time as soon as dpload.sql is involved. And this …

Do you need the Mitigation Patch in CDB$ROOT and all PDBS?

Posted on January 25, 2021 by Mike.Dietrich JVM Patch Recommendation 10

Thanks to Axel Delin for asking this very reasonable question on the blog. Do you need the Mitigation Patch in CDB$ROOT and all PDBS? Background for this question is that Axel can’t remove JVM but doesn’t use it. A typical case we cover in our slides and presentations as well. And in this case, the Mitigation Patch will become your friend. Please note: If you DON’T have JAVAVM in your database, you won’t need to pay attention and instead could stop reading now.

Photo by Mick Truyts on Unsplash

Mitigation Patch

You can read more about the Mitigation Patch, and …

User Group Seminars in October about Upgrade, Migration and Patching

Posted on September 30, 2020 by Mike.Dietrich Workshop 0

I didn’t blog a lot in the past weeks. At the moment, most of my time is consumed either by customer web meetings and workshops, or the preparation for the User Group Seminars in October about Upgrade, Migration and Patching. Below I will list these – please feel free to sign up. #SupportUserGroups

User Group Seminars in October about Upgrade, Migration and Patching

Photo by Kyle Glenn on Unsplash

October 1 – Swiss Oracle User Group

October will start for me with a keynote for the Swiss Oracle User Group on Thursday, October 1 at 13:00h, about the Migration to Oracle Multitenant.

Registration: https://soug.ch/soug-day-september-21st-2020/
Date / Time:

LAOUC Web Seminar: Oracle Multitenant – 3 PDBs and many secrets

Posted on August 17, 2020 by Mike.Dietrich Workshop 2

Just a few hours left until I’ll start my LAOUC Web Seminar: Oracle Multitenant – 3 PDBs and many secrets today, Aug 17, 2020. I’m really looking forward to it even though it is a bit sad this time. Usually in the past years I was traveling to Latin America. And I enjoyed the intense discussions in Uruguay, Argentina and Brazil a lot. The local folks invest so much time in these yearly user group conferences. Hence, as for most other events as well, this year you’ll be able to participate virtually over multiple days.

LAOUC Web Seminar: Oracle Multitenant - 3 PDBs and many secrets

Oracle Multitenant – 3 PDBs

Upgrade Seminars 2020 – Recap and Videos on-demand

Posted on July 6, 2020 by Mike.Dietrich Workshop 4

Thank you for participating in our 4 Database Upgrade to Oracle 19c seminars in the past two weeks. There were over 800 questions during the seminars – and it was a good idea that we prerecorded them. This way, I could answer your questions as it was a more convenient time for me than for Roy. We enjoyed it a lot – and from the feedback I read, most of you enjoyed it, too. Now please read about Upgrade Seminars 2020 – Recap and Videos on-demand below.

Upgrade Seminars 2020 - Recap and Videos on-demand

Photo by Glenn Carstens-Peters on Unsplash

The Slides

I uploaded all 4 decks …

Upgrade Seminars 1 and 2 – A quick recap, slides download and more

Posted on June 25, 2020 by Mike.Dietrich Best Practice Workshop 2

Thank you for participating in the first two seminars. Roy and I did already the “Release and Patching Strategy” webinar on Tuesday, June 23. And today “AutoUpgrade to Oracle 19c”. So it time for Upgrade Seminars 1 and 2 – A quick recap, slides download and more.

Photo by v2osk on Unsplash

Slides Download

I uploaded the slides already to https://mikedietrichde.com/slides/#WEB2020. Of course, I will upload the other slide decks as well to the same location.

Seminar Recordings

As soon as the recordings page has been completed, we will send out an email. And I will post the links …

Can you connect as SYSDBA without password into a PDB directly?

Posted on May 7, 2020 by Mike.Dietrich Single-/Multitenant 28

I’m happy when I learn something new every day. And today, right before I wanted to turn my computer into “sleep”, I learned something which surprises me a lot. Have you ever asked the question: Can you connect as SYSDBA without password into a PDB directly? Of course with the usual way of “sqlplus / as sysdba”.

Photo by Jonas Verstuyft on Unsplash

Can you?

Our answer always was: No. You can’t. There is no bequeath connection available.

Today somebody asked a similar question internally. And the answer caught Roy, Daniel, Bill and myself by surprise. There is an …

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

3 Live Seminars: Database Upgrade and more – April 28, 29 and 30, 2020

Posted on April 24, 2020 by Mike.Dietrich Workshop 13

Well, everybody does Web Seminars now, right? Just in case you sit at home next week on Tuesday, Wednesday and Thursday, you’ve just had your lunch. And you don’t know what do to in the afternoon, sign up and click in to our 3 Live Seminars: Database Upgrade and more – April 28, 29 and 30, 2020. Every day at the same time, 14:30h CET (or 13:30 GMT or 18:00 IST).

3 Live Webinars: Database Upgrade and more – April 28, 29 and 30, 2020

Photo by Sam Balye on Unsplash

Another Web Seminar?

It’s free – FIND THE REGISTATION LINKS BELOW – of course. My colleague Laura Garcia and I will talk …

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 …

Be aware when you use _ORACLE_SCRIPT in scripts

Posted on February 10, 2020 by Mike.Dietrich Best Practice 8

Recently I came across this when I gave a Multitenant workshop at a German customer. As part of the workshop I explained the _ORACLE_SCRIPT statements you will find in almost all scripts in ?/rdbms/admin. And one of the DBAs gave me a bright smile. He mentioned: “We use it already everywhere to avoid strange errors”. But be aware when you use _ORACLE_SCRIPT in scripts. I will explain, why this can be dangerous.

Be aware when you use _ORACLE_SCRIPT in scripts

Photo by Justin Chrn on Unsplash

What does _ORACLE_SCRIPT do?

First of all, this is an underscore parameter. Hence, you won’t find it in the Oracle …

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 …

Can you have more than 1 PDB with Standard Edition 2 (SE2)?

Posted on January 29, 2020 by Mike.Dietrich SE2 - Standard Edition 2 Single-/Multitenant 0

When we announced the 3-PDB-Support with Oracle Database 19c onward at OpenWorld 2019, I was very excited. According to the license documentation, this applies to Standard Edition 2 (SE2) as well. But does it work? Can you have more than 1 PDB with Standard Edition 2 (SE2)?

Can you have more than 1 PDB with Standard Edition 2 (SE2)?

Photo by Şahin Yeşilyaprak on Unsplash

The license documentation is pretty clear about 3 user-created PDBs:

https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.html#GUID-0F9EB85D-4610-4EDF-89C2-4916A0E7AC87

Check with Oracle Database 19.5.0 SE2

It’s been a while since I installed SE2 instead of EE. But everything goes smoothly. You just need to select “Standard Edition 2” in the OUI. The image you …

Mobiliar Insurance consolidates over 350 PDBs to new Exadatas

Posted on December 20, 2019 by Mike.Dietrich Customer Success 0

The year is almost over and many of you will take off in your well-deserved holidays. At this point it’s not time yet for a 2019 summary or my “Best Records of 2019” list, but to highlight a great success story from Swiss Mobiliar Insurance’s Oracle team.

Mobiliar Insurance consolidates over 350 PDBs to new Exadatas

Photo by Melina Kiefer on Unsplash

Mobiliar Insurance – never heard about them?

There are actually two typical situations when you’ve never heard about Mobiliar Insurance (“Die Mobiliar“) before. You either don’t live in Switzerland and you never visited one of our workshops nor any of the talks Alain Fuhrer and …

Multitenant

Which options does AutoUpgrade offer?

Two hidden columns?

Will our pre-event training be different this year?

We love Refreshable Clones

What was the case?

What were the topics in VC#19?

When?

What is Flashback Data Archive (FDA)?

What is happening before 19.9.0?

Why do you need this patch?

Mitigation Patch

October 1 – Swiss Oracle User Group

Oracle Multitenant – 3 PDBs

The Slides

Slides Download

Seminar Recordings

Can you?

Your Questions, our Answers for Seminar 3: Multitenant

Another Web Seminar?

It’s a bit tricky

What does _ORACLE_SCRIPT do?

Mixed version environments

Check with Oracle Database 19.5.0 SE2

Mobiliar Insurance – never heard about them?

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Recent Posts