upgrade

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...

Oracle Database 12.2.0.1 – End of Support and Patch Bundles

This will be a short blog post but since I received a number of messages yesterday after I published my usual Patching all my environments with the April 2022 Patch Bundles blog post I need to clarify a few things regarding Oracle Database 12.2.0.1 – End of Support and Patch Bundles.

Premier Support for Oracle 12.2.0.1

If you remember this, the Premier Support period for Oracle 12.2.0.1 ended on November 30, 2020.

Limited Error Correction Support for Oracle 12.2.0.1

Since many of you were still on Oracle 12.2.0.1 when the end of Premier Support …

Continue reading...

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

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.

 

Oracle Database 11g?

Continue reading...

AutoUpgrade 2.0 has been released – and got reuploaded

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.

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 …

Continue reading...

Oracle Canada: No Escape – Why you need to upgrade to Oracle 19c

No Escape Why you need to upgrade to Oracle 19c


Oracle Database 21c is now available but Oracle Database 19c remains the current “Long Term Support Release” and you can have it running both onpremises and in the cloud, offering the best performance, scalability, reliability and security for all your operational, analytical and mixed workloads.


Join our webinar with Mike Dietrich, Distinguished Product Manager for Database Upgrade, Migrations and Patching.

You will learn why you need to upgrade NOW to Oracle Database 19c, and what’s your path to successful upgrades and migrations. Furthermore, the

Continue reading...

Migrating Very Large Databases – Virtual Classroom Seminar 12

Register here:

https://go.oracle.com/LP=114938?elqCampaignId=302203

 

Webinar Details

Date: December 9, 2021

Start Time: 09:00 GMT / 10:00 CET / 11:00 EET / 13:00 GST

Duration: 120 mins

Webinar Description

There is no clear definition what “large” means. But we think about database of many Terabytes and more. Large databases require different considerations. Often there is not much spare space available. Our focus is to show and demonstrate how to migrate really large databases as quickly as possible following our dogma of “the more simple the better”. But if downtime restrictions come into play, we may need to chose more complex solutions.

Continue reading...

Virtual Classroom Seminar 12: Migrating Very Large Databases on Dec 9, 2021

It looks to me that every possible event in 2021 happens in October/November/December 2021. No complaint from my side – but just in case you wonder about so little update activity on our blogs since weeks. We are just so busy in delivering virtual seminars. Which is good – but it requires lots of effort on our side as we want to deliver decent quality and real tech content. And now, since the year is almost at its end, it is time for our final Virtual Classroom Seminar 12: Migrating Very Large Databases on Dec 9, 2021 this year.

Virtual Classroom Seminar 12: Migrating Very Large Databases  on Dec 9, 2021

Photo

Continue reading...

UKOUG21: Huh, it is fixed in Oracle 23c? Insights …

https://ukoug.org/page/mikedietrichtogether21

In this talk we will give rare insights into how Oracle Database Development works.

Have you ever asked yourself how “Development” at Oracle , 19cgeworks? And why regression test take hours and not only minutes?

Or why Support tells you, “it will be fixed in 23c” even though there is no 23c available yet?

It’s pure magic – and we will give some insights!

“Have you every heard from Oracle Support “”It will be fixed in 21c or 23c””? And wondered if you should upgrade now, and how you should upgrade when the release is not there yet?

In …

Continue reading...

How Low Can You Go? Zero Downtime Operations on Oct 21, 2021

No idea what you should do this week’s Thursday morning at 10:00h CET? No worries, I know what you should do. You’ll attend our 10th Virtual Classroom Seminar: How Low Can You Go? Zero Downtime Operations on Oct 21, 2021, part of our Upgrade to Oracle Database 19c series.

How Low Can You Go? Zero Downtime Operations

Virtual Classroom Seminars?

It will be the 10th Episode of our Virtual Classroom Seminar series. If you attend one or many before, you know that we don’t do marketing but transport only tech content. And always things we tried out by ourselves beforehand or used them already in many …

Continue reading...

Upgrading a PDB with JVM may result in ORA-7445 joevm_invokevirtual

As you know, this blog is also my brain dump about Oracle topics. Since this one happened yesterday, mostly at night with the help of my team mates and the Java team, I’d like to write it down into this blog post: Upgrading a PDB with Java may result in ORA-7445 joevm_invokevirtual() as it is still fresh and may affect you as well. If you don’t have PDBs, if you don’t have Java (or JVM) in it or if you upgraded already to Oracle Database 19c, you can stop reading now.

What

Continue reading...

Which releases allow you to upgrade to Oracle Database 21c?

As I wrote before, the release you should upgrade to is clearly Oracle Database 19c. Unless you need to use one of the new features in Oracle 21c. But as you have seen in the past, some of them get backported to 19c as well. Still, in case you can’t resists or you love upgrades as much as we do, the question may be: Which releases allow you to upgrade to Oracle Database 21c?

Upgrade-supported Releases

The Database Upgrade Guide for Oracle 21c is your best friend here. Right at the beginning in the first chapter you will find this …

Continue reading...

Pitfall: Upgrade to 21c fails when ORDIM is present but no SDO

You may have read my previous blog post about Upgrading a non-CDB to Oracle Database 21c. And I referred to a potential Pitfall: Upgrade to 21c fails when ORDIM is present but no SDO. In this blog post I would like to explain how to avoid this pitfall beforehand and explain what needs to be done.

Pitfall: Upgrade to 21c fails when ORDIM is present but no SDO

Photo by Sara Codair on Unsplash

What’s the problem?

In my previous blog post I showed you the ideal and normal way. But during my tests I came across an issue I was not aware of – and I simply had no …

Continue reading...

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

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.

Upgrading a non-CDB 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 …

Continue reading...

Ascend Conference 2021 – Database Upgrade – From Zero to Hero

My Session:

https://connect.jujama.com/ClientAgenda/AgendaDetails.aspx?ConferenceId=ZgVXJlUwt%2fg%3d&nid=kK9XpUmr6Qc%3d&Speaker=o8%2bWP90WRsMB%2b14m%2fJU9Ug%3d%3d&Tracks=GTSzrqvq8gE%3d&Date=dpiTpYFVuKE%3d&SubConference=GTSzrqvq8gE%3d&ShowAllDetailsInList=GTSzrqvq8gE%3d

Back to Basics: Database Upgrade – From Zero to Hero
Wednesday, August 18, 2021 10:15 AM – 11:00 AM 
Diplomat Ballroom 1
You never did a database upgrade? Or you did one but many years ago with a strange GUI tool? No worries – in 45 minutes you’ll get to see and hear everything you need to know to complete successful databases upgrades. You don’t have to become an expert as upgrades can be very simple. AutoUpgrade will be your vehicle – and you can do dozens and hundreds of upgrades fully unattended. We will guide you
Continue reading...

Should you enable _fix_controls with DBMS_OPTIM_BUNDLE?

Today, Paul mailed me asking a question we internally discussed many times in the past weeks: Should you enable _fix_controls with DBMS_OPTIM_BUNDLE? And there is no easy simple answer. But I can give a recommendation based on my experience from many projects.

DBMS_OPTIM_BUNDLE – a quick recap

Just in case you haven’t dealt with DBMS_OPTIM_BUNDLE recently, here is a quick recap.

With below procedure, you can list the available potentially behavior changing optimizer fixes in the current patch bundle – and you can turn them on or off at will:

SQL> set serveroutput on;
Continue reading...

New version of AutoUpgrade (21.2) is available for download

As we often tell you, our Upgrade Development team is working hard to ensure an agile release cycle for AutoUpgrade. And the New version of AutoUpgrade (21.2) is available for download.

How to download?

As usual, you can (and should) always download the most recent version of AutoUpgrade from this MOS Note: 2485457.1. Usually the tool gets refreshed every 6-8 weeks. And the version you will download is guaranteed newer than the one you could get on disk.

New version of AutoUpgrade (21.2) is available for download

The fact the tool has a 21c versioning does not affect 19c upgrades. There …

Continue reading...

aioug Webinar Series July 2021: Database Upgrade and Migrations

Many people on the northern hemisphere will escape during July into the summer holidays. But we won’t. Instead, thanks to Sai Penumuru, we will give seven webinars for the aioug. And we are looking forward to talk to you soon at the aioug Webinar Series July 2021: Database Upgrade and Migrations.

aioug Webinar Series July 2021: Database Upgrade and Migrations

When will it happen?

This morning I looked into my calendar. And I realized: Wow, July 2021 is just a few days away. Roy will start with the first session on Friday, July 2. And then myself, Rodrigo, Daniel, Fred and Bill will …

Continue reading...

Upgrade to Oracle 19c on Exadata with AutoUpgrade

This will be a short but very important blog post for those of you with Exadata systems. Then you should Upgrade to Oracle 19c on Exadata with AutoUpgrade.

Why is this important?

Until a week ago, the database upgrade MyOracle Support (MOS) note showed the process using the DBUA. And we had plenty of customers asking us why AutoUpgrade isn’t mentioned there. Our team worked already with some of you, and we knew that AutoUpgrade works perfectly fine and takes over some manual actions.

But our MAA team wanted a perfect solution. They …

Continue reading...

Welcome onboard at Oracle: Rodrigo Jorge

We are thrilled to announce that as of June 7, 2021 we have a new member in our Product Management team: Rodrigo Jorge joins our group as Product Manager for Database Cloud Migrations, Upgrade and Patching. Many of you may know Rodrigo already. He “was” an Oracle ACE Director until June 6, presented at many conferences and user group events – and he has an excellent technical blog. We are really excited to welcome Rodrigo at Oracle.

Who is Rodrigo?

Rodrigo is joining us from Accenture / Enkitec. He’s very well known in
Continue reading...

Unplug / Plug / Upgrade with AutoUpgrade

When we launched AutoUpgrade, it could upgrade non-CDBs and CDBs with all PDBs. Soon after, it learned to upgrade a non-CDB and plug it into an existing CDB as a new PDB. And then, as next step, we added Unplug / Plug / Upgrade with AutoUpgrade. In this case you have a PDB (or hopefully more than one), and you’d like to upgrade one or many PDBs by moving them to a new CDB with a higher database version.

Test Setup

As test setup I use our Hands-On Lab.

I will …

Continue reading...

Some very important MOS Notes when you upgrade and patch

Today, I would like to publish only a short blog post with some hints to MyOracle Support (MOS) notes we find quite helpful. The idea of all these notes I will list below is to help you finding the right patches before you upgrade or patch to Oracle 19c. So see our collection of Some very important MOS Notes when you upgrade and patch below.

Why do you need patch bundles?

At first, it is always our recommendation to upgrade to the most recent Release Update (RU). This is currently Oracle 19.11.0 while I’m …

Continue reading...

Messaging Gateway – Upgrade can’t find mgwu122.sql

Thanks to Christian Ballweg from Optiz Consulting who brought this issue to my attention. I haven’t seen it before since I haven’t installed it but you may encounter this if you have the Messaging Gateway – Upgrade can’t find mgwu122.sql.

What is the Messaging Gateway?

Actually I steal this from the documentation:

Messaging Gateway enables communication between applications based on non-Oracle messaging systems and Oracle Database Advanced Queuing.

Oracle Database Advanced Queuing provides propagation between two Oracle Database Advanced Queuing queues to enable e-business (HTTP through IDAP). Messaging Gateway extends

Continue reading...