Oracle

Oracle Cloud World 2022 – Recap and Slides

This was a wonderful but very strenuous week, no doubt. Oracle Cloud World (OCW) 2022 happened in Las Vegas. New name, new city. And even though many agreed to prefer San Francisco with an Oracle Open World instead having such an event in Sin City, there were a lot of great things happening. So let me start my personal summary here, the Oracle Cloud World 2022 – Recap and Slides.

Oracle Cloud World 2022 - Recap and Slides

Our labs and talks

It was amazing to see you all in our 4 sessions, 4 labs and 2 lightning talks. Since the registration process was a bit …

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

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

How to speed up your database and GI patching

Several of you mailed me already and commented. And I know that I promised this blog post for weeks, if not longer. So let me try to explain How to speed up your database and GI patching. Since this blog post has a longer history, I’d say far over 6 months, it will be a bit longer than the usual posts. At when I started writing it, I decided to split it up into several pieces to make it more digestible but also to allow easier finding of certain topics. I hope it may help easing some recent patching …

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

Virtual Classroom Seminar 13: Data Pump Extreme – Deep Dive with Development

We worked very hard in the past weeks to compile our newest Virtual Classroom Seminar 13: Data Pump Extreme – Deep Dive with Development for you. Now it’s time to sign up for Thursday, March 3, 2022.

Virtual Classroom Seminar 13: Data Pump Extreme - Deep Dive with Development

When will it happen?

Our 13th Virtual Classroom Seminar will happen this Thursday, March 3, 2022 at a hopefully convenient time for you:

14:00h CET – 13:00 BST – 10 a.m. EST – 7 a.m. PST – 20:00h IST

As usual, we will be available to all your Data Pump questions throughout the entire seminar. Just use the QA option of the zoom …

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

How to get access to download older Oracle versions?

Today a friend asked me whether I know where to download Oracle 10g. Not a typo where I mixed 9 and 0 on my keyboard. So what if … How to get access to download older Oracle versions?

What’s on oracle.com and eDelivery

In the Software Delivery Cloud (formerly known as eDelivery) you will find the following base releases of the Oracle database:

How to get access to download older Oracle versions?

And the other source for downloads is oracle.com. But there you currently will be able to download Oracle Database 19c and Oracle Database 21c.

But there is no sight …

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

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

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

Workaround for sdoloadj.sql errors with Datapatch in 19.9.0 and 19.10.0

The other week a customer from my hometown alerted me about an issue they saw when applying the 19.9.0 RU. A long sequence of errors in the datapatch run, all of them signaled from sdoloadj.sql. They opened an SR. And Support had an – understandable – recommendation the customer didn’t want to implement: Install JAVAVM. But thanks to my PM mate, Hans Viehmann (Mr Spatial), here is a simple Workaround for sdoloadj.sql errors with Datapatch in 19.9.0 and 19.10.0. And it may even apply to later releases, too.

What happens?

Take …

Continue reading...

Virtual Classroom Episode 8: Upgrade Internals and so much more

This is your final chance to sign up within the next hours to our Virtual Classroom Episode 8: Upgrade Internals and so much more  We will run this session on Wednesday Feb 10 at 10:00h CET tomorrow. And in case you don’t know yet what to do on a ice-cold winter Wednesday morning, this is what you should do.

Everything You Always Wanted to Know About Upgrades (But Were Afraid to Ask)

Virtual Classroom Episode 8: Upgrade Internals and so much more

You see the agenda in the picture above. We will cover not only internals but also diagnosability, monitoring, troubleshooting, tipps, tricks, secrets, workarounds, gothas, dos and don’ts – …

Continue reading...

Recap: Support Periods for Oracle 11.2.0.4, on-prem and in the cloud

You may have recognized that I don’t update the blog as frequent as usual. But these times are very busy with plenty of conferences and many of our customers preparing for the move to 19c in the more quieter period of the year. And this is the right time to do a quick recap: Support Periods for Oracle 11.2.0.4, on-prem and in the cloud.

Recap: Support Period for Oracle 11.2.0.4, on-prem and in the cloud

Photo by Arnaud STECKLE on Unsplash – this car is a VW Karman Ghia

11.2.0.what?

Ah, well. Do you remember when Oracle Database 11.2.0.1 got released?

No worries, I’ve had to look it up by …

Continue reading...

Fixed Objects Stats Gathering Fails – what do you do now?

A few days ago I blogged about what you could do when Fixed Objects Stats Gathering is slow in an upgrade process. You can skip the preupgrade gathering, and the postupgrade gathering does not happen anymore since the October 2020 version of AutoUpgrade. Still, I came across another issue the other day: Fixed Objects Stats Gathering Fails – what do you do now?

What happened?

Actually this is connected to the Fixed Objects Stats Gathering is slow in an upgrade case. The customer encountered an incredible long runtime. And the support engineer …

Continue reading...

Upgrade Essentials – Videos for the Virtual Classroom Series 2020

Roy, Daniel and I ran 6 workshops in our Virtual Classroom Series 2000 format. Each of them is between 90 and 120 minutes. This sounds quite long but of course you can scroll forward if you are interested in only a part of it. We consider those the Upgrade Essentials – Videos for the Virtual Classroom Series 2020. As as we now completed the 6th web seminar, it’s time for a short recap.

Is Upgrade that complicated?

Good question. If upgrade is so easy as we say, why do you need 6 virtual sessions …

Continue reading...

Which database version can be used with Grid Infrastructure 19c?

This will be a very short blog post today. But a colleague asked me this question just a few minutes ago: Which database version can be used with Grid Infrastructure 19c? And I realized that I neither put it on the blog yet nor did I bookmark it. But I answered this question several times already.

Which database version can be used with Grid Infrastructure 19c?

There are 4 sources I did check:

  • MOS Notes on MyOracle Support
  • Oracle Documentation
  • Certification Information on MyOracle Support
  • Database Upgrade Blog

At first, I answered with MOS

Continue reading...

Transportable Tablespaces: Keep tablespace files read-only

When you Transport Tablespaces, you may be aware of a change in behavior a long while ago. When your tablespace import has been finished, a tablespace will be taken read-write automatically. But there may be situations when you’d like the previous behavior. Now you can have this with Transportable Tablespaces: Keep tablespace files read-only.

Transportable Tablespaces: Keep tablespace files read-only

Photo by freestocks on Unsplash

Default Behavior

Since Oracle Database 12c a tablespace will be taken read-write once the meta data import has been completed automatically. This was different in previous database releases. We used the technique a long time ago for a telco provider …

Continue reading...