oracle 19c

Can you use the UEK7 Linux kernel, or may you get some trouble?

Posted on November 27, 2023 by Mike.Dietrich Linux Release Schedule 6

Writing about a topic I have not much knowledge with is … no fun 🙂 But let me share this with you as one of my most trusted customers, Peter Lehmann, tested this and got trapped. The information being available was not crystal clear, and Peter‘s database did not start anymore when HUGEPAGES were enabled. So, the question is: Can you use the UEK7 Linux kernel, or may you get some trouble?

Can you use the UEK7 Linux kernel, or may you get some trouble?

Photo by Sandip Kalal on Unsplash

Where it all starts

Peter set up a new cluster with Oracle Linux 8.8 using an UEK7 kernel. And as …

Oracle Database 19c is certified on OL9 and RHEL9

I know, many of you were asking several times already about the certification of the Oracle Database on Oracle Linux 9 and Red Hat Enterprise Linux 9. And originally I think an announcement was planned for Oracle Cloud World in Las Vegas. But certification mean that you really certify, and not just wave things through. We’ve done thorough testing, and some issues were found which needed to be fixed at first. Good news: Oracle Database 19c is certified on OL9 and RHEL9.

Oracle Database 19c is certified on OL9 and RHEL9

Photo by Ilia Bronskiy on Unsplash

Certification Tab

You can check certifications quickly on MyOracle Support by yourself. …

Going to India: Oracle Community Yatra (OCYatra) 2023

Posted on July 17, 2023 by Mike.Dietrich Workshop 0

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 …

Virtual Classroom Seminar 16: Release and Patching Strategy for Oracle 19c and 23c

Posted on May 8, 2023 by Mike.Dietrich Patch Recommendation Release Schedule Workshop 9

There are just two days left to sign up for our Virtual Classroom Seminar 16: Release and Patching Strategy for Oracle 19c and 23c. We’ll talk to you on Wednesday, May 10 at 16:00h CET.

Photo by JESHOOTS.COM on Unsplash

What’s the topic?

We’ll try to cover everything for your best release and patching strategy with Oracle Database 19c of course, but also moving forward to Oracle Database 23c. Our big focus will be several aspects of patching. You’ll hear us talking not only about standard database patching but especially about patching in RAC environments.

We’ll put together a …

Hide and Seek with RU 19.18.0

Posted on February 2, 2023 by Mike.Dietrich Flaws and Pitfalls Patch Recommendation 46

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.

Photo by Braydon Anderson on Unsplash

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 …

A change in Oracle 12.2 and 19c with MV Refresh Stats Collection

Posted on November 23, 2022 by Mike.Dietrich Best Practice Upgrade / Migration 6

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 change in Oracle 12.2 and 19c with MV Refresh Stats Collection

Photo by Ralph Mayhew on Unsplash

A customer story

The local Support team asked me a few weeks ago whether I have heard …

Applying the first MRP for Oracle 19.17.0

Posted on November 17, 2022 by Mike.Dietrich Patch Recommendation 33

A few weeks ago I blogged about the fact that we retired the RURs, and instead release the MRPs (Monthly Recommended Patches). In my previous blog post about this topic you’ll find also an FAQ hopefully answering all the questions you may have (had). And now it is mid of November, so I can show you the process of applying the first MRP for Oracle 19.17.0.

Applying the first MRP for Oracle 19.17.0

Photo by Glenov Brankovic on Unsplash

How do you get access to the MRPs?

At the moment while I write this, you can find the MRPs only in MOS Note: 888.1 -Primary …

Silent ORA-918 behavior change in RU 19.17.0 and newer

Posted on October 27, 2022 by Mike.Dietrich Behavior Change Patch Recommendation 27

I think we have the best customers out there. It is incredible what some people find. We would be lost without you, and this blog would contain only a fraction of the information we can share with you. In this case let me explain the silent ORA-918 behavior change in RU 19.17.0 and newer. And all credits go to Peter Lehmann from Deutsche Telekom who found this issue only a few days after we released 19.17.0.

Silent ORA-918 behavior change in RU 19.17.0 and newer

Photo by Drew Farwell on Unsplash

What is happening?

Peter shared an awesome and simple test case with me. A query with ambiguously defined …

Intel uses AutoUpgrade to upgrade from Oracle 11.2.0.4 to 19c

Posted on September 27, 2022 by Mike.Dietrich Customer Success 14

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. I know that Anil is simply so busy – and my surprise was huge.

Intel uses AutoUpgrade to upgrade from Oracle 11.2.0.4 to 19c

Photo by Daniel Pantu on Unsplash

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 …

Upgrade from 11.2.0.4 to 19c with Label Security Policies

Posted on July 6, 2022 by Mike.Dietrich Flaws and Pitfalls 5

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 …

Why you can’t stay on Oracle Database 11g forever

Posted on April 6, 2022 by Mike.Dietrich Release Schedule 24

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.

Photo by Kristoffer Darj on Unsplash

Oracle Database 11g?

Virtual Classroom Seminar 13 Data Pump – Slides, Video and QA

Posted on March 8, 2022 by Mike.Dietrich Video / Viewlet Workshop 4

Thanks a lot to everybody who tuned in last week to our Virtual Classroom Seminar #13: Data Pump Extreme – Deep Dive with Development. We’ve had almost 600 attendees, and many of you stayed for the two full hours. And let me tell you that this is just awesome since there are enough people who think that a session has to be just 30 minutes or less. And of course, no it is time to share: Virtual Classroom Seminar 13 Data Pump – Slides, Video and QA.

Virtual Classroom Seminar 13 Data Pump - Slides, Video and QA

Photo by Pim Chu on Unsplash

The slides

As usual, you can …

Patching all my environments with the October 2021 Patch Bundles

Posted on December 16, 2021 by Mike.Dietrich Patch Recommendation 20

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 …

Virtual Classroom Seminar 12: Migrating Very Large Databases on Dec 9, 2021

Posted on December 8, 2021 by Mike.Dietrich Workshop 2

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

How Low Can You Go? Zero Downtime Operations on Oct 21, 2021

Posted on October 18, 2021 by Mike.Dietrich Workshop 4

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 …

Upgrading a PDB with JVM may result in ORA-7445 joevm_invokevirtual

Posted on September 29, 2021 by Mike.Dietrich Flaws and Pitfalls JVM 3

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.

Upgrading a PDB with Java may result in ORA-7445 joevm_invokevirtual

Photo by Fahmi Fakhrudin on Unsplash

What

DBMS_OPTIM_BUNDLE and disabling another fix

Posted on August 11, 2021 by Mike.Dietrich Optimizer Patch Recommendation 6

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.

Photo by Drew Patrick Miller on Unsplash

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 …

Should you enable _fix_controls with DBMS_OPTIM_BUNDLE?

Posted on August 10, 2021 by Mike.Dietrich Optimizer Patch Recommendation 15

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.

Should you enable _fix_controls with DBMS_OPTIM_BUNDLE?

Photo by paolo candelo on Unsplash

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;

Upgrade to Oracle 19c on Exadata with AutoUpgrade

Posted on June 16, 2021 by Mike.Dietrich Exadata / ODA Oracle Database 19c 23

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.

Upgrade to Oracle 19c on Exadata with AutoUpgrade

Photo by Lindsay Henwood on Unsplash

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 …

Messaging Gateway – Upgrade can’t find mgwu122.sql

Posted on May 21, 2021 by Mike.Dietrich Flaws and Pitfalls Oracle Database 18c Oracle Database 19c 6

Thanks to Christian Ballweg from Optiz Consulting who brought this issue to my attention. I haven’t seen it before since I haven’t installed it but you may encounter this if you have the Messaging Gateway – Upgrade can’t find mgwu122.sql.

Messaging Gateway - Upgrade can't find mgwu122.sql

Photo by Olav Ahrens Røtne on Unsplash

What is the Messaging Gateway?

Actually I steal this from the documentation:

Messaging Gateway enables communication between applications based on non-Oracle messaging systems and Oracle Database Advanced Queuing.

Oracle Database Advanced Queuing provides propagation between two Oracle Database Advanced Queuing queues to enable e-business (HTTP through IDAP). Messaging Gateway extends

New parameters and features in Oracle Database 19.11.0

Posted on April 26, 2021 by Mike.Dietrich Behavior Change Patch Recommendation 6

As usual, as soon as I apply the newest RU, I do also a quick check for New parameters and defaults in Oracle Database 19.11.0.

New parameters and features in Oracle Database 19.11.0

Photo by Roma Kaiuk on Unsplash

New Parameters in Oracle 19.11.0

Based on customer feedback, there is one really big improvement since this RU release. Not only new features but also parameter changes get listed. You will find them in the 19c New Features Guide.

In this RU you will find only 1 new parameter:

drcp_dedicated_opt
The description says “Turn on/off dedicated optimization for DRCP” – and the default is “YES

Where are AutoUpgrade error codes documented?

Posted on April 12, 2021 by Mike.Dietrich AutoUpgrade 2

I know, I didn’t blog for a while due to seminar preparations and holidays. But as I’m going through the open comments on the blog trying to answer them, I came across a question regarding the strange UPG error codes, AutoUpgrade is printing sometimes. And of course, where are AutoUpgrade error codes documented?

Where are AutoUpgrade error codes documented?

Photo by Patrick Tomasso on Unsplash

The UPG errors

Once AutoUpgrade hits an error condition, it prints an error code such as UPG-1400 or UPG-1303. And often, this error code is not very meaningful. In the comments section, somebody asked where to fine more information about these …

Oracle 19c on Windows may flood your trace file directory

Posted on March 11, 2021 by Mike.Dietrich Flaws and Pitfalls Oracle Database 19c 21

Oh … it’s Windows week here. And all this even though since I didn’t install Oracle on Windows for quite a while. But of course I’m fully aware that many of you out there operate Oracle on Windows. In this particular case thanks to Joël for the pointer to this issue. Oracle 19c on Windows may flood your trace file directory.

Oracle 19c on Windows may flood your trace file directory

Photo by Daniel von Appen on Unsplash

What happens?

In every release of Oracle 19c, at least until 19.10.0 BP, you may find out that every few minutes a trace file gets written into the %ORACLE_BASE%\diag\..\..\trace directory. And all …

ORA-12638 on Windows only from Oracle 19.10.0 onwards

Posted on March 10, 2021 by Mike.Dietrich Behavior Change Flaws and Pitfalls Oracle Database 19c 56

You like unexpected changes and surprises, don’t you? And especially those which aren’t in the patch notes or the docs. I blogged about such changes a few weeks ago. And thanks to the people reading this blog, I learned now about another change with Oracle 19.10.0 on the Windows platform. You may receive now an ORA-12638 on Windows only from Oracle 19.10.0 onwards.

ORA-12638 on Windows only from Oracle 19.10.0 onward

Photo by Fanny Rascle on Unsplash

What has been changed?

So at first, thanks to Ernst and Marcus for bringing this to my attention. This is an issue which happens on MS Windows only.

When you …

Important Recommended Patches for Oracle Database 19c

Posted on February 23, 2021 by Mike.Dietrich Patch Recommendation 18

It took a while – but now you can find a new MyOracle Support (MOS) Note with a list of Important Recommended Patches for Oracle Database 19c. It is actually a must-read, regardless whether you are upgrading or migration to 19c, or in case you are already on 19c.

Photo by Ani Kolleshi on Unsplash

What do you get?

Please check MOS Note: 2720807.1 – Oracle Database 19c Important Recommended One-off Patches. It gives you a list of important fixes for Oracle Database 19c. In the initial version of the note you could select for each available Release …

oracle 19c

Where it all starts

Certification Tab

Why you need to get your ticket NOW?

What’s the topic?

Heads Up!

A customer story

How do you get access to the MRPs?

What is happening?

What’s the story?

What happens?

Oracle Database 11g?

The slides

Virtual Classroom Seminars?

What

Disabling another fix

DBMS_OPTIM_BUNDLE – a quick recap

Why is this important?

What is the Messaging Gateway?

New Parameters in Oracle 19.11.0

The UPG errors

What happens?

What has been changed?

What do you get?

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Recent Posts

Follow me on Twitter