oracle 19c

Sign up for the Upgrade 19c Virtual Classroom Seminars for the US, Canada and LAD

It took a while. And many of you asked whether we will run our Virtual Classroom Seminars we ran successfully for Australia and New Zealand in April and from June to now in EMEA for the US, Canada and South and Latin America time zones as well. And we do. It’s time to Sign up for the Upgrade 19c Virtual Classroom Seminars for the US, Canada and LAD.

Everything you need to know about Upgrade, Migration and Consolidation

When we ran these events especially for EMEA, a lot of colleagues asked us whether …

Continue reading...

Download the newest AutoUpgrade for 19c and 21c upgrades

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.

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:

What’s new?

  • Non-CDB to PDB Upgrades
    • AutoUpgrade can upgrade and convert a non-CDB to a PDB in a new
Continue reading...

Apply Patch 31088341 before Upgrade to prevent ORA-1403

As I learned from a customer this week, this patch is a must have when you use Partitioning and you attempt to upgrade to Oracle 19.9.0 or earlier. So please apply patch 31088341 before Upgrade to prevent ORA-1403 happening.

Apply Patch 31088341 before Upgrade to prevent ORA-1403

Photo by Grant Durr on Unsplash

What is the issue?

This applies to all 19c upgrades at least until 19.9.0. You may see this error pattern in catupgrd0.log:

==Error from catupgrd0.log===

=================================================================
20:34:11 SQL> Rem BEGIN bug 28757685: repair tabpart$
20:34:11 SQL> Rem
=========================================================================
20:34:11 SQL> /* bug 28757685: tabpart$.hiboundval and tabpart$.hiboundlen
are incorrect
20:34:11 SQL> * when tables are 
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...

ORA-1555 won’t get reported into alert.log anymore since 19.4.0

Many thanks to a German customer for showing me this tiny behavior change with Oracle Database RU 19.4.0. From this RU on the well known ORA-1555 won’t get reported into alert.log anymore since 19.4.0. But if you still like to see the “snapshot too old” error, then you can use a workaround.

Why has this been changed?

Actually this is something I don’t understand completely. It may be just a side effect. Unpublished fix bug 29424999 – DUMP MINIMAL DIAGNOSTICS BY DEFAULT IN CASE OF ORA-01555 IN ADW/ATP ENV has been

Continue reading...

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

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.

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;
Continue reading...

Web Seminar MEA – Recap, Slides, Recording and Answers

A few weeks ago, on June 29, 2020, I delivered an Upgrade Web Seminar for the MEA region. Thanks a lot if your participated. And today I’d like to share with you for this Web Seminar MEA – Recap, Slides, Recording and Answers.

Web Seminar MEA - Recap, Slides, Recording and Answers

Photo by Nathan John on Unsplash

Recap

Thanks to those who found the time to participate. I enjoyed the hour a lot. And thanks also to my colleagues from Oracle Dubai who set up the session and handled the registration and the logistics.

Slides

You can download the slides for this session as usual from the Slides

Continue reading...

Collection of EBS upgrade information for Oracle Database 19c

This was the question I received the most often during the Virtual Classroom web seminars last week: “Can you say something about EBS upgrades with 19c?”. And I promised to publish a blog post about it. But as I’m not an EBS expert, I can only share a Collection of EBS upgrade information for Oracle Database 19c. For all further inquiries, please open an SR or get in touch with your Oracle contact.

Recap – EBS and Oracle 19c

In September 2019, right before Oracle Open World, we announced the certification of EBS …

Continue reading...

Oracle Long Term Support vs Innovation Releases

Earlier this week I wrote about the recent exciting news: Oracle Database 19c Premier Support extended by more than 1 year. But if you went to MOS 742060.1 to read the fine print, you may have spotted another change as well: A differentiation between Oracle Long Term Support vs Innovation Releases.

Oracle Long Term Support vs Innovation Releases

Photo by Bruno Martins on Unsplash

What is a Long Term Support Release?

MOS 742060.1 explains:

Oracle Database Long Term Releases are ideal for use cases that benefit from less frequent upgrades to newer releases. Long Term Releases offer the highest level of stability and the l

Continue reading...

Upgrade to Oracle Database 19c – Virtual Classroom Series

Roy and I delivered a similar seminar already for the Australia and New Zealand region. And now it is time at a more convenient time zone setting for EMEA and India. So if you are not tired of web seminars yet, please sign up for our Upgrade to Oracle Database 19c – Virtual Classroom Series.

Upgrade to Oracle Database 19c - Virtual Classroom Series

Photo by Bima Rahmanda on Unsplash

4 Web Seminars – Going far beyond upgrades

The idea for this series of 4 web seminars is to cover not only the database upgrade itself. You will get much more than technical upgrade information. And we will …

Continue reading...

Do you love unexpected surprises? SYS_AUTO_STS in Oracle 19.7.0

Last week I recorded seminars – and I wanted to garnish the Performance part with demo recordings from our Hands-On Lab. I used the Hands-On Lab instructions we published. And while I edited a recording, I realized that there was something new I haven’t seen before. Do you love unexpected surprises? SYS_AUTO_STS in Oracle 19.7.0? Of course you do …!

Do you love unexpected surprises? SYS_AUTO_STS in Oracle 19.7.0

Photo by Pete Wright on Unsplash

What happened?

In my environment I run load against my database, I collect statements from AWR and from Cursor Cache into two separate SQL Tuning Sets (STS). And then I upgrade my …

Continue reading...

Of course, Oracle Clusterware is certified on OL8/RHEL8 as well

To be very honest, when I posted a few days ago, Oracle Database 19c is certified on OL8/RHEL8 I didn’t check for the Oracle Clusterware (OCW) certification. I blindly assumed that this is the case. But from comments and discussions on twitter, I realized it may be necessary to point this out explicitly to avoid confusion. Even though my fellow mate, RAC Product Manager Anil Nair has pointed it out already many times: Of course, Oracle Clusterware is certified on OL8/RHEL8 as well.

Of course, Oracle Clusterware is certified on OL8/RHEL8 as well

Photo by Angela Hobbs on Unsplash

Find it on MOS

Your source for certification information …

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...

4+1 Seminars: Upgrade, Migrate, Consolidate to 19c – not only for Australia

Actually this weekend Roy and I would have flown from Australia to New Zealand. We planned at least 5 seminars. And we’ll do them in person as soon as conditions allow. If you are not tired yet of all these seminars offered to you, then we have the right offering for you.

And not only for those of you based in Australia and New Zealand. Singapore, Japan, Korea and other countries in this part of the globe. Roy and I will run for 4+1 Seminars: Upgrade, Migrate, Consolidate to 19c – not only for

Continue reading...

Upgrade Testing with a Refreshable PDB – does this work?

Yesterday, Daniel pinged me to discuss an upgrade testing scenario I had evaluated briefly by myself a while ago. I can’t remember why I gave up. But Daniel had some great ideas and tried already a lot in our OCI cloud. We want to use a refreshable PDB. And keep it up to date, then upgrade it. The idea of this approach: Whereas a CLONE or RELOCATE uses the initial command as the marker, a REFRESH would allow me to be way more in synch. So the question is: Upgrade Testing with a Refreshable PDB – does this work?

Upgrade Testing with a Refreshable PDB - does this work?

Photo

Continue reading...

OJVM datapatch fails with ORA-29532 – but the root cause is noncdb_to_pdb.sql

Kudos to Robert Ortel who brought this nice misbehavior to my attention. And even though it looks like this would be an OJVM issue, it is caused by noncdb_to_pdb,sql, the script which is used to convert a non-CDB to a PDB. When you apply an OJVM patch, OJVM datapatch fails with ORA-29532 – but the root cause is noncdb_to_pdb.sql.

OJVM datapatch fails with ORA-29532 - but the root cause is noncdb_to_pdb.sql

Photo by Alexandra Gorn on Unsplash

It’s a bit tricky

First things first. This is not a blog post to blame OJVM. The problem just happens because datapatch for an OJVM patch touches data in the dictionary which hasn’t …

Continue reading...

To which release should you upgrade to? Revisited …

I’ve had so many discussions with customers and partners, and also with colleagues in the past weeks and months about the support time frames for Oracle Database 12.2. Now I checked the blog, and I found so many posts about support periods. And I wrote a similar blog post already 1.5 years ago. I think it’s time to summarize all that. And give you some guidance as well about to which release should you upgrade to? Revisited …

To which release should you upgrade to? Revisited ...

Photo by eberhard grossgasteiger on Unsplash

Overview

Basically there are 2 sources to learn about Support time frames for the database release:…

Continue reading...

Is Oracle Fail Safe 4.2.1 certified with Oracle Database 19c?

From time to time I get questions regarding the certification of Oracle Fail Safe. And just the other day, a customer asked: Is Oracle Fail Safe 4.2.1 certified with Oracle Database 19c? I briefly browsed my blog posts about Oracle Fail Safe from the past, and even though I mentioned that the certification for 4.2.1 on Oracle 12.2.0.1 may apply to later versions, I never updated it.

Is Oracle Fail Safe 4.2.1 certified with Oracle Database 19c?

Is Oracle Fail Safe 4.2.1 certified with Oracle Database 19c?

Yes, it is. But you may want to know where you can read and find this information.

The latest version of Oracle Fail …

Continue reading...

New version of Upgrade / Migrate / Consolidate to Oracle 19c uploaded

Please apologize that it took me a bit longer to upload a new version of our comprehensive slide deck. You can download now a new version of “Upgrade / Migrate / Consolidate to Oracle 19c” via the blog’s download page.

New version of Upgrade / Migrate / Consolidate to Oracle 19c uploaded

Why is there a new version?

Since Oracle Open World 2019 we have a new corporate template. And while I like the graphics quite a bit, I’d say, the people who built it have a good sense for graphics. But they aren’t powerpoint experts. In fact, almost every slide had to be adjusted. This may not be a huge …

Continue reading...

Oracle Fail Safe is deprecated with Oracle Database 19c

I wanted to put this on the blog for quite a while but forgot to do so. Since Oracle Database 19c, Oracle Fail Safe has been deprecated. What does this mean?

Oracle Fail Safe is deprecated with Oracle Database 19c

Oracle Fail Safe is deprecated – Photo by Cristina Gottardi on Unsplash

Deprecation of Oracle Fail Safe

First of all, deprecated does not mean desupported. Oracle Fail Safe is still fully supported. But since Oracle 19c, you will find this note in the Windows Admin Guide:

Deprecation of Oracle Fail Safe

Oracle Fail Safe is deprecated as of Oracle Database 19c. It can be desupported and unavailable in

Continue reading...

Oracle EBS 12.2 on-prem is now certified with Oracle 19c – and will become a PDB

Great news – and I’m just putting the pieces together. Oracle EBS 12.2 on-prem is now certified with Oracle 19c.

Oracle EBS 12.2 on-prem is now certified with Oracle 19c - and will become a PDB

Photo by Charles Forerunner on Unsplash

Plan your upgrade(s)

You can plan your EBS and database upgrades now. I know from discussions at conferences and workshops, that customers felt locked in on older databases releases. As a result, we waived the Extended Support for the database for those who still are on Oracle 11.2.0.4 and 12.1.0.2 as database for an EBS installation.

Please be aware that the certification as of now includes only Linux and SPARC Solaris platforms. …

Continue reading...

Behavior Change in Oracle 18c/19c: No symbolic links for Data Pump directories

Most of you may have recognized the desupport of UTL_FILE_DIR with Oracle Database 18c. Reason is mostly that UTL_FILE_DIR opens a lot of possibilities to do insecure things. But this has another effect which may not be obvious to you. There’s a behavior change in Oracle 18c/19c: No symbolic links for Data Pump directories. Read further to learn more about it.

UTL_FILE_DIR Desupport

In Oracle Database 18c we announced the desupport of UTL_FILE_DIR initialization parameter. But as you can read as well in the Database Upgrade Guide, there’s this remark:

UTL_FILE Package Symbolic Link in Directory Paths Not Supported

Continue reading...

AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes

AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes

Photo by Debby Hudson on Unsplash

In the previous blog posts I explained mainly how to create, alter and tweak the configuration file for the AutoUpgrade tool. By now you should have your config file set up and adjusted for your environment(s). Let me go a step further and explain the different processing modes of AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes. Then you’ll have a precise idea what the tool is actually doing, and how it operates.

AutoUpgrade – Step-by-step

  1. The new AutoUpgrade Utility – Download, documentation and supported versions
  2. Create and adjust the config file for
Continue reading...