PDB

Choose your desired time zone version (DST) upgrade

This morning I received a very reasonable question from a customer who has a time zone mismatch between source and target database. And he wants to transport into a PDB on Exadata. Even though, this sounds trivial at first sight, unfortunately it isn’t. But a bug fix done recently for a German automotive customer is very handy here. So let me show you how you can Choose your desired time zone version (DST) upgrade.

Choose your desired time zone version (DST) upgrade

Photo by Vince Veras on Unsplash

Where does the problem start?

In this particular – and not unusual case – the customer wants to migrate …

Virtual Classroom Seminar: Fallback Is Your Insurance – on Nov 11, 2021

Posted on November 10, 2021 by Mike.Dietrich Workshop 4

No worries, I haven’t become lazy recently. But the past weeks were more busy than anything I have experienced so far. And I had a full week off and enjoyed the silence and absence from blogs and cell phones and email in the mountains. But now I’m back – and surprise, surprise – this week on Thursday we’ll have our 11th Virtual Classroom Seminar: Fallback Is Your Insurance – on Nov 11, 2021.

Fallback Seminar

When will it happen?

Thursday, Nov 11, 2021 – 10:00h CET

What are we going to talk about?

Fallback and Rollback. How to secure your job. …

Upgrading a non-CDB to Oracle Database 21c with AutoUpgrade

Posted on August 24, 2021 by Mike.Dietrich AutoUpgrade Oracle Database 21c Upgrade / Migration 9

Yesterday I wrote about the installation of Oracle Database 21c on Linux. But today it is time for Upgrading to Oracle Database 21c with AutoUpgrade.

Photo by Arjun MJ on Unsplash

AutoUpgrade

You may have heard it already from us and other colleagues, but we can’t repeat it often enough: There is only one recommended tool to upgrade your databases – and this is AutoUpgrade.

In my 21c home, I’m checking the deployed version of AutoUpgrade at first:

[CDB3] oracle@hol:/u01/app/oracle/product/21/rdbms/admin
$ java -jar autoupgrade.jar -version
build.hash 57ab246
build.version 21.1.3
build.date 2021/04/21 13:32:13
build.max_target_version 21
build.supported_target_versions 12.2,18,19,21
build.type production

Now please …

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 …

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 …

Oracle AutoUpgrade between two servers – and Plugin?

Posted on August 4, 2020 by Mike.Dietrich AutoUpgrade 13

In my previous blog post I demonstrated how you can upgrade with AutoUpgrade between two servers. This a very typical scenario where you get new server, often also with a newer operating system version installed. But I was wondering if you can use Oracle AutoUpgrade between two servers – and Plugin?

Photo by Frederick Tubiermont on Unsplash

AutoUpgrade between two servers

Please see my previous blog post about all the details:

Oracle AutoUpgrade between two servers – Aug 3, 2020

Upgrade and Plugin?

At the end of it, I was curious if I couldn’t just plugin afterwards. But I …

Transportable Tablespaces – Example and strange error with a PDB

Posted on July 7, 2020 by Mike.Dietrich Data Pump Single-/Multitenant Transportable 6

Yesterday I was browsing around for a useful simple example to test Transportable Tablespaces. A colleague mailed with the other day with a strange error message. The attempt to import into a PDB in Oracle 19c failed. My first thought: Oh, this is simple. But I failed, too. And even worse, I couldn’t find a single useful note in MyOracle Support (MOS) for ORA-31640, ORA-27037, Linux-x86_64 Error: 2 with Additional information: 7. So I decided to summarize this in Transportable Tablespaces – Example and strange error with a PDB.

Transportable Tablespaces - Example and strange error with a PDB

Photo by Kerensa Pickett on Unsplash

A simple Transportable Tablespace

Collection of EBS upgrade information for Oracle Database 19c

Posted on June 30, 2020 by Mike.Dietrich E-Business Suite 0

This was the question I received the most often during the Virtual Classroom web seminars last week: “Can you say something about EBS upgrades with 19c?”. And I promised to publish a blog post about it. But as I’m not an EBS expert, I can only share a Collection of EBS upgrade information for Oracle Database 19c. For all further inquiries, please open an SR or get in touch with your Oracle contact.

Collection of EBS upgrade information for Oracle Database 19c

Photo by Charles Forerunner on Unsplash

Recap – EBS and Oracle 19c

In September 2019, right before Oracle Open World, we announced the certification of EBS …

AutoUpgrade and Plug In to a CDB – with a single command (and video)

Posted on May 20, 2020 by Mike.Dietrich AutoUpgrade Single-/Multitenant 71

I have to confess, this feature is out and available for quite a while. But only unofficially. AutoUpgrade can upgrade and plug in a non-CDB into a CDB. But it lacked flexibility. And we didn’t test it a lot. Hence, you could find it documented in our Hands-On Lab instructions. And we did this exercise with you already in our sold-out labs at OOW 2019 as well. But since a week and a bit, it is officially supported: AutoUpgrade and Plug In to a CDB – with a single command (and video).

AutoUpgrade and Plug In to a CDB - with a single command (and video)

Photo by William Daigneault on Unsplash

Create

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

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

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 …

Upgrade Testing – Online Clone a PDB to 19c

Posted on March 6, 2020 by Mike.Dietrich Single-/Multitenant Upgrade / Migration 34

In the past I wrote some articles about cloning PDBs to new environments. And I added a post about RELOCATE as well. But I realized that I have no specific blog post about a very typical scenario: Upgrade Testing – Online Clone a PDB to 19c.

Upgrade Testing - Online Clone a PDB to Oracle 19c

Photo by Jørgen Håland on Unsplash

My Setup

I have an Oracle 12.2.0.1 CDB with a PDB, and another Oracle 19.6.0 CDB. I will hot clone the PDB from 12.2.0.1 to the higher version CDB, and then upgrade the PDB.

Upgrade Testing - Online Clone a PDB to Oracle 19c

The motivation to do it this way is to allow testing for the application …

Issues with seed databases, patch bundles and OJVM in 19c

Posted on February 18, 2020 by Mike.Dietrich Flaws and Pitfalls JVM 11

I really rely on people telling me about issues they saw. And in this case, it happened twice within a few days. At OOW London, a customer came after my talk and told me about invalid objects and an incredible long recompilation time. In fact, he had to apply an OJVM patch in order to solve this. When I returned home, Jure commented on the blog about a very similar issue. I spent some time on the weekend to check it out. And I realized: There are issues with prebuilt seed databases and OJVM in 19c.

Issues with seed databases, patch bundles and OJVM in 19c

Photo by Max

The new Oracle 19c Hands-On Lab is available now for download

Posted on February 6, 2020 by Mike.Dietrich Hands-On Lab 0

Wow, this took a long while. Thanks to my team mate, Data Pump Product Manager Bill Beauregard who went through the complex approval process, the new Oracle 19c Hands-On Lab is available now for download. And in addition, I adjusted the instructions on the blog as well.

The new Oracle 19c Hands-On Lab is available now for download

Photo by Kenrick Mills on Unsplash

What you’ll get …

At first, the download is huge. All together, you will download 13 files summing up to 25GB. When you unzip it, you will get an OVA file. Then you will need to import this appliance into Oracle VirtualBox. The lab will …

Upgrade PDBs with RELOCATE – How does it work?

Posted on January 30, 2020 by Mike.Dietrich Single-/Multitenant Upgrade / Migration 14

Today Roy and I received a question from a colleague about the RELOCATE feature in Multitenant. And I’d like to shed some light and this topic a bit more. Upgrade PDBs with RELOCATE – How does it work?

Upgrade PDBs with RELOCATE - How does it work?

Photo by Sebastian Pena Lambarri on Unsplash

RELOCATE and UPGRADE?

At first, it looks very promising to me. RELOCATE uses the HOT CLONE functionality of Multitenant but then relocates the PDB from one to another CDB. You need to fulfill a few important requirements, for instance:

Local Undo must be enabled in both CDBs
- This limits the technique to at least Oracle

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 …

3 PDBs included with Oracle 19c and desupport of non-CDBs with 21c

Posted on September 17, 2019 by Mike.Dietrich Single-/Multitenant 43

It’s Oracle Open World week in San Francisco. and it is time for announcements of course.

3 PDBs included with Oracle 19c and desupport of non-CDBs with 20c

Photo by Aaron Burden on Unsplash

What has been announced?

Today at OOW 2019, Jenny Tsai-Smith and Dominic Giles announced in their talk that the non-CDB architecture will be desupported from Oracle 21c on. But VERY IMPORTANT, from Oracle 19c on you can have 3 user-created pluggable databases of any type without a Multitenant license. As soon as you have need for 4 or more PDBs within one container database, you will need a Multitenant license.

License Guide

You can find the update …

Oracle EBS 12.2 on-prem is now certified with Oracle 19c – and will become a PDB

Posted on September 12, 2019 by Mike.Dietrich E-Business Suite 0

Great news – and I’m just putting the pieces together. Oracle EBS 12.2 on-prem is now certified with Oracle 19c.

Oracle EBS 12.2 on-prem is now certified with Oracle 19c - and will become a PDB

Photo by Charles Forerunner on Unsplash

Plan your upgrade(s)

You can plan your EBS and database upgrades now. I know from discussions at conferences and workshops, that customers felt locked in on older databases releases. As a result, we waived the Extended Support for the database for those who still are on Oracle 11.2.0.4 and 12.1.0.2 as database for an EBS installation.

Please be aware that the certification as of now includes only Linux and SPARC Solaris platforms. …

Database Migration from non-CDB to PDB – Migration with Data Pump

Posted on August 14, 2019 by Mike.Dietrich Data Pump Single-/Multitenant 10

You may have realized that there are a few techniques missing describing how to do a Database Migration from non-CDB to PDB – Migration with Data Pump is one of them. I will explain the most simple approach of going to Single- or Multitenant. It isn’t the coolest – and it isn’t very fast as soon as your database has a significant size. But it is not complex. And it allows you to move even from very old versions directly into an Oracle 19c PDB – regardless of patch levels or source and destination platform.

Database Migration from non-CDB to PDB – Migration with Data Pump

High Level Overview

Endianness change

Database Migration from non-CDB to PDB – The Minimal Downtime Challenge

Posted on August 13, 2019 by Mike.Dietrich Minimal Downtime Single-/Multitenant 6

There are several pitfalls when you plugin a non-CDB into a CDB environment. I’d like to highlight some of them – and show you potential workarounds as well. This is part of a series of blog posts to make your migration from non-CDB to PDB a bit smoother.

Database Migration from non-CDB to PDB – The Minimal Downtime Challenge

When we start to look at a migration from non-CDB to PDB for an important system, regardless of migrating on-prem or to the cloud, reducing the downtime is very important. In this blog post I’d like to highlight the different aspects …

Database Migration from non-CDB to PDB – The Fallback Challenge

Posted on August 5, 2019 by Mike.Dietrich Fallback Single-/Multitenant 2

Photo by Sebastian Grochowicz on Unsplash

Database Migration from non-CDB to PDB – The Fallback Challenge

As I work with customers on upgrades and migrations for a very long time, I know how important a proper fallback is.

When you attempt a migration from a non-CDB to PDB, you need to plan …

Database Migration from non-CDB to PDB – Various Pitfalls

Posted on August 2, 2019 by Mike.Dietrich Flaws and Pitfalls Single-/Multitenant 22

Photo by timJ on Unsplash

Database Migration from non-CDB to PDB – Various Pitfalls

In all the previous blog posts of this series I tried to explain specific pitfalls, and how you can workaround them. This article is meant to collect the “leftovers”, the minor issues and pitfalls which you may not …

Database Migration from non-CDB to PDB – The Patch Level Pitfall

Posted on August 1, 2019 by Mike.Dietrich Flaws and Pitfalls Single-/Multitenant 0

Photo by Piron Guillaume on Unsplash

Database Migration from non-CDB to PDB – The Patch Level Pitfall

When you consolidate on a larger scale, it is very likely that you have different patch levels in your database environments. But when you attempt to plugin a non-CDB into a CDB, you may see …

Database Migration from non-CDB to PDB – The Component Pitfall

Posted on July 31, 2019 by Mike.Dietrich Flaws and Pitfalls Single-/Multitenant 6

Photo by Brett Jordan on Unsplash

The Component Pitfall

With component we mean the database component which you can find in DBA_REGISTRY – or CDB_REGISTRY. When Multitenant became available over 5 years ago, a decision had been made to make all options/components mandatory in a container database. This decision had to …

PDB

Where does the problem start?

When will it happen?

What are we going to talk about?

AutoUpgrade

What is happening before 19.9.0?

Mitigation Patch

AutoUpgrade between two servers

Upgrade and Plugin?

A simple Transportable Tablespace

Recap – EBS and Oracle 19c

Create

Can you?

Your Questions, our Answers for Seminar 3: Multitenant

Another Web Seminar?

My Setup

What you’ll get …

RELOCATE and UPGRADE?

Check with Oracle Database 19.5.0 SE2

What has been announced?

License Guide

Plan your upgrade(s)

High Level Overview

Database Migration from non-CDB to PDB – The Minimal Downtime Challenge

Database Migration from non-CDB to PDB – The Fallback Challenge

Database Migration from non-CDB to PDB – Various Pitfalls

Database Migration from non-CDB to PDB – The Patch Level Pitfall

The Component Pitfall

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Recent Posts

Follow me on Twitter