Oracle Database 23ai

ora2know Hands-On Workshop: Upgrade to Oracle 19c and 23ai

Let’s kick it off. When the ora2know group started at DOAG conference in Nuernberg in November 2024, we committed ourselves to support them. And this is exactly the reason why I am going to invite you to this unique event in Munich on July 10, 2025. I will run an ora2know Hands-On Workshop: Upgrade to Oracle 19c and 23ai. And you are going to type 🙂 You need to sign up early since we have only a limited number of seats available.

Hands-On-What?

Yes, hands-on. Try it out. Learn from each other. Step left or right, do mistakes, play …

How do find new features in Oracle Release Updates (RUs)?

I know, not everybody is a huge fan of new features in RUs. But how do find new features in Oracle Release Updates (RUs)? Are the listed anywhere? They are, no worries. At least since Oracle Database 19c.

Photo by Jake Weirick on Unsplash

New Features in RUs?

I can already sense that some of you will be tempted to comment and tell me that you don’t like any new features in Oracle Database Release Updates, in short: RUs. But on the other hand there is also something good with it. Rather than waiting for the next full database release …

Should you attempt double-hop Oracle Database upgrades?

Posted on December 13, 2024 by Mike.Dietrich Lifetime Support Policy Oracle Database 19c Oracle Database 23ai Release Schedule 6

A long while ago I wrote a blog post about multiple-hop upgrades. And just recently I received many questions about whether one could skip Oracle Database 19c, and rather move into Oracle Database 23ai directly. So, the ask is: Should you attempt double-hop Oracle Database upgrades?

Should you attempt double-hop Oracle Database upgrades?

Photo by Nik on Unsplash

What is a double-hop or multiple-hop upgrade?

Let me clarify the self-invented term here at first. In every Oracle database release we define the minimum database version you can directly upgrade from. With “upgrade” we refer to using the scripts or tools such as AutoUpgrade. Please …

Virtual Classroom Seminar 21: One-Button Patching

Posted on October 9, 2024 by Mike.Dietrich AutoUpgrade Oracle Database 19c Oracle Database 21c Oracle Database 23ai Patch Recommendation 10

It’s time for our next Virtual Classroom Seminar 21: One-Button Patching – and how it will make the life easier for every DBA with AutoUpgrade. So, this seminar is clearly for you. And we plan to constrain it this time to only 60 minutes with a heavy focus on demos.

Photo by Michael Lock on Unsplash

Date, Time and Registration

Episode 21 of our Virtual Classroom Series will happen on:

October 24, 2024 – 14:00h CET (5:30pm IST – 1:00pm BST – 8am EDT)
Registration Link

Why do YOU have to attend?

Oracle AutoUpgrade has been patching databases for …

Reuse Object IDs in Oracle Database 19c and 23ai

Posted on July 4, 2024 by Mike.Dietrich Behavior Change Best Practice Oracle Database 19c Oracle Database 23ai 12

I love to learn something new every day. And thanks to my Dutch friend, Robert Pastijn, I learned about a limitation of how many objects you can create in an Oracle database. Nothing to worry about, the limit is very high at a little bit over 4.2 billion. But in order to prevent hitting it, we introduced a mechanism to Reuse Object IDs in Oracle Database 19c and 23ai.

Reuse Object IDs in Oracle Database 19c and 23ai

Photo by Rosie Sun on Unsplash

What is the mechanism?

First of all, this is ON and enabled in Oracle Database 23ai by default. But in case you need this …

Oracle Database 23ai is available in the cloud and as Free

Posted on May 2, 2024 by Mike.Dietrich Oracle Database 23ai 23

You may have watched the announcement of Larry Ellison together with our EVP Juan Loiza this evening. And yes, Oracle Database 23ai is available in the cloud and as Free Developer Edition as of now.

Oracle Database 23ai announcement by Larry Ellison and Juan Loiza

Click on the picture to watch the announcement

What are we announcing?

Please see the important links for more information about the recent announcements Larry Ellison and Juan Loiza made today.

Oracle Database 23ai – Overview blog post
This blog post gives you a very detailed overview on the key features, and why it is called Oracle Database 23ai. Find out more about the 300+

Upcoming In-Person Workshops in May 2024 in Copenhagen, Stockholm and Frankfurt

Posted on April 25, 2024 by Mike.Dietrich Oracle Database 23ai Workshop 2

Daniel and I are looking forward to welcome you at one of our upcoming workshops in Copenhagen, Stockholm or Frankfurt. But please register ONLY if you can make it in-person. This is not a virtual event, we don’t stream it. You need to come to one of the locations by yourself.

Upcoming In-Person Workshops in May 2024 in Copenhagen, Stockholm and Frankfurt

Screenshot

Real World Database Upgrade and Migration to Oracle Database 19c and 23c

We will cover almost everything from the Release Strategy to Patching Best Practices, the quickest path into Oracle Multitenant, AutoUpgrade options, Performance Stability and of course Oracle Database 23c New Features.

Join us for a full …

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 …

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

Oracle Database 23ai

ora2know Hands-On Workshop: Upgrade to Oracle 19c and 23ai

Hands-On-What?

How do find new features in Oracle Release Updates (RUs)?

New Features in RUs?

Should you attempt double-hop Oracle Database upgrades?

What is a double-hop or multiple-hop upgrade?

Virtual Classroom Seminar 21: One-Button Patching

Date, Time and Registration

Why do YOU have to attend?

Reuse Object IDs in Oracle Database 19c and 23ai

What is the mechanism?

Upcoming In-Person Workshops in May 2024 in Copenhagen, Stockholm and Frankfurt

Real World Database Upgrade and Migration to Oracle Database 19c and 23c

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

Time Zone Upgrade?

Oracle Database 23c Free Developer Release is available

Where can you download it?

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts