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 … [ Read more ]

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

… [ Read more ]

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 … [ Read more ]

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 … [ Read more ]

Database Migration from non-CDB to PDB – Various Pitfalls

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

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 … [ Read more ]

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 … [ Read more ]

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

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

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 … [ Read more ]

Database Migration from non-CDB to PDB – The Time Zone Pitfall

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

Photo by Allef Vinicius on Unsplash

Database Migration from non-CDB to PDB – The Time Zone Pitfall

Interestingly, there is no issue with different time zone settings within a single CDB. Your CDB$ROOT can be on DST V.32 whereas a PDB you plugin can be already on DST V.33. But only … [ Read more ]

Database Migration from non-CDB to PDB – The COMPATIBLE pitfall

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

Database Migration from non-CDB to PDB - The COMPATIBLE pitfall

Database Migration from non-CDB to PDB – The COMPATIBLE pitfall

When you migrate your non-CDB to PDB, in most cases the COMPATIBLE setting of the non-CDB will be lower than the setting of the receiving CDB. But still in this case you may see warnings. I will explain how to deal with … [ Read more ]

Database Migration from non-CDB to PDB – Typical Plugin Issues and Workarounds

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

In the previous blog posts I showed different approaches on how to migrate your database on a same Endianness platform into Multitenant. Whether you prefer to upgrade first or plugin first is up to you. I recommend upgrading first as this allows you a seamless fallback. But regardless of which approach you prefer, you may take care on potential pitfalls. Hence, this blog post is about Database Migration from non-CDB to PDB – Typical Plugin Issues and Workarounds. It may not be complete when I publish it and I may extend it later on. Let me know if you have … [ Read more ]

Database Migration from non-CDB to PDB – Clone via NON$CDB, upgrade, convert

Posted on July 25, 2019 by Mike.Dietrich Single-/Multitenant 0

The third option for plugging in a non-CDB is called Database Migration from non-CDB to PDB – Clone via NON$CDB, upgrade, convert. As I showed already in this blog post a while ago, your source must be at least an Oracle 12.1 database. And this technique can be used also only for same-Endianness migrations but does not apply if you’d like to migrate from Big to Little Endian. If your source database matches already the receiving CDB, no upgrade is necessary.

Photo by Samuel Chan on Unsplash

High Level Overview

Endianness change possible:	No
Source database versions:	Oracle 12.1.0.2

… [ Read more ]

Database Migration from non-CDB to PDB – Plug in, upgrade, convert

Posted on July 24, 2019 by Mike.Dietrich Single-/Multitenant 0

This is my next blog post about Database Migration from non-CDB to PDB – Plug in, upgrade, convert. But what is different from the previous one? And why is it necessary? Since Oracle Database 12.2.0.1 you can plugin a non-CDB at first, the upgrade and convert it. And I’ll show you this technique here.

Photo by Dan Freeman on Unsplash

High Level Overview

Endianness change possible:	No
Source database versions:	Oracle 12.2.0.1 or newer (or 12.1.0.2 when CDB has shared UNDO)
Characteristic:	Plugin into CDB first
Upgrade necessary:	Yes, after plugin
Downtime:	Plugin, copy (optional), upgrade and `noncdb_to_pdb.sql`
Minimal

… [ Read more ]

Database Migration from non-CDB to PDB – Upgrade, plug in, convert

Posted on July 23, 2019 by Mike.Dietrich Single-/Multitenant 4

As first blog post of this series about Database Migration from non-CDB to PDB – Upgrade, plug in, convert I will explain the most straight forward approach of going to Single- or Multitenant. But you have other options as well. which I’ll showcase in the other blog posts. I demonstrated this technique on the blog already a while ago. But since Oracle 12.2.0.1, there are a few other options available.

Database Migration from non-CDB to PDB - Upgrade, plug in, convert

High Level Overview

Endianness change possible:	No
Source database versions:	Oracle 11.2.0.4 or newer
Characteristic:	Upgrade non-CDB first
Upgrade necessary:	Yes, before plugin
Downtime:	Upgrade, plugin, copy (optional) and

… [ Read more ]

Database Migration from non-CDB to PDB – Overview

Posted on July 22, 2019 by Mike.Dietrich Single-/Multitenant 1

Today I’ll start a blog post series of several “how to” articles about database migration from non-CDB to PDB – Overiew. You’ll find a quick introduction below. And of course, the links to all the other related blog posts.

Database Migration from non-CDB to PDB – Overview

When you plan to move from non-CDB, the Oracle term for regular database deployments, to a Pluggable Database (PDB), you will migrate your database. It will become a PDB and run as part of a Container Database (CDB). This is a well known concept for several years now called Oracle Multitenant. If you … [ Read more ]

AutoUpgrade and Data Guard, RAC, Restart and non-CDB to PDB

Posted on July 19, 2019 by Mike.Dietrich AutoUpgrade 2

I need to bring this blog post forward about AutoUpgrade and Data Guard, RAC, Restart and non-CDB to PDB. Initially I planned to write this a bit later. But some of you had questions or were wondering why AutoUpgrade hasn’t done certain tasks. Hence, I’d like to clarify what AutoUpgrade can do, what it can’t and what you’ll have to do at the moment.

I refer to the AutoUpgrade tool as of July 2019. In later versions, one or the other restriction may be lifted. I will blog about it then as well.

AutoUpgrade and Data Guard, RAC, Restart and non-CDB to PDB

AutoUpgrade – Step-by-step

The new AutoUpgrade

… [ Read more ]

Please download the new July 2019 (20190715) AutoUpgrade

Posted on July 17, 2019 by Mike.Dietrich AutoUpgrade 7

Since last night, the new version of the AutoUpgrade utility is available. Please download the new July 2019 (20190715) AutoUpgrade and exchange your previous version in your destination $ORACLE_HOME/rdbms/admin with this one.

Download

Please download the tool from: MOS Note: 2485457.1 – AutoUpgrade Tool

When you copied the new tool, call it for a version check to make sure you are using the most recent one:

$ java -jar $OH19/rdbms/admin/autoupgrade.jar -version
build.version 20190715
build.date 2019/07/15 12:45:48

Please notice that the tool allows you to upgrade to Oracle 12.2.0.1 and Oracle 18c as well:

Please download the new July 2019 (20190715) AutoUpgrade

The listed releases are the minimum … [ Read more ]

Oracle Security Alerts for July 2019 got published

Posted on July 16, 2019 by Mike.Dietrich Patch Recommendation 10

It’s patching day. And I’m already downloading the patch bundles for all my installations (11.2.0.4, 12.1.0.2, 12.2.0.1, 18c and 19c). The Oracle Security Alerts for July 2019 got published today.

Oracle Security Alerts for July 2019 got published

Patch Advisory and Risk Matrix

You can find the July 2019 Patch Advisory here. I checked the risk matrix for the database. It contains 8 new fixes for the database server. Please pay attention that 3 of the vulnerabilities may be exploitable from a client without an Oracle Database server being installed. The highest score is 9.8.

Please check the risk matrix by yourself:

… [ Read more ]

AutoUpgrade: Where do you find all the logfiles?

Posted on July 16, 2019 by Mike.Dietrich AutoUpgrade 0

AutoUpgrade: Where do you find all the logfiles? In the previous blog posts you could read about how to create the configuration file, adjust it and tweak the init parameters for the AutoUpgrade tool. And then I described the different modes of it. In this blog post I’d like to give you some insights into AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade – Step-by-step

… [ Read more ]

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

Posted on July 15, 2019 by Mike.Dietrich Behavior Change 4

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

… [ Read more ]

AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes

Posted on July 12, 2019 by Mike.Dietrich AutoUpgrade 0

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

… [ Read more ]

Yatra 2019 – Oracle Groundbreakers: Roy Swonger travels to India

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

In April in Vienna a colleague from the US asked me: “Is Roy serious to travel to India in July?”. He mentioned the temperatures, the humidity – and the rain. But Roy is serious – and while I’m writing this, he should be already on his way to India to present about Upgrade and Migrations in 5 locations at Yatra 2019 – Oracle Groundbreakers: Roy Swonger travels to India.

Yatra 2019 - Oracle Groundbreakers: Roy Swonger travels to India

Why you need to attend?

The organizers have listed 6 fine reasons for attending Yatra on the official Yatra 2019 conference page. And I’m adding another one: You want to … [ Read more ]

The new Oracle 19c Hands-On Lab is available

Posted on July 10, 2019 by Mike.Dietrich Hands-On Lab 4

Well, it’s been a while since we refreshed the lab being downloadable via this blog. But finally, the new Oracle 19c Hands-On Lab is available – you can download it as of now.

What’s new in the lab?

First of all, the biggest change you’ll see is that the operating system is now Oracle Linux 7. Well, to be honest, I’m not a die-hard Linux expert and you may find my setup a bit creepy. Feel free to exchange things or adjust them – or drop me a message if you think that adjustments should be made. And of … [ Read more ]

Config file for AutoUpgrade – Tweaking init parameters

Posted on July 9, 2019 by Mike.Dietrich AutoUpgrade 0

In the previous blog posts I explained how to generate a sample config file for the AutoUpgrade tool and how to adjust it. Then I gave you an overview about the most important Advanced Options you may want or need to deal with when using the utility. And in the below blog post I would like to show you have you need to edit the Config file for AutoUpgrade – Tweaking init parameters is an important topic.

This is the forth post of a series of blog posts regarding the new AutoUpgrade tool. Please find all the other available … [ Read more ]

Config file for AutoUpgrade 19c – Advanced options

Posted on June 28, 2019 by Mike.Dietrich AutoUpgrade 8

In the previous blog post I explained how to create a config file for the AutoUpgrde utility. And now I’d like to show how you can use some important advanced options to have the AutoUpgrade utility do or skip specific tasks. Read about how you can tweak the config file for AutoUpgrade 19c – Advanced options.

I will describe only the most important advanced parameters which I think can be very useful in your environments. Of course, there are many more as you can see in the Database Upgrade Guide.

AutoUpgrade – Step-by-step

The new AutoUpgrade Utility – Download,

… [ Read more ]

Update (RU) 19.3.0 withdrawn and superseded with 19.3.1

Posted on June 26, 2019 by Mike.Dietrich Patch Recommendation 8

Actually I really refused to blog about this for a few weeks now. But as I receive more questions and read more tweets, I think I need to shed some light and help avoiding confusion. And as readmes and MOS notes are not entirely in sync, you may get confused if you don’t read the “correct” document.

Update (RU) 19.3.0 withdrawn and superseded with 19.3.1

Photo by camilo jimenez on Unsplash

Oracle 19.3.0 Update (RU)

In April, Oracle released the 19.3.0 Release Update (RU) on Linux and Solaris only. As you can read in my blog post from April 25, 2019, this is a patch bundle meant for … [ Read more ]

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

Database Migration from non-CDB to PDB – The Time Zone Pitfall

Database Migration from non-CDB to PDB – The COMPATIBLE pitfall

High Level Overview

High Level Overview

High Level Overview

Database Migration from non-CDB to PDB – Overview

AutoUpgrade – Step-by-step

Download

Patch Advisory and Risk Matrix

AutoUpgrade – Step-by-step

UTL_FILE_DIR Desupport

AutoUpgrade – Step-by-step

Why you need to attend?

What’s new in the lab?

AutoUpgrade – Step-by-step

Oracle 19.3.0 Update (RU)

Archives

Categories

Upcoming Events

Upgrade @YouTube

Blog Stats

Subscribe via Email

Follow me on Twitter

Recent Posts