19c

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

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

Binary patching is slow because of the inventory

The headline of this blog post may sound a bit cryptic: Binary patching is slow because of the inventory. But actually this seems to be one of the main causes when your binary patching gets slower and slower with every patch you apply.

The more you patch, the worse it gets

Well, this is a tough headline. But you may have read my blog posts about my quarterly patching experience. It actually started with the July 2021 RU in my 19c environment when I wrote:

At least in my environment, both checks with the

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

Migrating Flashback Data Archive (FDA) tables

This morning I received an email question from a customer asking whether there is support for the Migrating Flashback Data Archive (FDA) tables in Oracle 19c. And since this is not the first time I received this question, I thought it may be good to have a blog post about it.

What is Flashback Data Archive (FDA)?

Well, google it. Actually I was looking for a link in our documentation but to my surprise I found the usual suspects such as Tim Hall’s excellent oracle-base page – but not much in our own doc …

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

Oracle Fail Safe is desupported in Oracle Database 21c

You may wonder about this message out of the blue. I wrote a blog post about Oracle Fail Safe being deprecated in Oracle 19c a while ago. But a customer recently pointed me to the fact that I didn’t blog about the fact that Oracle Fail Safe is desupported in Oracle Database 21c.

Oracle Fail Safe is desupported in Oracle Database 21c

Photo by Thanos Pal on Unsplash

Deprecated? Desupported?

A very quick recap about what deprecated and desupported mean. In short, deprecated means “we don’t develop something further but it is still fully supported”. Whereas desupported means “it may still work or may be gone, and you …

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

What does datapatch do when you have different components in PDBs?

The last weeks, literally weeks, I have spent a lot of time with several patching topics. And in order to clean up my inbox a bit I will dump the learning into several blog posts. This one today will be about an interesting case I came across when a customer ran into problems with the runtime of datapatch in an ExaCC environment. Hence, today’s topic will be: What does datapatch do when you have different components in PDBs?

Annotation

If you are on 19.16.0 or higher, than you can safely ignore this blog post

Continue reading...

Adding the Oracle 19.14.0 OCW / GI bundle patch to my database home

Actually I planned for a different blog post this morning. But since I have a backlog of unanswered comments accumulated I came across this interesting question from Pedro. He wanted to know how he can patch the OCW component in his database home. So I thought I will show you the process of Adding the Oracle 19.14.0 OCW / GI bundle patch to my database home.

Is this necessary?

That’s a good question for a Monday morning. I think: No, that isn’t necessary for a “Database only” home where you don’t have or …

Continue reading...

Patching all my environments with the October 2021 Patch Bundles

My calendar has no error or NLS conversion issue – I was just way to busy the past two months with seminars. But today a colleague asked me whether my 21.4 install reports a 21.3 Build Label in the trace files. And this reminded me that I should now finally apply the patch bundles from October 2021 to our Hands-On Lab environment. So again, another blog post about Patching all my environments with the October 2021 Patch Bundles.

Patching all my environments with the October 2021 Patch Bundles

Photo by NCI on Unsplash

As usual, an important annotation upfront: I patch in-place due to space issues. But in reality, you …

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

DBMS_OPTIM_BUNDLE and Out-Of-Place Patching

Well, you see, this is most likely my special DBMS_OPTIM_BUNDLE week. And since I receive quite a number of questions, it may be good to discuss here about DBMS_OPTIM_BUNDLE and Out-Of-Place Patching?

DBMS_OPTIM_BUNDLE and Out-Of-Place Patching

Photo by Didssph on Unsplash

Out-of-place Patching

When you patch out-of-place with a new home – which is clearly our recommendation – you may see another tiny pitfall with DBMS_OPTIM_BUNDLE.

When you check DBA_DIRECTORIES, you will find two directories being related to DBMS_OPTIM_BUNDLE.

SQL> select directory_name, directory_path from dba_directories where directory_name like '%OPTIM%'

DIRECTORY_NAME	     DIRECTORY_PATH
-------------------- --------------------------------------------------
DBMS_OPTIM_LOGDIR    /u01/app/oracle/product/19/cfgtoollogs
DBMS_OPTIM_ADMINDIR  /u01/app/oracle/product/19/rdbms/admin

You see the “19” in the …

Continue reading...

DBMS_OPTIM_BUNDLE and disabling another fix

Yes, DBMS_OPTIM_BUNDLE week it is. As I received so many good questions and input after my blog post whether you should enable _fix_controls with DBMS_OPTIM_BUNDLE or not, now I can easily fill the rest of the week with new content. Today it will be about a customer’s question regarding DBMS_OPTIM_BUNDLE and disabling another fix.

Disabling another fix

The setup is pretty simple. Stefan wanted to disable a different fix while he had all fixes from the most recent RU enabled on purpose. Sounds simple but has a dangerous pitfall.

This is what …

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

After patching, Spatial Index creation fails with ORA-13249

Thanks again to Peter Lehmann from T-Systems for highlighting this issue to me. After patching, Spatial Index creation fails with ORA-13249. And Peter’s customer was quite worried. But see what may have caused this, and how we fixed it.

After patching, Spatial Index Creation Fails with ORA-13249

Photo by Bill Oxford on Unsplash

What happened?

Peter patched a system from 19.10.0 to 19.11.0. This database has undergone an upgrade from 12.2.0.1 to 19.7.0 before, then got patched to 19.9.0 before. The database has the Oracle Locator only but no Spatial installed. The patching including datapatch worked fine. All seemed to be good. Until the customer tried to …

Continue reading...

Patching all my environments with the July 2021 Patch Bundles

It’s patching day again. Hurray! Or not. I realize that at patching day, the 19c bundles are all missing. So wrote this blog post a bit after the usual release day. In my case this will include Oracle 19.12.0 RU and the July 2021 RU for Oracle 12.2.0.1. Please find the details about Patching all my environments with the July 2021 Patch Bundles below.

As usual, an important annotation upfront: I patch in-place due to space issues. But in reality, you please patch always out-of-place with a separate home. Please see this blog post

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

UNDO_RETENTION not inherited to PDBs anymore since 19.9.0

Behavior changes introduced via a bug fix may not be something you like a lot. And thanks to Sreedhar from one of our most important customers I learned on the weekend: UNDO_RETENTION not inherited to PDBs anymore since 19.9.0.

UNDO_RETENTION not inherited to PDBs anymore since 19.9.0

Photo by Ben Wicks on Unsplash

What is happening before 19.9.0?

Until Oracle 19.8.0 you could change the UNDO_RETENTION in the CDB$ROOT, and it applied to all PDBs automatically. You may or may not have cared. But there are cases when you’d like to change an undo related parameter in the CDB$ROOT without its propagation into all PDBs.

This behavior …

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

Bug Fixing Support for Oracle 18c ends June 30, 2021

Time flies so quickly. I remember when we had intense discussions with a very large automotive customer whether they should use Oracle 18c, or rather wait for Oracle 19c. They went straight to Oracle 19c. But I know that many customers out there are still on Oracle 18c. So this date coming up in less than 3 weeks is very important for you. Bug Fixing Support for Oracle 18c ends June 30, 2021.

Oracle Database 18c

I quickly checked on my blog. On March 20, 2018 I wrote When will Oracle Database 18c

Continue reading...