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...
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...
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.
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...
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...
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 184.108.40.206 to 19c with Label Security Policies. All other readers may simply ignore this blog post.
You are using Oracle Label Security, and …Continue reading...
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:
… Continue reading...
At least in my environment, both checks with the
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.
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
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 220.127.116.11 – End of Support and Patch Bundles.
Premier Support for Oracle 18.104.22.168
If you remember this, the Premier Support period for Oracle 22.214.171.124 ended on November 30, 2020.
Limited Error Correction Support for Oracle 126.96.36.199
Since many of you were still on Oracle 188.8.131.52 when the end of Premier Support …Continue reading...
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...
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...
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.
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...
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...
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?
If you are on 19.16.0 or higher, than you can safely ignore this blog post …Continue reading...
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...
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.
As usual, an important annotation upfront: I patch in-place due to space issues. But in reality, you …Continue reading...
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.
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...
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?
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...
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...
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...
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.
Peter patched a system from 19.10.0 to 19.11.0. This database has undergone an upgrade from 184.108.40.206 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...
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 220.127.116.11. 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...
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.
The fact the tool has a 21c versioning does not affect 19c upgrades. There …Continue reading...
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.
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...
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.
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...
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...