Great License News: Spatial and Graph, Machine Learning

Posted on December 6, 2019 by Mike.Dietrich General 0

Just this week in Brighton at TechFest19 by UKOUG I’ve heard one of the common complaints about our license strategy. Something I can’t comment in my position. But even better that we are announcing some very good news now. Oracle is listening. It is a reaction to customer’s wishes.

Photo by pxoxo on Unsplash

Spatial and Graph

Effective December 5, 2019, Oracle Spatial and Graph (OSG) option will be included with Oracle Database. This will affect Enterprise Edition, SE2 and Database Cloud Service (DBCS) Standard Edition 2 and Enterprise Edition. This means, you can use Spatial and Graph in all …

Save Patching Downtime with Oracle Multitenant?

Posted on December 2, 2019 by Mike.Dietrich Best Practice Patch Recommendation Single-/Multitenant 2

At OOW 2019 we announced that you can have up to 3 user-created pluggable databases (PDBs) per container database (CDB) without having a Multitenant license. And in this blog post I’d like to demonstrate how you can save patching downtime with Oracle Multitenant.

The Concept

The idea this entire process settles on is very simple. When you create a fresh container database in the target (already patched!) environment, you don’t have to patch this one. You only have to relocate the PDB from the source into the target CDB. In addition, only datapatch needs to be executed. As the …

Video: Best Practices to Upgrade to Oracle Database 19c

Posted on November 29, 2019 by Mike.Dietrich Video / Viewlet 0

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:

Video: Best Practices to Upgrade to Oracle Database 19c

https://vimeo.com/questoraclecommunity/review/374661161/ce9a8b21ba

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

https://mikedietrichde.com/slides/#OOW19

Thanks!

–Mike…

AutoUpgrade Tips: Running two (or more) sessions in parallel

Posted on November 28, 2019 by Mike.Dietrich AutoUpgrade 0

Our intention with the AutoUpgrade as the single tool to upgrade your databases was initially: You have one big config file for your databases. And you will use this file to upgrade your databases unattended. Ideally you run an “analyze” at first, then you schedule a “deploy” for overnight or the next weekend or whenever it is convenient for you. But sometimes people have different needs. In this particular case several people asked whether you can run multiple AutoUpgrade tools in parallel on the same server. Hence, I’d like to explain the first of more AutoUpgrade …

UKOUG TechFest 2019 in Brighton – Dec 1-4, 2019

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

Time really flies. As every year in November. Right after DOAG, there’s very little time for me to recharge batteries. And once I take a deep breath, I will sit in another airplane and fly to … England. No worries, I won’t do any political jokes. This is not necessary these days. And this is a techie blog. But I’m very happy that I don’t have to do any special preparation to visit UKOUG TechFest 2019 in Brighton – Dec 1-4, 2019.

Photo by Nitin Tulswani on Unsplash

Brighton?

To be honest, I know not much about Brighton. Except …

AutoUpgrade may fail when patch ID column is NULL

Posted on November 25, 2019 by Mike.Dietrich AutoUpgrade 12

Monday morning – it’s time to write a new blog post. And actually I will set priorities based on what you reported to me in the past week. This way it may prevent others from hitting the same pitfall. The AutoUpgrade may fail when patch ID column is NULL in REGISTRY$HISTORY.

AutoUpgrade may fail when patch ID column is NULL

Photo by Etienne Boulanger on Unsplash

What is happening?

You start a database upgrade with autoupgrade. But the initial check will fail with a message like this:

AutoUpgrade tool launched with default options
There was an error initializing the patching information for entry upg2

The AutoUpgrade won’t kick …

DOAG 2019 – Recap and a personal complaint

Posted on November 22, 2019 by Mike.Dietrich Conference 12

Nürnberg and München are just 175 km away from each other, a bit more than 1 hour by train. Still I felt a post-conference blues already when I boarded the ICE train yesterday to head back to the south. It was an awesome conference – again. Except for one thing which I will write about below. So here’s my report on DOAG 2019 – Recap and a personal complaint.

DOAG 2019 - Recap and a personal complaint

Photo by Philippe Mignot on Unsplash

DOAG 2019 – What an agenda

I knew it before already. But my VP, Roy Swonger, visited DOAG Conference in Nürnberg for the first time. …

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 20

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 21

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 20

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 19

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…

Spatial and Graph

The Concept

Brighton?

What is happening?

DOAG 2019 – What an agenda

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

Archives

Categories

Upcoming Events

Upgrade @YouTube

Blog Stats

Subscribe via Email

Follow me on Twitter

Recent Posts