upgrade

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.

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 to minimize the impact on factory operations. Oracle ACS and the RAC PM team …

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

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

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

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

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

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