upgrade

Windows Only: Upgrade to Oracle 18.10.0 fails with ORA-01722

Liron Amitzi reported this on his blog a few days ago already. And it is a very nasty tiny little issue happening with RUs where the second number of the release enters the two-digit-space, such as 18.10.0. At this point, on Windows Only: Upgrade to Oracle 18.10.0 fails with ORA-01722. This happens late in the upgrade phase.

What is the issue?

The problem here is a tiny little piece in %ORACLE_HOME\admin\catupstr.sql – a SUBSTR function is used in a way that it does not take into account a potential two-digit …

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

Upgrade Seminars 1 and 2 – A quick recap, slides download and more

Thank you for participating in the first two seminars. Roy and I did already the “Release and Patching Strategy” webinar on Tuesday, June 23. And today  “AutoUpgrade to Oracle 19c”. So it time for Upgrade Seminars 1 and 2 – A quick recap, slides download and more.

Upgrade Seminars 1 and 2 - A quick recap, slides download and more

Photo by v2osk on Unsplash

Slides Download

I uploaded the slides already to https://mikedietrichde.com/slides/#WEB2020. Of course, I will upload the other slide decks as well to the same location.

Seminar Recordings

As soon as the recordings page has been completed, we will send out an email. And I will post the links …

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

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

3 Live Seminars: Multitenant Seminar 3 Questions answered

This is the third and final QA blog post for the Seminars we did in the last week of April 2020. Thank you for your attendance. I will publish the replay recordings as soon as they are available and link them as well. For now, please find here 3 Live Seminars: Multitenant Seminar 3 Questions answered.

3 Live Seminars: Multitenant Seminar 3 Questions answered

Photo by Holger Link on Unsplash

Your Questions, our Answers for Seminar 3: Multitenant

103 We are in the process of migrating to Oracle Cloud using the xtts method for cross platform migration and we seem to be encountering an issue with it
Continue reading...

3 Live Seminars: Upgrade and Performance Seminar 2 Questions answered

Thanks a lot to all of you who participated also in our second seminar. Below you find now 3 Live Seminars: Upgrade and Performance Seminar 2 Questions answered.

3 Live Seminars: Upgrade and Performance Seminar 2 Questions answered

Photo by Karl Lee on Unsplash

Your Questions, our Answers for Seminar 2: Upgrade and Performance

I this blog post I answer all questions from the second seminar about AutoUpgrade to Oracle 19c and Performance Stability. Please find the links to the other QAs for Seminar 1 (Release Strategy, Patching and Cool Features) and Seminar 3 (Migration to Multitenant) below in the Links section of this blog post.

39 We need
Continue reading...

Less is more – faster Oracle database upgrades with less memory

The title of this post sounds a bit weird: Less is more – faster Oracle database upgrades with less memory. Just a few weeks ago, I posted about How long will my upgrade take … revisited. And Daniel adds a very useful piece to the upgrade speed topic. Read about his tests below.

Less is more – faster Oracle database upgrades with less memory

Photo by Franck V. on Unsplash

Less is more – faster Oracle database upgrades with less memory

by Daniel Overby Hansen, Senior Principal Product Manager,
Oracle Database Upgrades and Cloud Migrations
Less is more – faster Oracle database upgrades with less memory by Daniel Overby Hansen

Daniel Overby Hansen

Mike and I had a talk with a customer the other …

Continue reading...

3 Live Seminars: Database Upgrade and more – April 28, 29 and 30, 2020

Well, everybody does Web Seminars now, right? Just in case you sit at home next week on Tuesday, Wednesday and Thursday, you’ve just had your lunch. And you don’t know what do to in the afternoon, sign up and click in to our 3 Live Seminars: Database Upgrade and more – April 28, 29 and 30, 2020. Every day at the same time, 14:30h CET (or 13:30 GMT or 18:00 IST).

3 Live Webinars: Database Upgrade and more – April 28, 29 and 30, 2020

Photo by Sam Balye on Unsplash

Another Web Seminar?

It’s free – FIND THE REGISTATION LINKS BELOW – of course. My colleague Laura Garcia and I will talk …

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

AutoUpgrade and the COMPATIBLE parameter

Several times I’ve got asked by customers if AutoUpgrade does change the COMPATIBLE parameter. So let me explain what happens to COMPATIBLE when you upgrade. And give you also some hints about AutoUpgrade and the COMPATIBLE parameter.

AutoUpgrade and the COMPATIBLE parameter

Photo by Ivana Cajina on Unsplash

Does AutoUpgrade change COMPATIBLE?

No. Clearly, AutoUpgrade does not change the COMPATIBLE parameter for several reasons. At first, we recommend to not change the COMPATIBLE parameter right after the upgrade if you can afford another downtime soon after. By keeping COMPATIBLE on the previous (before upgrade) value, you have the choice to revert back to the previous …

Continue reading...

How long will my database upgrade take? Revisited …

I received this question twice within a few days. And I remember that a tiny little while ago I wrote something on the blog about it. But as this “while” is 11 years ago, I came to conclusion to refresh this topic – and write something about How long will my database upgrade take? Revisited …

How long will my database upgrade take? Revisited ...

Photo by Aron Visuals on Unsplash

Is there a query?

At first, before I go into details, an important fact upfront: There is neither any query nor any tool giving you a rough estimate or precise figure of how long your upgrade will

Continue reading...

Upgrade Testing – Online Clone a PDB to 19c

In the past I wrote some articles about cloning PDBs to new environments. And I added a post about RELOCATE as well. But I realized that I have no specific blog post about a very typical scenario: Upgrade Testing – Online Clone a PDB to 19c.

Upgrade Testing - Online Clone a PDB to Oracle 19c

Photo by Jørgen Håland on Unsplash

My Setup

I have an Oracle 12.2.0.1 CDB with a PDB, and another Oracle 19.6.0 CDB. I will hot clone the PDB from 12.2.0.1 to the higher version CDB, and then upgrade the PDB.

Upgrade Testing - Online Clone a PDB to Oracle 19c

The motivation to do it this way is to allow testing for the application …

Continue reading...

APEX is invalid after upgrading to 12.2 – ORA-20001

We are running the AutoUpgrade-for-RAC beta test since last week. And the first issue one customer encountered … is neither an AutoUpgrade nor a RAC issue. It has to do with APEX and SPATIAL, and missing grants. APEX is invalid after upgrading to 12.2 – ORA-20001

APEX is invalid after upgrading to 12.2 - ORA-20001

Photo by Aditya Vyas on Unsplash

What is happening?

You are doing an upgrade to Oracle Database 12.2.0.1. And you receive a number of errors during the component validation phase.

19:04:14 SQL> EXECUTE dbms_registry_sys.validate_components;
...(19:04:15) Starting validate_apex for APEX_180100
ORA-20001: MISSING GRANT: grant execute on "MDSYS"."SDO_DIM_ARRAY" to APEX_180100
ORA-20001: MISSING GRANT: grant execute on 
Continue reading...

Oracle Multitenant: Be aware of the silent COMPATIBLE change

This topic is included in our Multitenant slides for a long time. But whenever I want to point somebody to the blog post, I realize that it’s not on the blog yet. Actually I discussed this topic recently during a customer visit again. It’s time to put it on the blog. When you use Oracle Multitenant: Be aware of the silent COMPATIBLE change.

Oracle Multitenant: Be aware of the silent COMPATIBLE change

Photo by Clint Patterson on Unsplash

Mixed version environments

When you work with Oracle Multitenant, the sooner or later you will have mixed version environments. This may be CDBs with Oracle 12.1.0.2 or Oracle 12.2.0.1 together with …

Continue reading...

The new Oracle 19c Hands-On Lab is available now for download

Wow, this took a long while. Thanks to my team mate, Data Pump Product Manager Bill Beauregard who went through the complex approval process, the new Oracle 19c Hands-On Lab is available now for download. And in addition, I adjusted the instructions on the blog as well.

The new Oracle 19c Hands-On Lab is available now for download

Photo by Kenrick Mills on Unsplash

What you’ll get …

At first, the download is huge. All together, you will download 13 files summing up to 25GB. When you unzip it, you will get an OVA file. Then you will need to import this appliance into Oracle VirtualBox. The lab will …

Continue reading...

OOW London 2020 – Upgrade Talk and more

Since last year we organize regional Oracle Open World conferences. Not as big as the one in San Francisco (or in Las Vegas this and the following years), but still an exciting event. And for me, it will be the first time in a week to attend and speak at OOW London. Let me give you a very quick overview on our OOW London 2020 – Upgrade Talk and more.

OOW London 2020 - Upgrade Talk and more

Photo by James Padolsey on Unsplash

Upgrade Best Practices – Thursday, Feb 13 – 13:50-14:25h – Arena B – Zone 2

No idea who has cut down the tech …

Continue reading...

Do you need to license Java for AutoUpgrade?

Actually this question came up internally. I did have no doubt that you don’t have to license Java in order to use AutoUpgrade. But a colleague had such doubts. So let’s clarify: Do you need to license Java for AutoUpgrade?

Do you need to license Java for AutoUpgrade?

Photo by nousnou iwasaki on Unsplash

Or phrased in a different way: “Since Java 8 requires a Java subscription now. Does autoupgrade come with a license?

Do you?

Of course, No!

But where do the doubts come from? Actually this link here does not list the “Oracle Database” as a product. But there is this MOS Note

Continue reading...

Upgrade PDBs with RELOCATE – How does it work?

Today Roy and I received a question from a colleague about the RELOCATE feature in Multitenant. And I’d like to shed some light and this topic a bit more. Upgrade PDBs with RELOCATE – How does it work?

Upgrade PDBs with RELOCATE - How does it work?

Photo by Sebastian Pena Lambarri on Unsplash

RELOCATE and UPGRADE?

At first, it looks very promising to me. RELOCATE uses the HOT CLONE functionality of Multitenant but then relocates the PDB from one to another CDB. You need to fulfill a few important requirements, for instance:

  • Local Undo must be enabled in both CDBs
    • This limits the technique to at least Oracle
Continue reading...

Do you need STARTUP UPGRADE for OJVM?

Actually I carry around this topic with me since the October 2019 workshop in Dubai. We’ve had one of these OJVM Patching discussions I’d like to escape usually. Anyhow, during this session, it dawned me that the STARTUP UPGRADE requirement in the OJVM readme may be not correct anymore. So the question will be: Do you need STARTUP UPGRADE for OJVM?

Do you need STARTUP UPGRADE for OJVM?

Photo by Nik Shuliahin on Unsplash

A little bit of history

You will find a good amount of blog posts about OJVM here. OJVM stands for Oracle Java Virtual Machine. It is a very powerful thing and allows you …

Continue reading...

January 2020 AutoUpgrade is available for download

All of you upgrading your databases with AutoUpgrade or planning to do so can now download the newest version of our AutoUpgrade tool. We are offering the 20191220 version. If you ask yourself why we release the December version in January 2020, there’s a simple answer. We do extensive system testing with it before releasing it to the public.

January 2020 AutoUpgrade is available for download

Photo by pixel | visuals – Patrick Humm on Unsplash

Download 20191220 AutoUpgrade

You can always download the newest and some previous versions of the AutoUpgrade tool via this note:

January 2020 AutoUpgrade is available for download

At the bottom of the …

Continue reading...

GI Patch 28553832 may be needed before you upgrade to 19c

Thanks to my colleague Sebastian Alasino who works in the MAA team out of the UK. Sebas highlighted this issue to. And I’d like to share it with you when you attempt to upgrade Grid Infrastructure to Oracle 19c. If you have the Docker RPM  installed and you were lazy on patching, then GI Patch 28553832 may be needed before you upgrade to 19c.

GI Patch 28553832 may be needed before you upgrade to 19c

Photo by Daniel Frank on Unsplash

What is the issue?

If the Docker Engine RPM is installed and your GI version is 12.1.0.2, 12.2.0.1 or 18c below a certain patch level, the CSSD demon fails to …

Continue reading...

ORA-1722 when upgrading to 19.4.0 or 19.5.0 on Windows

Oh boy – I try to avoid blogging about errors on a specific platform. But as this topic was brought to my attention now 3x in 2 weeks, I think I’ll send it out. And I hope you won’t hit this ORA-1722 when upgrading to 19.4.0 or 19.5.0 on Windows.

ORA-1722 when upgrading to 19.4.0 or 19.5.0 on Windows

What is failing?

The database upgrade only on the MS Windows platform fails when you attempt to upgrade to 19.4.0 or 19.5.0. This means, you downloaded and installed 19.3.0. And then you followed our advice and applied one of the most recent Release Update – ideally 19.5.0, the October …

Continue reading...

Video: Best Practices to Upgrade to Oracle Database 19c

This is a short “Black Friday” blog post. And just if you are tired already of hunting supposed-to-be-bargain-buys, you may need something to relax – and watch this Video: Best Practices to Upgrade to Oracle Database 19c.

Video: Best Practices to Upgrade to Oracle Database 19c

Roy recorded it as part of the Quest Experience Week. We’d like to share it with you here.

Just click on the picture below to open a new TAB and watch the 1 hour video:

 

If you are looking for the slide deck, you can download them from:

Thanks!

–Mike…

Continue reading...