JVM

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

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

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 …

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…

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

Posted on June 22, 2015 by Mike.Dietrich JVM Removal 30

Question:

How can I find out if Oracle’s JVM is used in my database?

Answer:

This is unfortunately not as trivial as I thought initially …
Let’s start with:

MOS Note:397770.1

Until Oracle version 11.2 or later, there was no way to confirm if Oracle JVM is not actively used in the database.

However, what can be said is:
1) If there are non-Oracle schemas that contain java objects, then 3rd party products or user defined java programs could be actively using the Oracle JVM.
2) If there are Oracle schemas, other than SYS, that contain java objects, then

Oracle Database 12c pre-upgrade scripts and JAVAVM

Posted on September 16, 2013 by Roy.Swonger JVM Upgrade / Migration 0

This is a great example of why you should always review the README file when upgrading to a new release. Here is an issue that we found during customer beta testing, and that you will want to be aware of if you are upgrading to Oracle Database 12c and do not have the JAVAVM component in your database. The following text has been added to the 12.1 Readme under Section 1.1:

TITLE: Pre-Upgrade Tool Does Not Generate Output Logs 

The pre-upgrade tool, preupgrd.sql, is not able to create a directory to 
store the output files if the JAVAVM component

JVM

What

Mitigation Patch

Security Alert January 2021

It’s a bit tricky

Mitigation Patch?

A little bit of history

What’s the point?

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?

Question:

Answer:

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“: