Recreate

ORA-2380 profile ORA_STIG_PROFILE does not exist during upgrade to 26ai

Posted on October 12, 2026 by Mike.Dietrich Flaws and Pitfalls 0

Let us start the week with something I wanted to put on the blog for a long time since I have seen some customers being trapped by this in their 26ai upgrade attempts. If you are not upgrading now, you may ignore this blog post safely. But if you are in the process, please check out what you can do to prevent the ORA-2380 profile ORA_STIG_PROFILE does not exist during upgrade to 26ai.

ORA-2380 profile ORA_STIG_PROFILE does not exist during upgrade to 26ai

What’s the problem?

When you attempt an upgrade to Oracle AI Database 26ai, you may get this error sequence in case the ORA_STIG_PROFILE is missing:

06:22:43

Solution for ORA-02303 from JSON_OBJECT_INVALID in upgrade to 19c

Posted on October 30, 2020 by Mike.Dietrich Flaws and Pitfalls 0

I just learned yesterday about this error – and as it seems to happen occasionally, you may want to read more about the Solution for ORA-02303 from JSON_OBJECT_INVALID in upgrade to 19c.

Solution for ORA-02303 from JSON_OBJECT_INVALID in upgrade to 19c

Photo by Pankaj Patel on Unsplash

What happens?

You are upgrading a database to Oracle 19c, and you see this error pattern:

CREATE OR REPLACE TYPE JSON_Object_T AUTHID CURRENT_USER UNDER JSON_Element_T(
*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents

This is coming when catjson.sql gets executed.

Why does it happen?

Unfortunately the FORCE option is missing when we create …

In case you miss DBMS_OPTIM_BUNDLE in 12.2

Posted on February 11, 2019 by Mike.Dietrich Flaws and Pitfalls 0

Strange things happen sometimes. I got alerted by a customer before Christmas about package DBMS_OPTIM_BUNDLE missing after applying a Release Update. I’ve had a conversation with Nigel Bayliss, the Optimizer PM – but Nigel hasn’t heard of such things either. We both investigated but couldn’t reproduce the issue. But after the end-of-the-year holidays I received similar messages from other customers. In case you miss DBMS_OPTIM_BUNDLE in 12.2, then this blog post should help you.