19c

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

When Fixed Object Stats Gathering takes very long during upgrade …

Over the past days I exchanged several emails with a very important customer regarding Fixed Objects Stats gathering in relation to database upgrade. The customer found out that it takes very long in their environment – over an hour to be precise. Relaxing on the weekend helped me a bit. And this morning, it dawned me that I’ve had two similar cases before already. Plus I didn’t blog about it yet. Now it’s time to tell you a little but about Unified Auditing and the situation when Fixed Object Stats Gathering takes very long during upgrade …

When Fixed Object Stats Gathering takes very long during upgrade ...

Photo by Ayse

Continue reading...

Oracle Database 12.1.0.2 certified on Oracle Linux 8 and RHEL8

The other day I received a question on Twitter regarding my experience with Oracle 12.1.0.2 on Linux 8. I first thought this may be an error. Why should Oracle 12.1.0.2 been certified on Linux 8. And I didn’t see anything internally about Oracle Database 12.1.0.2 certified on Oracle Linux 8 and RHEL8.

Oracle Database 12.1.0.2 certified on Oracle Linux 8 and RHEL8

Photo by NOAA on Unsplash

But it is true …

Thanks to Marian Bednar (Thanks a lot!!) who couldn’t find any information on my blog, now I know. Marian pointed me to the Release Notes Oracle Database 12.1.0.2. They’ve got updated in July 2020 already …

Continue reading...

Which database version can be used with Grid Infrastructure 19c?

This will be a very short blog post today. But a colleague asked me this question just a few minutes ago: Which database version can be used with Grid Infrastructure 19c? And I realized that I neither put it on the blog yet nor did I bookmark it. But I answered this question several times already.

Which database version can be used with Grid Infrastructure 19c?

There are 4 sources I did check:

  • MOS Notes on MyOracle Support
  • Oracle Documentation
  • Certification Information on MyOracle Support
  • Database Upgrade Blog

At first, I answered with MOS

Continue reading...

Transportable Tablespaces: Keep tablespace files read-only

When you Transport Tablespaces, you may be aware of a change in behavior a long while ago. When your tablespace import has been finished, a tablespace will be taken read-write automatically. But there may be situations when you’d like the previous behavior. Now you can have this with Transportable Tablespaces: Keep tablespace files read-only.

Transportable Tablespaces: Keep tablespace files read-only

Photo by freestocks on Unsplash

Default Behavior

Since Oracle Database 12c a tablespace will be taken read-write once the meta data import has been completed automatically. This was different in previous database releases. We used the technique a long time ago for a telco provider …

Continue reading...

Test Transportable Tablespaces without Read-Only Mode

From time to time I deal with Transportable Tablespaces as an upgrade and migration approach. But TTS has one major flaw, especially when databases get really really big in the 3-digit-terabyte sizes or more: You will need to switch your tablespaces into read-only mode. But since Oracle Database 19c, you can Test Transportable Tablespaces without Read-Only Mode.

Test Transportable Tablespaces without Read-Only Mode

Photo by freestocks on Unsplash

Transport Constraints

Transportable Tablespaces (TTS) is a very common technique, especially when you need to migrate databases across Endianness. Since Oracle 10g, TTS works even from Big Endianness to Little Endianness platforms, and vice versa. Only if …

Continue reading...

Oracle DB Upgrade Web Seminar (Deutsch) für CH

Wann? 15. September 2020 um 10:00h bis 12:00h

Wo? Leider nur virtuell

Was? Oracle 19c Upgrade Web Seminar

Was muss ich tun? Hier geht es zur Registrierung.

 

Mehr Information

Oracle DB Upgrade Webinar mit Mike Dietrich, Master Product Manager, Database Upgrades & Utilities

Oracle Database 19c ist ein Meilenstein in Oracle’s Übergang zu einer agileren Release-Strategie.

Als erste Langzeit Support-Version ist Oracle 19c “die” Version, mit der Sie Ihre Datenbanken aktualisieren können, um die neuesten Funktionen zu nutzen, viele davon ohne Extra-Lizenz.

In diesem Upgrade Webinar erfahren Sie, wie Sie Upgrades reibungslos planen und durchführen, mit AutoUpgrade Zeit

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

MGA Issue – and it is fixed with Oracle 19.8.0 and newer

Where do I start? One of the customer accounts I worked the longest time with recently upgraded to Oracle 19c on Exadata. They are an Exadata customer since 2009. After going live on 19c, a few days later they hit an MGA Issue – and it is fixed with Oracle 19.8.0 and newer. But question no.1 was: Why hasn’t Oracle warned us – and how could we have learned about it?

MGA Issue - and it is fixed with Oracle 19.8.0 and newer

Photo by Scott Webb on Unsplash

What is the MGA?

OK, I have heard of SGA and PGA. But MGA? The first two hits when I search with …

Continue reading...

AutoUpgrade and the Partial Offline Backup Strategy

In our Fallback talk we promote a backup strategy for large DWHs and database which are on purpose in NOARCHIVELOG mode. But last week I learned that there is something important to know about AutoUpgrade and the Partial Offline Backup Strategy. Otherwise you may hit a

AutoUpgrade and the Partial Offline Backup Strategy

Photo by Esri Esri on Unsplash

pitfall.

 

Partial Offline Backup Strategy?

I won’t explain in all details what this is. If you’d like to read more, please find all the necessary information on my blog post from July 17, 2018:

with graphics included. In brief, you take …

Continue reading...

Cloud Migrations: The New Kid on the Blog – DOHDATABASE.com

You may have realized that you will find mostly on-prem database upgrade and migration topics covered on my blog. Which doesn’t mean that you can’t use most of these techniques to migrate to the cloud either. But it’s really hard to write about everything in full detail. Hence, today I’d like to introduce you to Cloud Migrations: The New Kid on the Blog – DOHDATABASE.com. And no, I was never a fan of this American boyband from the 80s and 90s 😉

Cloud Migrations: The New Kid on the Blog - DOHDATABASE.com

Find Daniel’s blog at: https://dohdatabase.com

DOHDATABASE … huh?

Cloud Migrations: The New Kid on the Blog - DOHDATABASE.com

Daniel Overby Hansen

As you may have read a …

Continue reading...

Oracle AutoUpgrade between two servers – and Plugin?

In my previous blog post I demonstrated how you can upgrade with AutoUpgrade between two servers. This a very typical scenario where you get new server, often also with a newer operating system version installed. But I was wondering if you can use Oracle AutoUpgrade between two servers – and Plugin?

AutoUpgrade between two servers

Please see my previous blog post about all the details:

Upgrade and Plugin?

At the end of it, I was curious if I couldn’t just plugin afterwards. But I …

Continue reading...

AutoUpgrade with Transparent Data Encryption (TDE)

I knew, one fine day I will have to dig into TDE. Resistance is futile. There were so many questions regarding AutoUpgrade with Transparent Data Encryption (TDE) in the past weeks and months. And the team is still working hard on a solution to make the non-CDB to PDB plugin flawless and automated for such cases. But I won’t cover the latter in this post here. I will solely focus on the database upgrade itself.

AutoUpgrade with Transparent Data Encryption (TDE)

Photo by Jason Dent on Unsplash

TDE?

Almost everybody of you reading this blog post may have more knowledge of Transparent Data Encryption than I. …

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

Upgrade Seminars 2020 – Recap and Videos on-demand

Thank you for participating in our 4 Database Upgrade to Oracle 19c seminars in the past two weeks. There were over 800 questions during the seminars – and it was a good idea that we prerecorded them. This way, I could answer your questions as it was a more convenient time for me than for Roy. We enjoyed it a lot – and from the feedback I read, most of you enjoyed it, too. Now please read about Upgrade Seminars 2020 – Recap and Videos on-demand below.

The Slides

I uploaded all 4 decks …

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

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

Does your GI RU/RUR patch level has to match your database’s?

A long while ago I blogged about whether you should keep your patch versions between Grid Infrastructure and Databases Homes in synch, or not. And today, Daniel dropped me a note mentioning that this old blog post may need an update for 18c/19c. He’s right. And as I’ve had trouble finding my old blog post, I title this one a bit more obvious: Does your GI RU/RUR patch level has to match your database’s?

Does your GI RU/RUR patch level has to match your database's?

Photo by Vincent van Zalinge on Unsplash

Before Oracle Database 18c

Since Oracle 18c we move from a 5-number release schema to a 3-number one. …

Continue reading...

DBMS_JOB one-off patch needed for Oracle 19.3.0 – 19.7.0

A while ago I blogged already about this behavior change for DBMS_JOB in Oracle Database 19c. Many of you are aware of this. But today I learned something new about it. Kudos to Alexey Makhmutov for bringing this to my attention. There is a very important fix you will need on top in 19c to avoid performance issues. If you rely on jobs with the old job interface, take note: DBMS_JOB one-off patch needed for Oracle 19.3.0 – 19.7.0

DBMS_JOB one-off patch needed for Oracle 19.3.0 - 19.7.0

Photo by Christopher Burns on Unsplash

What is the problem?

As you can read from there is a internal …

Continue reading...

AutoUpgrade and Plug In to a CDB – with a single command (and video)

I have to confess, this feature is out and available for quite a while. But only unofficially. AutoUpgrade can upgrade and plug in a non-CDB into a CDB. But it lacked flexibility. And we didn’t test it a lot. Hence, you could find it documented in our Hands-On Lab instructions. And we did this exercise with you already in our sold-out labs at OOW 2019 as well. But since a week and a bit, it is officially supported: AutoUpgrade and Plug In to a CDB – with a single command (and video).

AutoUpgrade and Plug In to a CDB - with a single command (and video)

Photo by William Daigneault on Unsplash

Create

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

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