Oracle

Oracle Cloud World 2024 in London

Next week it’s Oracle Cloud World 2024 in London. And I hope to see you there. It is a perfect spot to get the latest tech updates but also to meet and synch and discuss.

OCW 2024 London

Not registered yet?

In addition, there is a DevLive event the day before with about 40 separate sessions.

 

Upgrade to Oracle Database 23c talk?

Would love to see you there. But certainly there are so many other great sessions. Check out the session catalog, and choose the ones you are the …

Continue reading...

Virtual Classroom Seminar 18: XTTS to the Extreme – Video and Slides and more

Thanks for tuning in on Feb 22, 2024 into our Virtual Classroom Seminar 18: XTTS to the Extreme – Video and Slides and more are now available. And thanks for being such a great audience with so many questions.

Virtual Classroom Seminar 18: XTTS to the Extreme - Video and Slides and more

Photo by Venti Views on Unsplash

Video Recording

As usual, you can access the full recording here.

Please find the entire contents section below in the video’s description. You don’t need to watch the entire seminar, you can also access only the sections you are interested in, or skip sections which are not on your focus.

Continue reading...

Virtual Classroom Seminar 18: Cross Platform Migration to the Extreme

This week on Thursday, February 22, 2024 at 16:00h CET we’d like to invite you to our next Virtual Classroom Seminar 18: Cross Platform Migration to the Extreme. Take the chance to learn about the newest developments in cross-platform transportable tablespace migrations – and there is a lot to talk about.

Virtual Classroom Seminar 18: Cross Platform Migration to the Extreme

Photo by Venti Views on Unsplash

What will be the topics?

We’ll not only discuss but also demonstrate the newest developments and improvements in cross-platform migrations, especially for large and active databases. Learn about the new M5 migration scripts, see them in action – and get an idea …

Continue reading...

How to relink Oracle for Enterprise or Standard Edition?

What a weird blog post. But let me explain briefly the motivation for my Friday article. As you know, the blog serves also as my brain dump. And whenever I try something out I know I may need later again, I dump it here. Certainly, some LLM will pick up the information and spill it out later when you ask the interface about How to relink Oracle for Enterprise or Standard Edition?

From Enterprise to Standard Edition?

Of course, you can. But I had no idea how to when Philippe Fierens, the PM …

Continue reading...

Your chance – in-person Oracle 23c upgrade workshops in Warsaw and Munich

We have a rare offer for you. Not Santa but Daniel and I are coming to town. So, this is your chance – in-person Oracle 23c upgrade workshops in Warsaw and Munich. You are signing up for a packed day of tech. No marketing slides – just facts and features, not only Oracle Database 23c, the new upcoming long-term support release. But certainly we’ll have enough for all those you are just in the process of moving to Oracle Database 19c.

When?

We are absolutely excited to offer you a full-day in-person all-tech …

Continue reading...

ORA-39405 with impdp when you have mixed time zone versions

Today, Gisela, a former team mate from CSS/ACS Support contacted me regarding an issue seen at a customer. She reported an ORA-39405 with impdp when you have mixed time zone versions. But how can this happen? And what are the potential workarounds? Since some of our hosted environments got into the same situation already, this may be worth a blog post and some explanation.

Why does this happen?

You never cared about DST (Daylight Savings Time) files and versions of your database? This isn’t unusual, and in many environments actually not a problem …

Continue reading...

Monitor progress of Oracle Data Pump impdp

This blog post is a quick brain dump. I realized that I have so many “blog posts to write” that I need to dump the ideas or information much quicker. So, feel free to comment and correct. These queries may be useful when you run a larger import, and you would like to monitor progress of Oracle Data Pump impdp.

Monitor Data Pump progress during impdp

To monitor the progress of Data Pump during impdp you can use the following queries.

What object types are left?

select unique object_type_seqno, object_type
from system.sys_import_full_01
where 
Continue reading...

In-person Upgrade Workshops in Brussels and Utrecht

For a long time we haven’t met in person I guess. But I know very well that the audiences in Brussels, Belgium, and Utrecht, Netherlands, are very active. And it’s actually the best to meet for In-person Upgrade Workshops in Brussels and Utrecht in October – not via zoom 🙂 And this is your change to sign up if you haven’t already.

When will it happen?

Very simple – and you are just one click away:

Both events …

Continue reading...

You may need to run root.sh again after RU patching

With the Oracle Critical Patch Update Advisory – July 2023 – you may have spotted a change in the Database Release Update READMEs: You may need to run root.sh again after RU patching. Why is that?

Let us have a quick look

I verified this with the 19.20.0 README on Linux. But I guess this applies to the other READMEs as well. Please bare in mind that this applies to the Database RUs only, not to Grid Infrastructure. You can find this new paragraph in it:

3.3.5 Update Permissions for extjob

Continue reading...

Going to India: Oracle Community Yatra (OCYatra) 2023

One year ago I’ve had the pleasure to visit India for the YATRA 2022 tour. I couldn’t do all 6 tour stops and had to skip Delhi and Hyderabad. But this year I will be there for all 6 cities. So I am going to India: Oracle Community Yatra (OCYatra) 2023. And I hope to see YOU there, will I?

Going to India: Oracle Community Yatra (OCYatra) 2023

Why you need to get your ticket NOW?

I guess, most of you in the area have tickets already. Just in case if you didn’t purchase one yet, it’s time to do so. It is not expensive but be …

Continue reading...

Oracle Linux (OL), Red Hat Enterprise Linux (RHEL) and CentOS

Oracle isn’t always evil. And I personally never understood why not everyb0dy is on Oracle Linux (OL) already. It’s free, it gets extremely well maintained. And some issues my customers saw with Red Hat Enterprise Linux (RHEL) were fixed with OL literally more than a year before RHEL did. No blame to anybody – but that is my experience when customers tell me about issues over the past two years. But what is the future of Oracle Linux (OL), Red Hat Enterprise Linux (RHEL) and CentOS? And why am I writing this blog post?

Oracle Linux (OL), Red Hat Enterprise Linux (RHEL) and CentOS

Photo by Brigitta Schneiter on

Continue reading...

Oracle Database 19c on Arm platform is available

I knew it would come – but we couldn’t tell you. And there were some rumors for a longer time. Anyhow, last week at the end of June 2023 Oracle Database 19c on Arm platform is available for download and in the Oracle Cloud. In case you wonder why I write “Arm” – I learned last week that the writing has been changed a while ago from ARM to Arm.

Oracle Database 19c on Arm platform is available

Where can you download it?

It is available for download already.

Continue reading...

Oracle Database World in London – THE event in April 2023

You may have heard or seen – or even registered already – for the regional Oracle Cloud World in London on April 19, 2023 already. But were you aware that the “event to be at” happens just the next day on April 20? It will be Oracle Database World in London – THE event in April 2023.

Oracle Database World in London - THE event in April 2023

When and where will it happen?

April 20, 2023, a Thursday will be the day to mark in your calendar. We’ll meet you at Oracle Database World, the regional database event to be at in London this year at the …

Continue reading...

A patch (RU, OJVM, 32-bit) is not available yet – where will I find information?

A longer while ago I wrote a blog post about the topic that a patch (RU, OJVM, 32-bit) is not available yet – where will I find information? But I wrote it too specific. And it is even hard for me to find my older blog post. Since several of you mailed me the past weeks with a variety of questions regarding patch availability I decided to write down my thoughts – but this time in a more generic way. And I hope it is helpful.

Why are patches missing?

At first, I …

Continue reading...

March 2023 release of AutoUpgrade is available

It’s download time again. So please refresh the AutoUpgrade release you are using with the new one since the March 2023 release of AutoUpgrade is available now for download.

Where to download?

As usual, please download the newest version of AutoUpgrade via MOS Note:2485457.1 – Download AutoUpgrade.

March 2023 release of AutoUpgrade is available

 

What does this version improve?

A lot.

Really, a lot of things got improved.

You’ll find the change.log for tracking purposes at the bottom of the note. I’d wish everybody would do such a transparent change tracking as the AutoUpgrade team does. This makes …

Continue reading...

Oracle Optimizer Statistics Advisor in Oracle 19c

Christian Pfundtner pointed me to the fact that my old blog post about the Statistics Advisor from 2017 may not be up to date anymore. And he further pointed out that some of his clients still suffer from issues with the tool. Hence, let me refresh the topic with Oracle Optimizer Statistics Advisor in Oracle 19c. And thanks to Christian for the pointers.

 

Overview

At first, I won’t rewrite the entire blog post but instead focus on recent findings. Therefore, you may please want to read my previous blog post about the …

Continue reading...

ORA-13516 “CATPROC not valid” during datapatch or autoupgrade to 19.18.0

I thought I could relax this week using my leftover vacation days from 2022. But this issue is triggering me since some of you mailed me already. Maybe this blog post can prevent others from being trapped by this issue: ORA-13516 “CATPROC not valid” during datapatch or autoupgrade to 19.18.0. And as a prolog, you will NOT see the below issue when you started your database in NORMAL mode for the execution of datapatch.

 

What is the symptom?

Regardless of whether you patch to Oracle Database RU 19.18.0 manually or with …

Continue reading...

Hide and Seek with RU 19.18.0

One and a half weeks ago we released the Database and Grid Infrastructure Release Updates (RU) 19.18.0. You could read on the blog how to apply it, and you could read also about an alert. So far, all was more or less transparent but apparently sort of an Hide and Seek with RU 19.18.0 has happened. So let me shed some light.

Heads Up!

I am just the messenger trying to bring some light into the topic. Neither is our team responsible nor do we have any sort of control on this process. I …

Continue reading...

Important alert for Oracle Database and GI RU 19.18.0 on Linux

Some of you may have seen the alert already released yesterday. And thanks to Peter Lehmann again for alerting me. When you logon to MyOracle Support, you will find it simply in the alert section to the left. On Jan 25, 2023, this Important alert for Oracle Database and GI RU 19.18.0 on Linux has been released.

Important alert for Oracle Database and GI RU 19.18.0 on Linux

Photo by Gary Bendig on Unsplash

 

What is the situation?

Due to an issue described in MOS Note: 2923428.1 – LMON trace file with repeated entries of “Submitting asynchronized dump request” the Release Updates (RU) 19.18.0 for the Oracle Database and …

Continue reading...

RUs contain now all available DST patches

At first, Happy New Year everybody. There was silence on the blog for some weeks but I took an extended longer time off. Well, and once you return, there are some emails in your inbox which need some work. You’ll see several new blog posts getting published in the coming days. Back to normal, yesterday night RU 19.18.0 among other patch bundles has been released. And there’s a huge fantastic surprise in it: RUs contain now all available DST patches.

 

What’s the story?

There are some good news. We discussed this internally …

Continue reading...

Applying the MRP from December 2022 to Oracle 19c

Well, couldn’t there be a nicer pre-Christmas present than the December 2022 Monthly Recommended Patches (MRP)? You know, I’m just kidding. But since I received the first questions from customers – and before I send an email internally – I wanted to try out Applying the MRP from December 2022 to Oracle 19c.

 

Download the December MRP

Actually you need to access MOS Note: 888.1 -Primary Note for Database Proactive Patch Program since the link is not in MOS Note: 555.1 – Oracle Database 19c Important Recommended One-Off Patches even though it …

Continue reading...

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