OJVM

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.

Photo by Vasily Koloda on Unsplash

Why are patches missing?

At first, I …

Patching all my environments with the October 2022 Bundle Patches

Posted on November 9, 2022 by Mike.Dietrich Patch Recommendation 55

Oh yes, it is patching time (again). And this time I somehow missed the slot since the quarterly critical patch updates got released right during Oracle Cloud World. Since I didn’t want to stretch the hotel WiFi too much – and since I wouldn’t have had enough time to install and write-up this blog post, I do it now with a week of delay. So as usual every quarter, follow me for patching all my environments with the October 2022 Bundle Patches.

Patching all of my environments with the October 2022 Bundle Patches

Photo by Olga Guryanova on Unsplash

As usual, an important annotation upfront: I patch in-place due to …

Simple database installation with applyRU and applyOneOffs

Posted on May 17, 2022 by Mike.Dietrich Installation Patch Recommendation 28

Some of you may remember my blog post from April 22, 2021 about issues I saw with the unattended installation using applyRU and applyOneOffs switches. The installation failed with a strange jox error when I passed on the OJVM bundle to my installation queue. But there is relief – finally, after almost one year. So let me give you some background, and of course show you the workaround for the Simple database installation with applyRU and applyOneOffs.

Simple database installation with applyRU and applyOneOffs

Photo by Xan Griffin on Unsplash

What has happened?

A longer while ago, we introduced the very convenient ability to install patches …

Patching all my environments with the April 2022 Patch Bundles

Posted on April 25, 2022 by Mike.Dietrich Patch Recommendation 37

Easter time is patching time. And since I was hiking and biking every day the last week up in the Northern Italian mountains, this blog post is coming with a slight delay. But better late than never. Time to show you my usual exercise, this time Patching all my environments with the April 2022 Patch Bundles.

Patching all my environments with the April 2022 Patch Bundles

Photo by National Cancer Institute on Unsplash

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 about how to apply the RU …

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

Oracle 19c Installation with 19.11.0 RU, OJVM and some other fixes

Posted on April 22, 2021 by Mike.Dietrich Installation Oracle Database 19c Patch Recommendation 40

In an previous blog post we showed how to install and patch in one single action. And as I use this technique all the time when I setup new homes, would like to show you an Oracle 19c Installation with 19.11.0 RU, OJVM and some other fixes. The purpose of this blog post is mainly to demonstrate again how you can install and patch in one action. But also to help you avoiding a pitfall when you apply the OJVM RU from April 2021.

Oracle 19c Installation with 19.11.0 RU, OJVM and some other fixes

Photo by Sammy Williams on Unsplash

What do we need?

At first, let us …

Do you need the Mitigation Patch in CDB$ROOT and all PDBS?

Posted on January 25, 2021 by Mike.Dietrich JVM Patch Recommendation 10

Thanks to Axel Delin for asking this very reasonable question on the blog. Do you need the Mitigation Patch in CDB$ROOT and all PDBS? Background for this question is that Axel can’t remove JVM but doesn’t use it. A typical case we cover in our slides and presentations as well. And in this case, the Mitigation Patch will become your friend. Please note: If you DON’T have JAVAVM in your database, you won’t need to pay attention and instead could stop reading now.

Photo by Mick Truyts on Unsplash

Mitigation Patch

You can read more about the Mitigation Patch, and …

Patching all my environments with the January 2021 OJVM Bundles

Posted on January 22, 2021 by Mike.Dietrich JVM Patch Recommendation 10

You may have read my blog post from the other day about patching my environments with the January 2021 Release Updates. But as I installed now Java in all my databases for testing purposes, I will quickly demonstrate how Patching all my environments with the January 2021 OJVM Bundles works.

Patching all my environments with the January 2021 OJVM Bundles

Photo by Anni Denkova on Unsplash

Security Alert January 2021

Let me start with the Security Alert for January 2021. And don’t forget to take a look at the Oracle Database Server Risk Matrix for January 2021. This time, the is a 4.8 risk score issue with …

OJVM datapatch fails with ORA-29532 – but the root cause is noncdb_to_pdb.sql

Posted on April 20, 2020 by Mike.Dietrich Flaws and Pitfalls JVM 2

Kudos to Robert Ortel who brought this nice misbehavior to my attention. And even though it looks like this would be an OJVM issue, it is caused by noncdb_to_pdb,sql, the script which is used to convert a non-CDB to a PDB. When you apply an OJVM patch, OJVM datapatch fails with ORA-29532 – but the root cause is noncdb_to_pdb.sql.

OJVM datapatch fails with ORA-29532 - but the root cause is noncdb_to_pdb.sql

Photo by Alexandra Gorn on Unsplash

It’s a bit tricky

First things first. This is not a blog post to blame OJVM. The problem just happens because datapatch for an OJVM patch touches data in the dictionary which hasn’t …

OJVM and the Mitigation Patch – Things to know in 2020

Posted on March 31, 2020 by Mike.Dietrich JVM 8

Today my headline sounds a bit like “Little Red Riding Hood and the Big Bad Wolf” – but there is a reason why I’d like to write about about OJVM and the Mitigation Patch – Things to know in 2020. We are working with a customer right now where preupgrade.jar gave a warning about the existence of the Mitigation patch in an 11.2.0.4 home – despite the fact that JAVAVM is not configured in this database. And this looked strange to us.

Photo by Šárka Jonášová on Unsplash

Mitigation Patch?

A quick search on my blog shows me that …

Issues with seed databases, patch bundles and OJVM in 19c

Posted on February 18, 2020 by Mike.Dietrich Flaws and Pitfalls JVM 11

I really rely on people telling me about issues they saw. And in this case, it happened twice within a few days. At OOW London, a customer came after my talk and told me about invalid objects and an incredible long recompilation time. In fact, he had to apply an OJVM patch in order to solve this. When I returned home, Jure commented on the blog about a very similar issue. I spent some time on the weekend to check it out. And I realized: There are issues with prebuilt seed databases and OJVM in 19c.

Issues with seed databases, patch bundles and OJVM in 19c

Photo by Max

Do you need to apply OJVM patches to Grid Infrastructure?

Posted on January 24, 2020 by Mike.Dietrich ASM / RAC / GI Patch Recommendation 18

From time to time, when I discuss OJVM patching with customers, I hear the following question: Do you need to apply OJVM patches to Grid Infrastructure? I’m carrying around this topic since months actually.

Do you need to apply OJVM patches to Grid Infrastructure?

Photo by Jakub Kriz on Unsplash

A quick MOS check

Well, you’d assume this is something MOS does give you an answer within fractions of a second. But nope. I found a lot but unfortunately not what I was looking for. What I found instead where community discussions where applying OJVM patches to a 12.1.0.2 GI installation corrupted the inventory. Hence, there seems to be some …

Do you need STARTUP UPGRADE for OJVM?

Posted on January 23, 2020 by Mike.Dietrich JVM Patch Recommendation 10

Actually I carry around this topic with me since the October 2019 workshop in Dubai. We’ve had one of these OJVM Patching discussions I’d like to escape usually. Anyhow, during this session, it dawned me that the STARTUP UPGRADE requirement in the OJVM readme may be not correct anymore. So the question will be: Do you need STARTUP UPGRADE for OJVM?

Photo by Nik Shuliahin on Unsplash

A little bit of history

You will find a good amount of blog posts about OJVM here. OJVM stands for Oracle Java Virtual Machine. It is a very powerful thing and allows you …

Patching all my environments with the January 2020 Patch Bundles

Posted on January 22, 2020 by Mike.Dietrich Patch Recommendation 40

I was traveling last week and had not enough time to download and apply the January 2020 Release Updates and PSUs. Yes, I’m one week late. But nevertheless, I’d like to check whether patching my databases with the January 2020 RUs will work fine.

Patching all my environments with the January 2020 Patch Bundles

Wörthsee near Munich in January 2020 – Water temperature is 3.4°C

Security Alert January 2020

My usual approach is to start with the Security Alerts for January 2020. It leads me to the January 2020 Critical Patch Advisory. As I’m a database guy, this is the line I’m interested in: Oracle Database Server, versions 11.2.0.4, …

Does OJVM patching require a specific Database Release Update?

Posted on December 12, 2018 by Mike.Dietrich JVM 0

This question came up several times in the past days: Does OJVM patching require a specific Database Release Update? People mentioned that there’s a significant difference between the OJVM Patch Readme between Oracle 12.2.01 and Oracle 18.4.0.

Photo by Jimmy Ofisia on Unsplash

What’s the point?

In the OJVM (Oracle Java Virtual Machine) Patch Readme for Oracle Database 12.2.0.1 a sentence clarified that you can combine different states of OJVM and Database patch bundle with each other. Your database home could have been patched with the April 2018 Update, whereas you decided to apply the October 2018 OJVM patch.

The …

Oracle 18.3.0 on premises includes 1.4GB patches?

Posted on July 27, 2018 by Mike.Dietrich Oracle Database 18c 13

Oracle Database 18.3.0 on premises is available for download on Linux since July 23, 2018. The other ports will follow soon. And via twitter I received a question why Oracle 18.3.0 on premises includes 1.4GB patches?

Oracle 18.3.0 on premises includes 1.4GB patches?

When you unzip the downloaded database image:

then you may discover the following folder .patch_storage of 1.4GB size:

[oracle@localhost .patch_storage]$ ls -lrt
total 40
drwxr-xr-x. 4 oracle dba 4096 Jul 18 19:39 28090523_Jul_14_2018_00_03_50
drwxr-xr-x. 4 oracle dba 4096 Jul 18 19:40 28090553_Jul_11_2018_19_20_31
drwxr-xr-x. 4 oracle dba 4096 Jul 18 19:41 27923415_Jul_15_2018_10_33_22
drwxr-xr-x. 8 oracle dba 4096

Are OJVM patches included in the Oracle 12.2 RU / RUR?

Posted on October 20, 2017 by Mike.Dietrich JVM Patch Recommendation 0

I have received this question multiple times in the past days, especially when I presented at the Slovenian Oracle User Group Conference about the new Release and Patching Mode but also via emaill: Are OJVM patches included in the Oracle 12.2 RU / RUR? Let me clarify this in the below blog post.

Are OJVM patches included in the Oracle 12.2 RU / RUR?

At first I did check MOS Note: 1929745.1 – Oracle Recommended Patches — “Oracle JavaVM Component Database PSU and RU” (OJVM PSU and OJVM RU) Patches.But besides having RU mentioned in the Note’s title and …

JAVAVM and XML Clean Up in Oracle Database 11.2-19c

Posted on August 7, 2017 by Mike.Dietrich JVM Removal 23

JAVAVM and XML clean up in Oracle Database 11.2-19c is a tough topic. Many have suffered from the rolling patch upgrade issues with the OJVM (Oracle Java Virtual Machine) even though most of the issues have been cured with the recent patches.

Please see my previous blog posts starting here:

And please see also this very important MOS Note: 2217053.1 – RAC Rolling Install Process for the “Oracle JavaVM Component Database …

The OJVM Patching Saga – and how to solve it – Part V

Posted on February 16, 2017 by Mike.Dietrich JVM Patch Recommendation 5

Related Posts on
“The OJVM Patching Saga – and how to solve it“:

MOS Note released explaining patching without STARTUP UPGRADE mode

An important note regarding OJVM rolling patching has been published on MyOracle Support:

MOS Note: 2217053.1
RAC Rolling Install Process for the “Oracle JavaVM Component Database PSU” (OJVM PSU) Patches

“Beginning with the Jan2017 OJVM PSU patchset for 11.2.0.4 and

The OJVM Patching Saga – and how to solve it – Part IV

Posted on February 9, 2017 by Mike.Dietrich JVM Patch Recommendation 1

Related Posts on
“The OJVM Patching Saga – and how to solve it“:

What is missing with the “Mitigation Patch?

Michael, the team lead from a large Oracle customer mailed me the other day. He wanted to disable Java on all their +600 databases by using the Mitigation Patch for OJVM. But he received a strange error when trying to enable the …

The OJVM Patching Saga – and how to solve it – Part III

Posted on September 14, 2016 by Mike.Dietrich JVM Patch Recommendation 3

Related Posts on
“The OJVM Patching Saga – and how to solve it“:

What is the “Mitigation Patch?

In MOS Note:1929745.1 – Oracle JavaVM Component Database Patches there’s a section called What is the Mitigation Patch. It says:
“For situations where the latest OJVM PSU cannot be installed immediately there is a “Mitigation Patch” that can be used. The “Mitigation …

The OJVM Patching Saga – and how to solve it – Part II

Posted on September 6, 2016 by Mike.Dietrich JVM Patch Recommendation 4

Related Posts on
“The OJVM Patching Saga – and how to solve it“:

Important Notes

MOS Note: 1929745.1 – Oracle JavaVM Component Database Patches
MOS Note: 1940702.1 – Database JVM Vulnerabilities FAQ
MOS Note: 2165212.1 – What to do if the Database JAVAVM Component becomes INVALID After installing an OJVM Patch?
This Note contains a pretty detailed removal procedure for JAVAVM as

The OJVM Patching Saga – and how to solve it – Part I

Posted on September 5, 2016 by Mike.Dietrich JVM Patch Recommendation 20

Related Posts on
“The OJVM Patching Saga – and how to solve it“:

Who’s the Product Manager for Patching?

First of all, I’m neither a patching expert nor am I the Product Manager for Patching. There’s no such role as far as I know but there are people inside Oracle who have way more clue about this topic. There’s a group …

OJVM patch: Standby-First patching, yes or no?

Posted on August 8, 2016 by Mike.Dietrich JVM Patch Recommendation 6

I have blogged in the past more than once about the “wonderful” topic of OJVM patching.

Anyhow, I’d like to summarize a few typical questions sent to me in the past months regarding OJVM patching.

Do I need to apply the OJVM patch every time I apply a PSU or BP?

Unfortunately this is not a one-time-and-then-you-are-set operation. You’ll have to do it every time.

How do I find out if OJVM is used in my database?

I tried to nail this down in this blog post here:

Java in the database – OJVM non-rolling patches – OJVM Removal

But …

Oracle 12.2: OJVM will no longer support compilation of SQLJ source – and JPub does not get shipped anymore

Posted on December 22, 2015 by Mike.Dietrich Behavior Change JVM Oracle Database 12.2.0.1 11

In Oracle Database 12.2.0.1, OJVM will no longer support the compilation of SQLJ source or executing SQLJ classes.

SQLJ on the client side will continue to be developed, shipped and supported. Only the part inside the DB is affected. Existing SQLJ code that runs inside the DB will need to be re-coded to use generic JDBC.

Furthermore JPubublisher (client-side and inside-DB) will not get shipped anymore with Oracle Database 12.2. It got removed from the RDBMS code. There is no replacement.

See here:

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/desupported-features-oracle-database-12c-r2.html#GUID-12BE00C5-D043-43DE-BCE0-2D3BD400AE29

–Mike…

OJVM

Why are patches missing?

What has happened?

What

What do we need?

Mitigation Patch

Security Alert January 2021

It’s a bit tricky

Mitigation Patch?

A quick MOS check

A little bit of history

Security Alert January 2020

What’s the point?

Oracle 18.3.0 on premises includes 1.4GB patches?

Are OJVM patches included in the Oracle 12.2 RU / RUR?

Related Posts on “The OJVM Patching Saga – and how to solve it“:

MOS Note released explaining patching without STARTUP UPGRADE mode

Related Posts on “The OJVM Patching Saga – and how to solve it“:

What is missing with the “Mitigation Patch?

Related Posts on “The OJVM Patching Saga – and how to solve it“:

What is the “Mitigation Patch?

Related Posts on “The OJVM Patching Saga – and how to solve it“:

Important Notes

Related Posts on “The OJVM Patching Saga – and how to solve it“:

Who’s the Product Manager for Patching?

Do I need to apply the OJVM patch every time I apply a PSU or BP?

How do I find out if OJVM is used in my database?

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Follow me on Twitter

Recent Posts

Related Posts on
“The OJVM Patching Saga – and how to solve it“:

Related Posts on
“The OJVM Patching Saga – and how to solve it“:

Related Posts on
“The OJVM Patching Saga – and how to solve it“:

Related Posts on
“The OJVM Patching Saga – and how to solve it“:

Related Posts on
“The OJVM Patching Saga – and how to solve it“: