Oracle Database 19c

Data Pump Bundle Patches: You may need to download and apply again

The Data Pump Bundle Patches get released on top of every RU since over a year now. But a real issue with missing files got detected recently. So in case you had applied Data Pump Bundle Patches: You may need to download and apply again.

Data Pump Bundle Patches: You may need to download and apply again

Photo by Khamkéo Vilaysing on Unsplash

What is in the Data Pump Bundle Patch?

The Data Pump Bundle Patch is a convenient and very useful vehicle to apply Data Pump patches which are usually not included in a Release Update (RU). While RUs are per definitionem RAC-rolling and Standby-First, the Data Pump Bundle …

Upgrade to Oracle 19c on Exadata with AutoUpgrade

Posted on June 16, 2021 by Mike.Dietrich Exadata / ODA Oracle Database 19c 23

This will be a short but very important blog post for those of you with Exadata systems. Then you should Upgrade to Oracle 19c on Exadata with AutoUpgrade.

Upgrade to Oracle 19c on Exadata with AutoUpgrade

Photo by Lindsay Henwood on Unsplash

Why is this important?

Until a week ago, the database upgrade MyOracle Support (MOS) note showed the process using the DBUA. And we had plenty of customers asking us why AutoUpgrade isn’t mentioned there. Our team worked already with some of you, and we knew that AutoUpgrade works perfectly fine and takes over some manual actions.

But our MAA team wanted a perfect solution. They …

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

Oracle 19c Installation with 19.11.0 RU, OJVM and some other fixes

Posted on April 22, 2021 by Mike.Dietrich Installation Oracle Database 19c Patch Recommendation 40

In an previous blog post we showed how to install and patch in one single action. And as I use this technique all the time when I setup new homes, would like to show you an Oracle 19c Installation with 19.11.0 RU, OJVM and some other fixes. The purpose of this blog post is mainly to demonstrate again how you can install and patch in one action. But also to help you avoiding a pitfall when you apply the OJVM RU from April 2021.

Oracle 19c Installation with 19.11.0 RU, OJVM and some other fixes

Photo by Sammy Williams on Unsplash

What do we need?

At first, let us …

Oracle 19c on Windows may flood your trace file directory

Posted on March 11, 2021 by Mike.Dietrich Flaws and Pitfalls Oracle Database 19c 21

Oh … it’s Windows week here. And all this even though since I didn’t install Oracle on Windows for quite a while. But of course I’m fully aware that many of you out there operate Oracle on Windows. In this particular case thanks to Joël for the pointer to this issue. Oracle 19c on Windows may flood your trace file directory.

Oracle 19c on Windows may flood your trace file directory

Photo by Daniel von Appen on Unsplash

What happens?

In every release of Oracle 19c, at least until 19.10.0 BP, you may find out that every few minutes a trace file gets written into the %ORACLE_BASE%\diag\..\..\trace directory. And all …

ORA-12638 on Windows only from Oracle 19.10.0 onwards

Posted on March 10, 2021 by Mike.Dietrich Behavior Change Flaws and Pitfalls Oracle Database 19c 48

You like unexpected changes and surprises, don’t you? And especially those which aren’t in the patch notes or the docs. I blogged about such changes a few weeks ago. And thanks to the people reading this blog, I learned now about another change with Oracle 19.10.0 on the Windows platform. You may receive now an ORA-12638 on Windows only from Oracle 19.10.0 onwards.

ORA-12638 on Windows only from Oracle 19.10.0 onward

Photo by Fanny Rascle on Unsplash

What has been changed?

So at first, thanks to Ernst and Marcus for bringing this to my attention. This is an issue which happens on MS Windows only.

When you …

Oracle Database 19.10.0 and Blockchain Tables and COMPATIBLE

Posted on February 18, 2021 by Mike.Dietrich Behavior Change Oracle Database 19c Parameters Patch Recommendation 4

Many of you recognized that we delivered a new feature with Oracle Database 19.10.0, the January 2021 Release Upgrade. So I’d like to put a few interesting things together from the upgrade and migration perspective regarding Oracle Database 19.10.0 and Blockchain Tables and COMPATIBLE.

Oracle Database 19.10.0 and Blockchain Tables and COMPATIBLE

Photo by Daniel von Appen on Unsplash

What are Blockchain Tables?

At first, I don’t want to repeat what other people have blogged and written about already. You may just go through the blog posts of Connor McDonald and Tim Hall and others to learn more about this cool feature.

Connor McDonald about “Blockchain

Download the newest AutoUpgrade for 19c and 21c upgrades

Posted on December 16, 2020 by Mike.Dietrich AutoUpgrade Oracle Database 19c Oracle Database 21c 35

It’s out now and available since yesterday: AutoUpgrade 21c. Download the newest AutoUpgrade for 19c and 21c upgrades with many new features and improvements.

Photo by Jordan McGee on Unsplash

Download it!

This is the current version of AutoUpgrade:

build.hash 8ee6880
build.version 21.1.1
build.date 2020/12/14 14:41:34
build.max_target_version 21
build.supported_target_versions 12.2,18,19,21
build.type production
48 bug fixes since v21.0.0 release
Tag: v21.1.1
Description: This is the release for 21.1.1 MOS only

As usual, download it please from:

MOS Note: 2485457.1 – AutoUpgrade Tool

What’s new?

Non-CDB to PDB Upgrades
- AutoUpgrade can upgrade and convert a non-CDB to a PDB in a new

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 …

Upgrade fails with ORA-20001 during datapatch run

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

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 …

Automatic SQL Plan Management – Slight Change with 19.4.0

Posted on October 2, 2019 by Mike.Dietrich Oracle Database 19c SPM - SQL Plan Management 2

I did blog in more detail about Automatic SQL Plan Management in Oracle 19c. And Roy and I had really a lot of discussion in every customer meeting at OOW19 about it. But there is a slight change to where the feature is available with Oracle 19.4.0.

Photo by Samuel Zeller on Unsplash

Slight Change

When you compare the settings of SQL Plan Management between Oracle 19.3 and 19.4, you’ll see the difference:

column parameter_value format a45
column parameter_name format a25
set pages 200

SELECT PARAMETER_NAME, PARAMETER_VALUE
  FROM   DBA_ADVISOR_PARAMETERS
  WHERE  TASK_NAME = 'SYS_AUTO_SPM_EVOLVE_TASK'
    AND PARAMETER_VALUE <> 'UNUSED'
  ORDER

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 …

Oracle Database 19c (19.3.0) for HP-UX and AIX is available for download

Posted on May 31, 2019 by Mike.Dietrich Oracle Database 19c 6

For a few days, in addition to Linux and SPARC Solaris, Oracle Database 19c (19.3.0) for HP-UX and AIX is available for download now as well. The missing platforms, Windows, Intel Solaris and zLinux should be available soon as well.

Oracle Database 19c on premises for HP-UX and AIX

You can download Oracle Database 19.3.0 on-prem for HP-UX ia64 and IBM AIX from the usual sources:

Oracle 19c Documentation

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

See especially the operating …

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 19c preupgrade.jar and preupgrade checks

Posted on March 18, 2019 by Mike.Dietrich Oracle Database 19c 9

Oracle Database 19c is available for Exadata on-prem for quite a few weeks now. But even if you didn’t download it yet, you may want to use the new 19.2 preupgrade.jar tool to check and examine your database. For this purpose you can find the Oracle 19c preupgrade.jar and preupgrade checks available and documented on MOS.

Oracle 19c preupgrade.jar and preupgrade checks

I received several emails already from customers asking whether they can get the most recent Oracle 19c preupgrade tool without downloading the entire 19c software stack. And thanks to my team mates, the tool is available now in …

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

What is in the Data Pump Bundle Patch?

Why is this important?

What is the Messaging Gateway?

What do we need?

What happens?

What has been changed?

What are Blockchain Tables?

Download it!

What’s new?

Unified Auditing

It all starts with an upgrade

Slight Change

Oracle Database 19c on premises for Windows and zLinux

Oracle 19c Documentation

What is changing in Oracle 19c?

Oracle Database 19c on premises for HP-UX and AIX

Oracle 19c Documentation

Oracle Database 19c on premises for Linux

Oracle 19c Documentation

Oracle 19c preupgrade.jar and preupgrade checks

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

Follow me on Twitter

Recent Posts