Oracle Database 19c

How Low Can You Go? Zero Downtime Operations on Oct 21, 2021

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 …

Continue reading...

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.

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

Continue reading...

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

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.

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 …

Continue reading...

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

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.

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 …

Continue reading...

Check your Unified Auditing Policies after upgrading to Oracle 19c

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.

Check your Unified Auditing Policies after upgrading to Oracle 19c

Photo by Felix Luo on Unsplash

Unified Auditing

Actually a lot of my customers use Unified Auditing these …

Continue reading...

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

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.

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

Continue reading...

Oracle Database 19c is certified on OL8 and RHEL8

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 …

Continue reading...

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

Oracle Database 19c (19.3.0) for Windows and zLinux is availableAs 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

Oracle Database 19c (19.3.0) for Windows and zLinux is availableYou 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:

Continue reading...

Automatic SQL Plan Management in Oracle Database 19c

Automatic SQL Plan Management in Oracle Database 19cWhen 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

Continue reading...

The new AutoUpgrade utility in Oracle 19c

The new AutoUpgrade utility in Oracle 19cOracle 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. TThe new AutoUpgrade utility in Oracle 19che 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 …

Continue reading...

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

Oracle Database 19c (19.3.0) for SPARC Solaris is available for downloadSince 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:

Continue reading...

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

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 …

Continue reading...

Oracle Multimedia will be removed in Oracle Database 19c

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

Continue reading...

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

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

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

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

Continue reading...

Oracle Database 19.2 for Exadata is now available for download

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…

Continue reading...

Oracle 19c is available in LiveSQL

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.

Oracle 19c is available in LiveSQLTry 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

 …

Continue reading...