Oracle Database 19c

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 …

Messaging Gateway – Upgrade can’t find mgwu122.sql

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

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 …

Receiving ORA-55940: An error occurred during execution of ktliIngestExternData

Posted on October 23, 2020 by Mike.Dietrich Auditing Flaws and Pitfalls 10

During my previous test with Unified Auditing Policies anomalies after upgrade to Oracle 19c, I also hit and error when I queried the unified audit trail. Hence, I make a reminder to myself and would like explain what to do in case you are Receiving ORA-55940: An error occurred during execution of ktliIngestExternData as well.

Receiving ORA-55940: An error occurred during execution of ktliIngestExternData

Photo by Moritz Mentges on Unsplash

What a strange error

I created a few policies by myself and did a database upgrade from Oracle 12.2.0.1 to Oracle 19.8.0. And after upgrade, I wanted to check the records in my audit trail. But instead of …

Check your Unified Auditing Policies after upgrading to Oracle 19c

Posted on October 21, 2020 by Mike.Dietrich Auditing Flaws and Pitfalls Oracle Database 19c 11

This may become a longer blog post. One of the customers I work with for many years contacted me a few weeks ago. After upgrade to 19c, it looked like as if some Unified Auditing Policies weren’t correct anymore. It started as a tiny issue, but thanks to the customer who analyzed down to the bones, it seems to be bigger than we thought at the beginning. So you may Check your Unified Auditing Policies after upgrading to Oracle 19c as well.

Photo by Felix Luo on Unsplash

Unified Auditing

Actually a lot of my customers use Unified Auditing these …

Oracle Database 19c Premier Support extended by more than 1 year

Posted on June 17, 2020 by Mike.Dietrich Release Schedule 0

Exciting news. And some of you may have spotted it already due to an update on the Single Source of Truth note, MOS 742060.1 last week: Oracle Database 19c Premier Support extended by more than 1 year.

Photo by lovely shots on Unsplash

Oracle Database 19c Premier Support extended by more than 1 year

This is an important message some customers have already asked for. Originally, the Premier Support period for Oracle Database 19c was supposed to run until end of March 2023. Now you may relax in your chair as this seems unbelievably far away. But that’s only…

Oracle Database 19c is certified on OL8 and RHEL8

Posted on May 11, 2020 by Mike.Dietrich Operating System 59

Oh … I’d say this was the question I’ve got asked the second most often in the past months (after a potential extension for Oracle 12.2.0.1 support): When will Oracle certify OL8 and RHEL8? And I read this question internally even more often. Now thanks to my team mate Daniel Overby Hansen who spotted it on Twitter on the weekend, we can tell you that … finally … drum roll … Oracle Database 19c is certified on OL8 and RHEL8.

Oracle Database 19c is certified on OL8 and RHEL8

Photo by Derek Oyen on Unsplash

How do you get the information?

Go to MyOracle Support and hit …

Oracle Database 19c (19.3.0) for Windows and zLinux is available

Posted on June 8, 2019 by Mike.Dietrich Oracle Database 19c 9

As of now, Oracle Database 19c (19.3.0) for Windows and zLinux is available for download in addition to Linux, SPARC Solaris, HP-UX and AIX.

Oracle Database 19c on premises for Windows and zLinux

You can download Oracle Database 19.3.0 on-prem for MS Windows and zLinux from the usual sources:

Oracle 19c Documentation

And of course you can find the Oracle 19c Documentation here:

See especially the operating system dependent install guides:

Automatic SQL Plan Management in Oracle Database 19c

Posted on June 3, 2019 by Mike.Dietrich Oracle Database 19c SPM - SQL Plan Management 6

When you upgrade to a new database release, there will be changes. Some are obvious, others are not. This one is somewhere in between because it is documented quite well but not very well known yet as far as I see. I’m talking about the Automatic SQL Plan Management in Oracle Database 19c.

What is changing in Oracle 19c?

PLEASE READ THIS UPDATED BLOG POST:
https://mikedietrichde.com/2019/10/02/automatic-sql-plan-management-slight-change-with-19-4-0/
AS THERE IS A CHANGE WITH ORACLE 19.4.0.

First of all, I don’t want to rewrite everything Nigel Bayliss wrote in his detailed blog post about Automatic SQL Plan Management in Oracle 19c …

The new AutoUpgrade utility in Oracle 19c

Posted on April 29, 2019 by Mike.Dietrich AutoUpgrade 302

The new AutoUpgrade utility in Oracle 19c Oracle Database 19c on premises is available – and one of the key features is the new AutoUpgrade utility. In the following days I will publish several blog posts explaining and showcasing the new AutoUpgrade.

What is the AutoUpgrade?

The Oracle Database AutoUpgrade utility is a new tiny little command line tool which allows you to upgrade your databases in an unattended way. I call it the Hands-Free Upgrade. The idea of the tool is to run the prechecks against multiple databases, fix 99% of the potential issues, set a restore point in case something goes wrong …

Oracle Database 19c (19.3.0) for SPARC Solaris is available for download

Posted on April 26, 2019 by Mike.Dietrich Uncategorized 4

Since yesterday you can download Oracle Database 19.3.0 on premises for Linux. And as of today, 19c for SPARC Solaris 64bit is available, too.

Oracle Database 19c on premises for SPARC Solaris

You can download Oracle Database 19.3.0 on-prem for SPARC Solaris 64bit now from the usual sources:

Oracle 19c Documentation

And of course you can access the Oracle 19c Documentation from now on as well:

See especially the operating system dependent install guides:

Oracle Database 19c (19.3.0) for Linux is available for download

Posted on April 25, 2019 by Mike.Dietrich Oracle Database 19c 20

Oracle Database 19c (19.3.0) for Linux is available for download as of now from OTN and eDelivery. For those of you who started with Oracle Database 19.2 already, the Updates (RU) 19.3.0 for the database and GI are available as well for Linux and Solaris.

Oracle Database 19c on premises for Linux

You can download Oracle Database 19.3.0 on-prem for Linux now from the usual sources:

The download offering includes the zip, the RPM for the database, and Grid Infrastructure, the Client and more.

Oracle Database 19c (19.3.0) for Linux is available for download

The other ports will follow soon.

Oracle 19c Documentation

And of course …

Oracle Multimedia will be removed in Oracle Database 19c

Posted on February 18, 2019 by Mike.Dietrich Deprecated / Desupported Oracle Database 19c 20

With Oracle Database 19c being available on Exadata now, and most likely soon on-prem as well, there’s a significant change you should be aware of when using image processing features inside the database: Oracle Multimedia will be removed in Oracle Database 19c.

Photo by Jilbert Ebrahimi on Unsplash

Oracle Multimedia will be removed in Oracle Database 19c

When you upgrade or migrate your database to Oracle 19c, then Oracle Multimedia APIs will be still exist but won’t function anymore.

Read here in the Oracle Database 19c Upgrade Guide:

Desupport of Oracle Multemedia

Oracle Multimedia is desupported in Oracle Database

Oracle Database 19c requires OL7, RHEL7 or SLES12 or newer

Posted on February 14, 2019 by Mike.Dietrich Oracle Database 19c 36

Oracle Database 19.2 for Oracle Exadata systems is available for download since yesterday night. One important thing you need to take into account once Oracle 19c will be generally available: On Linux, Oracle Database 19c requires OL7, RHEL7 or SLES12 or newer.

Database Installation Guide for Linux

You will find the exact minimum OS and kernel version requirements in the Database Installation Guide for Linux for Oracle 19c. Please see here the Operating System Checklist for Oracle Database Installation on Linux:

Please be aware that the list of minimum requirements has been updated – always check Operating …

Oracle Database 19.2 for Exadata is now available for download

Posted on February 13, 2019 by Mike.Dietrich Oracle Database 19c 1

Time flies – and we have 2019. Since a few minutes Oracle Database 19.2 for Exadata is now available for download.

Oracle Database 19.2 for Exadata is now available for download

You can download as of today Oracle Database 19.2 for Exadata from the Software Delivery Cloud (eDelivery).

Just type in “Oracle Database” into the search window:

Oracle Database 19.2 for Exadata is now available for download

And then add it to your cart:

Oracle Database 19.2 for Exadata is now available for download

Documentation

And of course, the Oracle Database 19c documentation is available as of now as well:

Oracle Database 19.2 for Exadata is now available for download

Further Information

Please read more on the Oracle Database Blog.

–Mike…

Oracle 19c is available in LiveSQL

Posted on January 16, 2019 by Mike.Dietrich Oracle Database 19c 9

As Willie Hardie, VP Oracle Database Produce Management, wrote in his blog post, Oracle Database 19.2 is available in LiveSQL since yesterday. You can try out scripts and such in a container. Of course, feature usage is restricted. But that’s a pretty nice thing for an early start with Oracle Database 19c.

Try it out

Try it out on: liveSQL.oracle.com

And find more information in Willie Hardie’s post: https://blogs.oracle.com/oracle-database/oracle-database-19c-now-available-on-livesql

–Mike

…

Oracle Database 19c

Virtual Classroom Seminars?

What is the Messaging Gateway?

What happens?

Why does it happen?

What a strange error

Unified Auditing

Oracle Database 19c Premier Support extended by more than 1 year

How do you get the information?

Oracle Database 19c on premises for Windows and zLinux

Oracle 19c Documentation

What is changing in Oracle 19c?

What is the AutoUpgrade?

Oracle Database 19c on premises for SPARC Solaris

Oracle 19c Documentation

Oracle Database 19c on premises for Linux

Oracle 19c Documentation

Oracle Multimedia will be removed in Oracle Database 19c

Database Installation Guide for Linux

Oracle Database 19.2 for Exadata is now available for download

Documentation

Further Information

Try it out

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Recent Posts

Follow me on Twitter