Solution

OJVM patching fails with ORA-1403 in 19.30 if JAVAVM is not installed

Thanks to all the people (Jeff, Daniele, Lothar and others) who alerted me about this topic. Some of you had even created their own fix already. So, this is about an issue which happens only if you have no JAVAVM installed in your database or PDB but you still apply the OJVM Bundle on to of the Oracle Database 19.30 Release Update. You may find then: OJVM patching fails with ORA-1403 in 19.30 if JAVAVM is not installed.

OJVM patching fails with ORA-1403 in 19.30 if JVM is not installed

Photo by Michiel Leunens on Unsplash

When does this happen?

This issue happens when you apply the OJVM bundle together with …

What has happened to the 19.29 and 19.30 RUs?

Posted on February 9, 2026 by Mike.Dietrich Flaws and Pitfalls Oracle Database 19c Patch Recommendation 44

Many of you mailed us asking why AutoUpgrade does not download 19.29 or 19.30 RUs anymore. Others just noticed that the RUs got pulled without further communication visible. And a few people informed me about an issue with the 19.30 RU when you don’t have OJVM configured but install the OJVM bundle. So, what has happened to the 19.29 and 19.30 RUs??

What has happened to the 19.29 and 19.30 RUs?

Photo by Lukas Seitz on Unsplash

Release Update 19.29 and 19.30

A fix for Bug 34352668 – LNX64-23.1-RAC: SVCB HIT ORA-600 [KCBGTCR_17] has been included into RUs 19.29 and 19.30 but unfortunately it could potentially cause a regression…

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 …

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

Pitfall: ORA-1843 – NOT A VALID MONTH in Oracle 19.4 – 19.8

Posted on August 25, 2020 by Mike.Dietrich Flaws and Pitfalls 15

Today, I’d like to write about a tiny little issue – which can cause some real trouble in Oracle 19c. This blog post is about the Pitfall: ORA-1843 – NOT A VALID MONTH in Oracle 19.4 – 19.8.

Pitfall: ORA-1843 - NOT A VALID MONTH in Oracle 19.4 - 19.8

Photo by Daniel J. Schwarz on Unsplash

The Testcase

My testcase is super-simple – and you can reproduce it even without any object in 2 seconds (one for “copy“, the other for “paste“). Simply execute this query:

select to_date('20191120','RRMMDD') from dual;

Or this one where I replace “RR” with the more common “YY”:

select to_date('20191120','YYMMDD') from dual;

Upgrade fails with ORA-20001 during datapatch run

Posted on July 31, 2020 by Mike.Dietrich AutoUpgrade Oracle Database 19c Patch Recommendation Upgrade / Migration 23

I encountered this issue now multiple times in my own environment. And I searched MOS and tried different things. But I couldn’t solve it yet. My Upgrade fails with ORA-20001 during datapatch run – and I’d like to show you how to bring the upgrade to an successful end.

Upgrade fails with ORA-20001 during datapatch run

Photo by chuttersnap on Unsplash

It all starts with an upgrade

In my lab environment I upgrade two databases often in parallel. An 11.2.0.4 database and a 12.2.0.1. The 11.2.0.4 upgrades always flawless. But the 12.2.0.1 occasionally fails. This is the screen AutoUpgrade is showing me – but this is not …

AutoUpgrade may fail when patch ID column is NULL

Posted on November 25, 2019 by Mike.Dietrich AutoUpgrade 39

Monday morning – it’s time to write a new blog post. And actually I will set priorities based on what you reported to me in the past week. This way it may prevent others from hitting the same pitfall. The AutoUpgrade may fail when patch ID column is NULL in REGISTRY$HISTORY.

AutoUpgrade may fail when patch ID column is NULL

Photo by Etienne Boulanger on Unsplash

What is happening?

You start a database upgrade with autoupgrade. But the initial check will fail with a message like this:

AutoUpgrade tool launched with default options
There was an error initializing the patching information for entry upg2

The AutoUpgrade won’t kick …

VBox 5.0.10/12 issues with PERL and Seg Faults – UPDATE

Posted on January 14, 2016 by Mike.Dietrich Hands-On Lab Virtualization 6

A bit more than two months ago I did hear from several people having issues with our Hands-On Lab environment. And it became clear that only those who use Oracle Virtual Box 5 see such errors.

VBox 5.0.10 crash issues with our Hands-On-Lab

Oracle VirtualBox 5.0.x – Segmentation Fault in PERL

Then I read Danny Bryant‘s blog post (thanks to Deiby Gomez for pointing me to it) about similar issues and a potential solution yesterday:

http://dbaontap.com/2016/01/13/vbox5/

And interestingly one of my colleagues, our PL/SQL product manager Bryn Llewellyn started an email thread and a test internally yesterday as well.

Solution

OJVM patching fails with ORA-1403 in 19.30 if JAVAVM is not installed

When does this happen?

What has happened to the 19.29 and 19.30 RUs?

Release Update 19.29 and 19.30

Upgrade from 11.2.0.4 to 19c with Label Security Policies

What happens?

Messaging Gateway – Upgrade can’t find mgwu122.sql

What is the Messaging Gateway?

Pitfall: ORA-1843 – NOT A VALID MONTH in Oracle 19.4 – 19.8

The Testcase

Upgrade fails with ORA-20001 during datapatch run

It all starts with an upgrade

AutoUpgrade may fail when patch ID column is NULL

What is happening?

VBox 5.0.10/12 issues with PERL and Seg Faults – UPDATE

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts