DOAG Conference 2019 – Our talks in Nürnberg next week

Posted on November 11, 2019 by Mike.Dietrich Conference 0

Time flies so quickly. And in case you wondered about the silence on the blog and on twitter, I was either traveling the past weeks or on holidays. But it’s November. And November is DOAG conference month. So please find an overview about DOAG Conference 2019 – Our talks in Nürnberg next week.

DOAG Conference 2019 - Our talks in Nürnberg next week

DOAG – When, where, why?

Actually DOAG (German Oracle User Group) conference is one of the most important events for me every year. Not only because since far over a decade in my hometown, Nürnberg, Franconia, but for me it means meeting with a lot of …

DBMS_PDB.DESCRIBE – Something to be aware of

Posted on October 28, 2019 by Mike.Dietrich Single-/Multitenant 2

When I wrote up my long blog post series about how to migrate to Multitenant, I came across an interesting behavior. I could create the XML manifest file to plugin without putting the database in read-only mode. But I learned afterwards that there are is a pitfall. Hence, this blog post will talk about DBMS_PDB.DESCRIBE – Something to be aware of.

DBMS_PDB.DESCRIBE - Something to be aware of

DBMS_PDB.DESCRIBE – why and when?

You will use the DBMS_PDB.DESCRIBE call for the sole purpose to create the so called XML manifest file. This file contains information about the non-CDB to plugin afterwards. You either generate it check …

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

Posted on October 24, 2019 by Mike.Dietrich Slides 0

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 …

Oracle Fail Safe is deprecated with Oracle Database 19c

Posted on October 18, 2019 by Mike.Dietrich Fail Safe 0

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

Patching all my environments with the Oct 2019 Patch Bundles

Posted on October 17, 2019 by Mike.Dietrich Patch Recommendation 12

Yesterday I blogged about the Oct 2019 Patch Bundles being available for download. And while I wrote this blog post, I downloaded all of them for my environments. Here I’d like to share with you the most simple path to apply them. As I have no cluster or ASM, I don’t have to patch Grid Infrastructure. And I don’t even have OJVM in any of my databases right now. Due to space constraints in my lab environment I will apply the patches in-place. You shouldn’t do this but instead use always a new home you patch. This allows you …

CPU October 2019 Patch Bundles are available

Posted on October 16, 2019 by Mike.Dietrich Patch Recommendation 2

As of Oct 15, 2019, the CPU October 2019 Patch Bundles are available for download. So let me do the quarterly exercise to download and install all of them into my various environments.

CPU October 2019 Patch Bundles are available

Critical Patch Alert October 2019

At first, I check the Alert and the Risk Matrix whether critical issues with a high risk score are included. I will install the patch bundles anyway, but I’m curious. In my particular case I will take care on the database only. You of course will check for other products you are using, too.

Market Driven Support for Oracle Database 11.2.0.4

Posted on October 10, 2019 by Mike.Dietrich Release Schedule 1

I know that some of you are still on Oracle 11.2.0.4. And I don’t want to argue, why. I’m pretty sure there’s a good reason that you haven’t upgraded yet. Just remember: You can upgrade directly from Oracle 11.2.0.4 to Oracle 19c. Just in case you plan to stay longer than end of 2020 on this ancient release, then you may want to read about the Market Driven Support for Oracle Database 11.2.0.4.

Market Driven Support for Oracle Database 11.2.0.4

Overview Support Periods Oracle 11g Release 2

First of all, let me give a quick overview on Oracle Database 11g Release 2 – usually …

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 Open World 2019 – Recap and Thank You!

Posted on October 1, 2019 by Mike.Dietrich OOW 0

OOW 2019 has ended over one week ago – and I just wrote the date for OOW 2020 into my calendar: Oct 4, /2020 – Oct 8, 2020 – at least according to the events calendar of Moscone Center. But lets not talk about OOW20 but instead about my summary for Oracle Open World 2019 – Recap and Thank You!

Oracle Open World 2019 - Recap and Thank You!

Oracle Open World 2019 - Recap and Thank You! As usual, this was not a week to relax or hang out in all the nice places in San Francisco. OOW for me means usually a lot of stress. There are so many things we need to prepare. From …

3 PDBs included with Oracle 19c and desupport of non-CDBs with 20c

Posted on September 17, 2019 by Mike.Dietrich Single-/Multitenant 12

It’s Oracle Open World week in San Francisco. and it is time for announcements of course.

3 PDBs included with Oracle 19c and desupport of non-CDBs with 20c

Photo by Aaron Burden on Unsplash

What has been announced?

Today at OOW 2019, Jenny Tsai-Smith and Dominic Giles announced in their talk that the non-CDB architecture will be desupported from Oracle 20c on. But VERY IMPORTANT, from Oracle 19c on you can have 3 user-created pluggable databases of any type without a Multitenant license. As soon as you have need for 4 or more PDBs within one container database, you will need a Multitenant license.

License Guide

You can find the update regarding …

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

Posted on September 12, 2019 by Mike.Dietrich E-Business Suite 0

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

OOW 2019 – Database Upgrade Talks and Labs

Posted on September 11, 2019 by Mike.Dietrich OOW 0

Oh … time flies so fast. Just a few days until I will sit in a airplane to SFO. And on Monday at 7:00h the registration opens. As we have a lab at 8:30h already, just remembering the loooooong lines around the block last year, I will need to be there very early. It’s just a few days until OOW 2019 – Database Upgrade Talks and Labs information is here.

OOW – Oracle Open World 2019 in San Francisco

OOW 2019 - Database Upgrade Talks and Labs

Photo by Robert McLay on Unsplash

When? September 16-19, 2019

Where? San Francisco, USA

What? Find the session catalog here…

Post Conference Wrap-Up – POUG 2019

Posted on September 9, 2019 by Mike.Dietrich Conference 0

Monday after POUG is hard. As I wrote a year ago, a post-conference blues feeling hit me again. But this time I will get quicker over it as there’s Oracle Open World coming up – and a ton of things to complete before I will head out to San Francisco in a few days. So this will be just a short Post Conference Wrap-Up – POUG 2019.

Post Conference Wrap-Up - POUG 2019

First of all …

Thanks to all the people who worked so hard to organize this event. Luiza to name at first of course, but there are so many others. too. …

The September 2019 AutoUpgrade – and the AutoUpgrade Video

Posted on September 5, 2019 by Mike.Dietrich AutoUpgrade 9

My team mates work really hard. And I’m really proud on all of them. We try to fix upcoming issues or requirements with the new AutoUpgrade tool as quickly as possible and still maintain very high quality standards. And here it is, the September 2019 AutoUpgrade – and the AutoUpgrade video as a bonus in addition. Just in case you haven’t seen it in action and can’t join us at OOW 2019.

The September 2019 AutoUpgrade - and the AutoUpgrade Video

Download the September 2019 AutoUpgrade Tool

You can simply download the tool from MOS Note: 2485457.1 – AutoUpgrade Tool.

Watch the AutoUpgrade Video

I just uploaded …

The newest patching surprises – and how to fix some of them

Posted on September 4, 2019 by Mike.Dietrich Patch Recommendation 14

Well, there is no Product Manager for patching. And I’m glad that I’m not in this position. But thanks to all of you, internally and externally, who share your findings with me. In this blog post I’d like to inform you about the newest patching surprises – and how to fix some of them.

The newest patching surprises - and how to fix some of them

Patch apply without confirmation?

Peter Lehmann informed me about this a few weeks ago. Peter told me that he patched systems with the July 2019 RU for Oracle 12.2.0.1 and recognized that the patch installed with opatch without waiting for confirmation. It looked as somebody has …

Data Migration Assistant for Unicode (DMU) 19.1 is available

Posted on September 3, 2019 by Mike.Dietrich DMU - Characterset Migration 0

Just for those of you who face a character set migration challenge, the Data Migration Assistant for Unicode (DMU) 19.1 is available now for download.

Data Migration Assistant for Unicode (DMU) 19.1 is available

What is the DMU?

Oracle Database Migration Assistant for Unicode (DMU) is a tool for migrating your databases from legacy encodings to Unicode. It simplifies the migration process. You as the DBA should need less experience and knowledge – and it should ease your task. It automates many steps. The migration happens in-place and reduces the effort and downtime required for data conversion, comparing to conventional export and import migration methods. You can also use …

September is CONFERENCE month – back to reality

Posted on September 2, 2019 by Mike.Dietrich Conference OOW 0

There was a bit of silence on the blog – well, I needed a deep breath and plenty of fresh air on the most beautiful German island. And now it’s time to dig in again. And I realized that I won’t have many “office” days this month. September is CONFERENCE month – back to reality.

September is CONFERENCE month - back to reality

POUG – Polish Oracle User Group 2019 in Wrozlaw

When? September 6-7, 2019

Where? Wrozlaw, Poland – Kino Home Horyzonty

Why? Because if you’ve never been there, you won’t understand why everybody wants to be there. Check out the agenda: https://poug.org/en/edycja/poug-2019/ – in two days …

Exadata Upgrade to OL7 and to Oracle 19c

Posted on August 29, 2019 by Mike.Dietrich Exadata / ODA 4

This is just a short blog post to ensure I will find the necessary information when somebody asks me again.. In case you plan to do an Exadata upgrade to OL7 and to Oracle 19c, the below links are the most important ones you should start with.

Exadata Upgrade to OL7 and to Oracle 19c

–Mike…

Gracias, obgrigado … Montevideo, Buenos Aires, Brasilia and Sao Paolo

Posted on August 16, 2019 by Mike.Dietrich Conference 0

This was a long trip – but as usual, traveling to South America is wonderful. So it time to say gracias, obgrigado … Montevideo, Buenos Aires, Brasilia and Sao Paolo. I’m so happy that I’ve been invited to speak at the OTN Groundbreakers LAD South Leg Tour 2019. Believe me, it is really hard to fly back after such intense 10 days.

Gracias, obrigado!

Gracias, obgrigado ... Montevideo, Buenos Aires, Brasilia and Sao Paolo

At first, a big big thank you to all the people who organize these events. For us it is quite easy. I board an airplane, and 17 hours later I step into a room on the …

Database Migration from non-CDB to PDB – Migration with Data Pump

Posted on August 14, 2019 by Mike.Dietrich Data Pump Single-/Multitenant 2

You may have realized that there are a few techniques missing describing how to do a Database Migration from non-CDB to PDB – Migration with Data Pump is one of them. I will explain the most simple approach of going to Single- or Multitenant. It isn’t the coolest – and it isn’t very fast as soon as your database has a significant size. But it is not complex. And it allows you to move even from very old versions directly into an Oracle 19c PDB – regardless of patch levels or source and destination platform.

Database Migration from non-CDB to PDB – Migration with Data Pump

High Level Overview

Endianness change

Database Migration from non-CDB to PDB – The Minimal Downtime Challenge

Posted on August 13, 2019 by Mike.Dietrich Minimal Downtime Single-/Multitenant 0

There are several pitfalls when you plugin a non-CDB into a CDB environment. I’d like to highlight some of them – and show you potential workarounds as well. This is part of a series of blog posts to make your migration from non-CDB to PDB a bit smoother.

Database Migration from non-CDB to PDB – The Minimal Downtime Challenge

When we start to look at a migration from non-CDB to PDB for an important system, regardless of migrating on-prem or to the cloud, reducing the downtime is very important. In this blog post I’d like to highlight the different aspects …

Database Migration from non-CDB to PDB – The Fallback Challenge

Posted on August 5, 2019 by Mike.Dietrich Fallback Single-/Multitenant 2

Photo by Sebastian Grochowicz on Unsplash

Database Migration from non-CDB to PDB – The Fallback Challenge

As I work with customers on upgrades and migrations for a very long time, I know how important a proper fallback is.

When you attempt a migration from a non-CDB to PDB, you need to plan …

Database Migration from non-CDB to PDB – Various Pitfalls

Posted on August 2, 2019 by Mike.Dietrich Flaws and Pitfalls Single-/Multitenant 16

Photo by timJ on Unsplash

Database Migration from non-CDB to PDB – Various Pitfalls

In all the previous blog posts of this series I tried to explain specific pitfalls, and how you can workaround them. This article is meant to collect the “leftovers”, the minor issues and pitfalls which you may not …

Database Migration from non-CDB to PDB – The Patch Level Pitfall

Posted on August 1, 2019 by Mike.Dietrich Flaws and Pitfalls Single-/Multitenant 0

Photo by Piron Guillaume on Unsplash

Database Migration from non-CDB to PDB – The Patch Level Pitfall

When you consolidate on a larger scale, it is very likely that you have different patch levels in your database environments. But when you attempt to plugin a non-CDB into a CDB, you may see …

Database Migration from non-CDB to PDB – The Component Pitfall

Posted on July 31, 2019 by Mike.Dietrich Flaws and Pitfalls Single-/Multitenant 4

Photo by Brett Jordan on Unsplash

The Component Pitfall

With component we mean the database component which you can find in DBA_REGISTRY – or CDB_REGISTRY. When Multitenant became available over 5 years ago, a decision had been made to make all options/components mandatory in a container database. This decision had to …

DOAG – When, where, why?

DBMS_PDB.DESCRIBE – why and when?

Why is there a new version?

Deprecation of Oracle Fail Safe

Critical Patch Alert October 2019

Overview Support Periods Oracle 11g Release 2

Slight Change

What has been announced?

License Guide

Plan your upgrade(s)

OOW – Oracle Open World 2019 in San Francisco

First of all …

Download the September 2019 AutoUpgrade Tool

Watch the AutoUpgrade Video

Patch apply without confirmation?

What is the DMU?

POUG – Polish Oracle User Group 2019 in Wrozlaw

Gracias, obrigado!

High Level Overview

Database Migration from non-CDB to PDB – The Minimal Downtime Challenge

Database Migration from non-CDB to PDB – The Fallback Challenge

Database Migration from non-CDB to PDB – Various Pitfalls

Database Migration from non-CDB to PDB – The Patch Level Pitfall

The Component Pitfall

Archives

Categories

Upcoming Events

Upgrade @YouTube

Blog Stats

Subscribe via Email

Follow me on Twitter

Recent Posts