23c

New AutoUpgrade Tool is available in March 2024

Posted on March 19, 2024 by Mike.Dietrich AutoUpgrade 58

It has been a longer while – but the Upgrade Dev team worked very hard. And finally, the new AutoUpgrade Tool is available in March 2024. And it brings a ton of new enhancements and features. Some of them, for instance the windows services support, were awaited by you for a long time. Still, there’s much more to talk about.

Photo by Sergey Shmidt on Unsplash

Download the newest version of AutoUpgrade

As usual, you can download it from MOS Note:2485457.1 – Download AutoUpgrade. And when you check the version, you already find some of the new …

Oracle Cloud World 2024 in London

Posted on March 7, 2024 by Mike.Dietrich OCW OOW Workshop 0

Next week it’s Oracle Cloud World 2024 in London. And I hope to see you there. It is a perfect spot to get the latest tech updates but also to meet and synch and discuss.

Not registered yet?

Registration to Oracle Cloud World 2024 in London on March 14, 2024

In addition, there is a DevLive event the day before with about 40 separate sessions.

Upgrade to Oracle Database 23c talk?

Would love to see you there. But certainly there are so many other great sessions. Check out the session catalog, and choose the ones you are the …

Virtual Classroom Seminar 18: XTTS to the Extreme – Video and Slides and more

Posted on March 4, 2024 by Mike.Dietrich Transportable Workshop 2

Thanks for tuning in on Feb 22, 2024 into our Virtual Classroom Seminar 18: XTTS to the Extreme – Video and Slides and more are now available. And thanks for being such a great audience with so many questions.

Photo by Venti Views on Unsplash

Video Recording

As usual, you can access the full recording here.

Please find the entire contents section below in the video’s description. You don’t need to watch the entire seminar, you can also access only the sections you are interested in, or skip sections which are not on your focus.

00:08 – Welcome to

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 …

Monitor progress of Oracle Data Pump impdp

Posted on October 26, 2023 by Mike.Dietrich Data Pump 11

This blog post is a quick brain dump. I realized that I have so many “blog posts to write” that I need to dump the ideas or information much quicker. So, feel free to comment and correct. These queries may be useful when you run a larger import, and you would like to monitor progress of Oracle Data Pump impdp.

Monitor progress of Oracle Data Pump impdp

Photo by George Vidos on Unsplash

Monitor Data Pump progress during impdp

To monitor the progress of Data Pump during impdp you can use the following queries.

What object types are left?

select unique object_type_seqno, object_type
from system.sys_import_full_01
where

In-person Upgrade Workshops in Brussels and Utrecht

Posted on September 27, 2023 by Mike.Dietrich Workshop 11

For a long time we haven’t met in person I guess. But I know very well that the audiences in Brussels, Belgium, and Utrecht, Netherlands, are very active. And it’s actually the best to meet for In-person Upgrade Workshops in Brussels and Utrecht in October – not via zoom 🙂 And this is your change to sign up if you haven’t already.

In-person Upgrade Workshops in Brussels and Utrecht

Photo by Chris Lawton on Unsplash

When will it happen?

Very simple – and you are just one click away:

Both events …

Your Upgrade / Migration / Patching Guide for OCW23

Posted on September 18, 2023 by Mike.Dietrich OOW 8

Thanks for using this blog post. It will be your Upgrade / Migration / Patching Guide for OCW23. You will find the slide decks to download, the coming talks, the HOL as well as the survey links and other important sources. We wil update it every day throughout the conference. If you have questions, please use the “Comment” option below the blog post. And we won’t post content BEFORE the session but instead AFTER the sessions.

Your Upgrade / Migration / Patching Guide for OCW23

All you need, day by day

Please find – grouped day by day – each of our talks with the survey links and …

Going to India: Oracle Community Yatra (OCYatra) 2023

Posted on July 17, 2023 by Mike.Dietrich Workshop 2

One year ago I’ve had the pleasure to visit India for the YATRA 2022 tour. I couldn’t do all 6 tour stops and had to skip Delhi and Hyderabad. But this year I will be there for all 6 cities. So I am going to India: Oracle Community Yatra (OCYatra) 2023. And I hope to see YOU there, will I?

Going to India: Oracle Community Yatra (OCYatra) 2023

Why you need to get your ticket NOW?

I guess, most of you in the area have tickets already. Just in case if you didn’t purchase one yet, it’s time to do so. It is not expensive but be …

June 2023 version of AutoUpgrade is available

Posted on July 3, 2023 by Mike.Dietrich AutoUpgrade 2

It’s time to exchange your AutoUpgrade tools with the most recent one when you plan to do upgrades or use it for patching already. The June 2023 version of AutoUpgrade is available for download from MOS Note:2485457.1. And in case you are still using DBUA for unknown reasons, please read this blog post, too.

June 2023 version of AutoUpgrade is available

Photo by Jason Hudson on Unsplash

Where to download?

As usual, please download the newest version of AutoUpgrade via MOS Note:2485457.1 – Download AutoUpgrade.

What does this version improve?

New Features

BUG-34010941 – Incorparated the Health check package to identify database dictionary inconsistencies

DBUA Deprecation and future Desupport in Oracle Database 23c

Posted on June 21, 2023 by Mike.Dietrich AutoUpgrade DBUA Deprecated / Desupported 16

Daniel pointed me to Tim Hall’s blog post about deprecated and desupported features in Oracle Database 23c. And his first bullet point mentioned is the DBUA Deprecation and future Desupport in Oracle Database 23c. Since Daniel and I agree that this needs a bit more explanation, we would like to share more background information with you.

Photo by Ajeet Mestry on Unsplash

Deprecated vs Desupport?

At first, let me refresh an old topic. What does deprecated mean, and what is the difference to desupport? A long while ago I wrote this blog post about it, and nothing …

Virtual Classroom Seminar 17: From SR to Patch

Posted on June 20, 2023 by Mike.Dietrich Workshop 6

This is your chance to sign up to our Virtual Classroom Seminar 17: From SR to Patch – Insights into the Oracle Database Development process. It will happen Thursday, June 22 at 16:00h CET. As usual, this is free of charge. It is your unique chance to get insights into our database development process. We lift the curtain for a bit, and tell you what’s happening behind the scenes. Don’t miss this chance.

Photo by Steven Van Elk on Unsplash

Why and how register?

This is the seminar telling you what happens behind the scenes. We will tell …

Zero Downtime Upgrade of Timezone Data in Oracle 21c and 23c?

Posted on June 6, 2023 by Mike.Dietrich Best Practice Oracle Database 21c Oracle Database 23ai Time Zone - DST 6

There is a feature in Oracle Database 21c I planned to write about for a very long time: Zero Downtime Upgrade of Timezone Data in Oracle 21c and 23c. This sounds very promising – but let us take a closer look together in this blog post.

Photo by Bruno Figueiredo on Unsplash

Time Zone Upgrade?

There is of course an ongoing discussion whether and when you should upgrade the DST version of your database to a current value. Since we all live in a more and more globalized world, this topic becomes more and more important. Even more important …

Virtual Classroom Seminar 16: Release and Patching Strategy for Oracle 19c and 23c

Posted on May 8, 2023 by Mike.Dietrich Patch Recommendation Release Schedule Workshop 9

There are just two days left to sign up for our Virtual Classroom Seminar 16: Release and Patching Strategy for Oracle 19c and 23c. We’ll talk to you on Wednesday, May 10 at 16:00h CET.

Photo by JESHOOTS.COM on Unsplash

What’s the topic?

We’ll try to cover everything for your best release and patching strategy with Oracle Database 19c of course, but also moving forward to Oracle Database 23c. Our big focus will be several aspects of patching. You’ll hear us talking not only about standard database patching but especially about patching in RAC environments.

We’ll put together a …

Oracle Database World in London – THE event in April 2023

Posted on April 5, 2023 by Mike.Dietrich Conference Workshop 7

You may have heard or seen – or even registered already – for the regional Oracle Cloud World in London on April 19, 2023 already. But were you aware that the “event to be at” happens just the next day on April 20? It will be Oracle Database World in London – THE event in April 2023.

When and where will it happen?

April 20, 2023, a Thursday will be the day to mark in your calendar. We’ll meet you at Oracle Database World, the regional database event to be at in London this year at the …

Oracle Database 23c Free Developer Release is available

Posted on April 4, 2023 by Mike.Dietrich Oracle Database 23ai 5

Yesterday at the regional Oracle Cloud World (OCW) in Singapore it got announced: Oracle Database 23c Free Developer Release is available for download from now on.

Oracle Database 23c Free Developer Release is available

Where can you download it?

That is most likely the most important link you are looking for. You can download the Oracle Database 23c Free Developer Release from here: Download Oracle Database 23c Free Developer Release. You will download an RPM.

Please note that Oracle Database 23c on Linux requires your OS to be either OL8 or RHEL8.

You can find the preinstall package here:

Release 8

And my colleague Gerald Venzl

March 2023 release of AutoUpgrade is available

Posted on March 1, 2023 by Mike.Dietrich AutoUpgrade 17

It’s download time again. So please refresh the AutoUpgrade release you are using with the new one since the March 2023 release of AutoUpgrade is available now for download.

March 2023 release of AutoUpgrade is available

Photo by Mario von Rotz on Unsplash

Where to download?

As usual, please download the newest version of AutoUpgrade via MOS Note:2485457.1 – Download AutoUpgrade.

What does this version improve?

A lot.

Really, a lot of things got improved.

You’ll find the change.log for tracking purposes at the bottom of the note. I’d wish everybody would do such a transparent change tracking as the AutoUpgrade team does. This makes …

RUs contain now all available DST patches

Posted on January 19, 2023 by Mike.Dietrich Patch Recommendation Time Zone - DST 14

At first, Happy New Year everybody. There was silence on the blog for some weeks but I took an extended longer time off. Well, and once you return, there are some emails in your inbox which need some work. You’ll see several new blog posts getting published in the coming days. Back to normal, yesterday night RU 19.18.0 among other patch bundles has been released. And there’s a huge fantastic surprise in it: RUs contain now all available DST patches.

RUs contain now all available DST patches

Photo by Lukas Blazek on Unsplash

What’s the story?

There are some good news. We discussed this internally …

Silent ORA-918 behavior change in RU 19.17.0 and newer

Posted on October 27, 2022 by Mike.Dietrich Behavior Change Patch Recommendation 27

I think we have the best customers out there. It is incredible what some people find. We would be lost without you, and this blog would contain only a fraction of the information we can share with you. In this case let me explain the silent ORA-918 behavior change in RU 19.17.0 and newer. And all credits go to Peter Lehmann from Deutsche Telekom who found this issue only a few days after we released 19.17.0.

Silent ORA-918 behavior change in RU 19.17.0 and newer

Photo by Drew Farwell on Unsplash

What is happening?

Peter shared an awesome and simple test case with me. A query with ambiguously defined …

Why you simply can’t upgrade from Oracle 11g or 12c to Oracle 23c

Posted on August 1, 2022 by Mike.Dietrich Release Schedule 5

It’s time for a Monday morning rant. I receive more and more questions which all start similar. “My customer is on Oracle 11g and/or 12c, and want to know whether the next long term support release …“. Now let me clarify Why you simply can’t upgrade from Oracle 11g or 12c to Oracle 23c. And why you MUST upgrade to Oracle Database 19c.

Why you simply can't upgrade from Oracle 11g or 12c to Oracle 23c

Photo by SpaceX on Unsplash

What is the intention?

After a lot of discussions across many regions, especially in JAPAC during the past weeks I realized that there is a reason for all …

Why you can’t stay on Oracle Database 11g forever

Posted on April 6, 2022 by Mike.Dietrich Release Schedule 24

Oracle Database 11g? In 2022? Yes, I know – and you know too – there are Oracle 11g databases out there in production. And blindly I’d say: Too many. Of course, we are the “upgrade guys” trying to convince you to move to Oracle Database 19c. And I bet, for each of your 11g databases there’s a valid and legit reason why they haven’t upgraded yet. But there is one often neglected technical reason Why you can’t stay on Oracle Database 11g forever. So let me explain this below.

Photo by Kristoffer Darj on Unsplash

Oracle Database 11g?

AutoUpgrade 2.0 has been released – and got reuploaded

Posted on March 25, 2022 by Mike.Dietrich AutoUpgrade 42

Many of you have used AutoUpgrade for your database upgrades already. Just a few days ago I received some almost enthusiastic comments which made me very very happy. And if you thought it can’t get any better, no worries: AutoUpgrade 2.0 has been released – and got reuploaded.

AutoUpgrade 2.0 has been released - and got reuploaded

Photo by Graham Pengelly on Unsplash

Why AutoUpgrade 2.0?

As you know, we don’t do marketing but just talk tech. But you may have also recognized that we slowed down in our agile release cycle for AutoUpgrade. The simple reason for this long period of silence was that we’ve had a …

23c

Download the newest version of AutoUpgrade

Not registered yet?

Upgrade to Oracle Database 23c talk?

Video Recording

When?

Monitor Data Pump progress during impdp

What object types are left?

When will it happen?

All you need, day by day

Why you need to get your ticket NOW?

Where to download?

What does this version improve?

New Features

Deprecated vs Desupport?

Why and how register?

Time Zone Upgrade?

What’s the topic?

When and where will it happen?

Where can you download it?

Where to download?

What does this version improve?

What’s the story?

What is happening?

What is the intention?

Oracle Database 11g?

Why AutoUpgrade 2.0?

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Recent Posts