upgrade

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

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.

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 …

Continue reading...

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

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 …

Continue reading...

New AutoUpgrade Tool is available in March 2024

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.

 

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 …

Continue reading...

Oracle Cloud World 2024 in London

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.

OCW 2024 London

Not registered yet?

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 …

Continue reading...

IMPORTANT: Location change for the Warsaw workshop

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.

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 …

Continue reading...

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

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.

When?

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

Continue reading...

DOAG 2023 Conference – our talks this year

Time flies so quickly – and I guess I wrote this phrase already plenty of times on the blog. It is already November, and just a few weeks until Christmas. And this year, DOAG conference in Nuernberg is again in November – which means: next week. So, let me give you a quick overview for DOAG 2023 Conference – our talks this year.

When, who, where?

At first, DOAG 2023 will happen from November 21-24, 2023 at the usual superb location in Nuernberg. You find all the details on the DOAG webpage. …

Continue reading...

September 2023 version of AutoUpgrade is available

It’s time again – and the new September 2023 version of AutoUpgrade is available for download to you.

Where to download it?

As usual, the MOS Note: 2485457.1 offers you access to the new release, and to the previous versions of the tool as well. This new version will show the following version information:

java -jar autoupgrade.jar -version

build.version 23.4.230921
build.date 2023/09/21 14:43:05 -0400
build.hash 165be072
build.hash_date 2023/09/21 13:05:52 -0400
build.supported_target_versions 12.2,18,19,21
build.type production
build.label (HEAD, tag: v23.4, origin/stable_devel, stable_devel)

This version will be also included in the Jan 2024 RU, 19.22.0, but not …

Continue reading...

In-person Upgrade Workshops in Brussels and Utrecht

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.

When will it happen?

Very simple – and you are just one click away:

Both events …

Continue reading...

Your Upgrade / Migration / Patching Guide for OCW23

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 …

Continue reading...

Your UPGRADE and MIGRATION program at OCW23

Are you coming to Oracle Cloud World 2023 and to Oracle DatabaseWorld at CloudWorld? Then you should read on since this may be your upgrade and migration program at OCW23. We are desperately looking forward to see and meet you in 2 weeks in Las Vegas. Don’t forget to add the talks you’d like to visit to your schedule as some of the rooms have limited capacity. And at least one of our labs is already sold out.

https://www.oracle.com/database/upgrades/#rc30p2

Who’s speaking and HOL’ing?

Speakers and your lab hosts will be:

  • Roy Swonger
  • Mike Dietrich
  • Daniel Overby Hansen
  • Rodrigo Jorge
Continue reading...

Going to India: Oracle Community Yatra (OCYatra) 2023

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 …

Continue reading...

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

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.

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 …

Continue reading...

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 …

Continue reading...

Oracle Database World in London – THE event in April 2023

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.

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 …

Continue reading...

March 2023 release of AutoUpgrade is available

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.

Where to download?

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

March 2023 release of AutoUpgrade is available

 

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 …

Continue reading...

A change in Oracle 12.2 and 19c with MV Refresh Stats Collection

It’s not easy for me to put the topic into a searchable title for this blog post. The feature or change I will write about today came in actually with Oracle Database 12.2.0.1. But since many of you will move directly from Oracle 11.2.0.4 or 12.1.0.2 to 19c, the Long Term Support release, it may affect you as well. So let me explain a change in Oracle 12.2 and 19c with MV Refresh Stats Collection.

 

A customer story

The local Support team asked me a few weeks ago whether I have heard …

Continue reading...

OCW 2022 – Your Upgrade / Migration / Patching Track to Success

Will you come to Oracle Cloud World (tcfkaOOW = the conference formerly known as Oracle Open World) 2022 in Las Vegas in the week from October 17-20, 2022? Then we hope to see you there. And we certainly hope to meet you. So in case you are looking for our technical talks and sessions at OCW 2022 – Your Upgrade / Migration / Patching Track to Success.

OCW 2022 – Your Upgrade / Migration / Patching Track to Success

 

Your Upgrade / Migration / Patching Track at OCW2022

As usual our promise stands.

Zero marketing. Just pure tech.

And we our proud to have lots of real

Continue reading...

Oracle Cloud World 2022 – Database Upgrade and Patching Labs

Oh … it’s just a few weeks left until Oracle Cloud World 2022 will start on Oct 17, 2022 in Las Vegas. If you have some final doubts whether you should go or not, let me tell you that it’s like Oracle Open World just under a different name. And in a different place. But with the same cool people and many great talks. Take the chance to meet the developers, their managers and the product managers behind the features you daily use – or miss. We’ll be there – and this is YOUR chance now to sign up for …

Continue reading...

Intel uses AutoUpgrade to upgrade from Oracle 11.2.0.4 to 19c

Funny, I was traveling recently with RAC PM Anil Nair – but he forgot to tell me that this cool story has been published just a few days before we took of for YATRA 2022 to India: Intel uses AutoUpgrade to upgrade from Oracle 11.2.0.4 to 19c. I know that Anil is simply so busy – and my surprise was huge.

What’s the story?

Gagan Singh, Enterprise Architect at Intel, shared it with me last week. The goal was to upgrade from Oracle 11.2.0.4 to Oracle 19c with the least amount of downtime

Continue reading...

Certifying an application on a specific RU-only is wrong

Well, there are still 80+ comments I need to answer and reply to on the blog. So please be patient – nothing gets deleted or ignored. But it happens that a topic crosses my inbox, and I need to blog about it right now. Today, it is a case where a customer asked me for advice, and mentioned on the side that they are going to 19.6.0 in OCI. In this relation I’d like to explain why Certifying an application on a specific RU- only is wrong.

What’s the story?

At first, …

Continue reading...

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

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 …

Continue reading...

OC YATRA 2022 visiting 6 cities in India in July 2022

Yes, you read correctly in my blog post’s title: OC YATRA 2022 visiting 6 cities in India in July 2022. And it is already July. Just a few days to sign up – if you haven’t already. So please register here: https://www.aioug.org/ocyatra-2022

Just pick one of the six cities from the agenda page:

  • 23 July 2022, Saturday – Chennai
  • 24 July 2022, Sunday – Bengaluru
  • 26 July 2022, Tuesday – Mumbai
  • 28 July 2022, Thursday – Pune
  • 30 July 2022, Saturday – Delhi
  • 31 July 2022, Sunday – Hyderabad

And register yourself.

Please check out the awesome agenda with …

Continue reading...

Upgrade from 11.2.0.4 to 19c with Label Security Policies

I remember, I have a blog. Forgive me that I don’t write a lot at the moment even though I still have a long queue of “future posts to write”. It is just too busy, and I was away for almost two full weeks in June as well. But let me briefly drop information on an issue I learned about recently. It just affects your when Upgrade from 11.2.0.4 to 19c with Label Security Policies. All other readers may simply ignore this blog post.

Upgrade from 11.2.0.4 to 19c with Label Security Policies

Photo by Erik Mclean on Unsplash

What happens?

You are using Oracle Label Security, and …

Continue reading...

Virtual Classroom Seminar #14: AutoUpgrade 2.0 on May 5, 2022

If you finally want to see all the cool new features of AutoUpgrade 2.0 (the 2.0 is just a marker we use to say: We improved it significantly!), the please sign up to Virtual Classroom Seminar #14: AutoUpgrade 2.0 on May 5, 2022.

Virtual Classroom Seminar #14: AutoUpgrade 2.0 on May 5, 2022

Photo by Alex Knight on Unsplash

What are we going to talk about?

The development team invested a lot of resources to implement some of the most wanted features in AutoUpgrade. Spoiler: One feature is still missing but will be released very soon. In this Thursday’s Virtual Classroom Seminar we will talk about:

  • PDB and non-CDB
Continue reading...