A new version 24.1.0 of CPAT is available

A new version 24.1.0 of CPAT is available 0

New AutoUpgrade Tool is available in March 2024

New AutoUpgrade Tool is available in March 2024 8

Oracle Cloud World 2024 in London

OCW 2024 London 0

Virtual Classroom Seminar 18: XTTS to the Extreme – Video and Slides and more

0

IMPORTANT: Location change for the Warsaw workshop

IMPORTANT: Location change for the Warsaw workshop 0

Virtual Classroom Seminar 18: Cross Platform Migration to the Extreme

0

How to relink Oracle for Enterprise or Standard Edition?

How to relink Oracle for Enterprise or Standard Edition? 5

Your chance – in-person Oracle 23c upgrade workshops in Warsaw and Munich

Your chance - in-person Oracle 23c upgrade workshops in Warsaw and Munich 9

ORA-39405 with impdp when you have mixed time zone versions

ORA-39405 with impdp when you have mixed time zone versions 9

datapatch stores rollback patching files in the database

datapatch stores rollback patching files in the database 13

A new version 24.1.0 of CPAT is available

No worries, this blog won’t become a “new version” announcement blog. But after two weeks of relaxing Easter holidays I just start cleaning up my inbox and flushing out blog posts as soon as time allows. One thing I need to share with you is that a new version 24.1.0 of CPAT is available for download. CPAT? You may not have read about CPAT on my blog yet. But this will change in the future since the CPAT development is now part of our small team as well. And we get happily tied into more and more Autonomous Database (ADB) …

Continue reading...

New AutoUpgrade Tool is available in March 2024

It has been a longer while – but the Upgrade Dev team worked very hard. And finally, the new AutoUpgrade Tool is available in March 2024. And it brings a ton of new enhancements and features. Some of them, for instance the windows services support, were awaited by you for a long time. Still, there’s much more to talk about.

 

Download the newest version of AutoUpgrade

As usual, you can download it from MOS Note:2485457.1 – Download AutoUpgrade. And when you check the version, you already find some of the new …

Continue reading...

Oracle Cloud World 2024 in London

Next week it’s Oracle Cloud World 2024 in London. And I hope to see you there. It is a perfect spot to get the latest tech updates but also to meet and synch and discuss.

OCW 2024 London

Not registered yet?

In addition, there is a DevLive event the day before with about 40 separate sessions.

 

Upgrade to Oracle Database 23c talk?

Would love to see you there. But certainly there are so many other great sessions. Check out the session catalog, and choose the ones you are the …

Continue reading...

Virtual Classroom Seminar 18: XTTS to the Extreme – Video and Slides and more

Thanks for tuning in on Feb 22, 2024 into our Virtual Classroom Seminar 18: XTTS to the Extreme – Video and Slides and more are now available. And thanks for being such a great audience with so many questions.

Virtual Classroom Seminar 18: XTTS to the Extreme - Video and Slides and more

Photo by Venti Views on Unsplash

Video Recording

As usual, you can access the full recording here.

Please find the entire contents section below in the video’s description. You don’t need to watch the entire seminar, you can also access only the sections you are interested in, or skip sections which are not on your focus.

Continue reading...

IMPORTANT: Location change for the Warsaw workshop

Those of you who have received an email to attend the Upgrade / Migration / Performance / 19c / 23c workshop on Feb 27, 2024 in Warsaw, Poland, please note that we have changed the location to accommodate more people.

Originally, the workshop was going to happen at the Oracle Office in Warsaw. But we moved it to:

HUB Convention Center
Crowne Plaza® Warsaw – The HUB
Holiday Inn Express® Warsaw – The HUB
Rondo Daszyńskiego 2
00-843 Warsaw

Please make sure to arrive at 9:00h, we will start straight at 9:30h and …

Continue reading...

Virtual Classroom Seminar 18: Cross Platform Migration to the Extreme

This week on Thursday, February 22, 2024 at 16:00h CET we’d like to invite you to our next Virtual Classroom Seminar 18: Cross Platform Migration to the Extreme. Take the chance to learn about the newest developments in cross-platform transportable tablespace migrations – and there is a lot to talk about.

Virtual Classroom Seminar 18: Cross Platform Migration to the Extreme

Photo by Venti Views on Unsplash

What will be the topics?

We’ll not only discuss but also demonstrate the newest developments and improvements in cross-platform migrations, especially for large and active databases. Learn about the new M5 migration scripts, see them in action – and get an idea …

Continue reading...

How to relink Oracle for Enterprise or Standard Edition?

What a weird blog post. But let me explain briefly the motivation for my Friday article. As you know, the blog serves also as my brain dump. And whenever I try something out I know I may need later again, I dump it here. Certainly, some LLM will pick up the information and spill it out later when you ask the interface about How to relink Oracle for Enterprise or Standard Edition?

From Enterprise to Standard Edition?

Of course, you can. But I had no idea how to when Philippe Fierens, the PM …

Continue reading...

Your chance – in-person Oracle 23c upgrade workshops in Warsaw and Munich

We have a rare offer for you. Not Santa but Daniel and I are coming to town. So, this is your chance – in-person Oracle 23c upgrade workshops in Warsaw and Munich. You are signing up for a packed day of tech. No marketing slides – just facts and features, not only Oracle Database 23c, the new upcoming long-term support release. But certainly we’ll have enough for all those you are just in the process of moving to Oracle Database 19c.

When?

We are absolutely excited to offer you a full-day in-person all-tech …

Continue reading...

ORA-39405 with impdp when you have mixed time zone versions

Today, Gisela, a former team mate from CSS/ACS Support contacted me regarding an issue seen at a customer. She reported an ORA-39405 with impdp when you have mixed time zone versions. But how can this happen? And what are the potential workarounds? Since some of our hosted environments got into the same situation already, this may be worth a blog post and some explanation.

Why does this happen?

You never cared about DST (Daylight Savings Time) files and versions of your database? This isn’t unusual, and in many environments actually not a problem …

Continue reading...

datapatch stores rollback patching files in the database

I held back this blog post for a longer while. A customer (Thanks Jannes!) reported this to me many months ago but the fix was not as trivial as we thought initially, and there were several unlucky circumstances delaying it multiple times. But now it is time to tell you how datapatch stores rollback patching files in the database. And of course, how to cleanup.

Why is this important?

At first, you may ask yourself: Why should I care? And you are right. This is normally nothing you should care about. …

Continue reading...

Migrate your EM Cloud Control Repository into a PDB

This is a question two customers asked me one or two weeks ago. Is it allowed and supported to Migrate your EM Cloud Control Repository into a PDB? And if it is supported, how do you do it?

Is is supported?

At first, the good news, Migration your Enterprise Manager Cloud Control Repository database into a pluggable database (PDB) is fully supported. You find a section in the Cloud Control Basic Installation Guide saying:

The supported database configuration types are: pluggable database (PDB) and non-container database (non-CDB).

And you can have even …

Continue reading...

Voodoo with init parameters and Oracle Restart

Uwe Kirchhoff, one of the best techies I know in the entire Oracle CSS (formerly ACS) Support, mailed me before the Christmas holidays with a simple question. He discovered that altering init.ora parameters in a session does not necessarily write the parameter down into the spfile. Sounds a bit like Voodoo with init parameters,  and Oracle Restart has a role in this story as well. If you don’t have or do not plan to use Oracle Restart, then this is not interesting for you. But of course, you are free to still read it 🙂

Voodoo with init parameters and Oracle Restart

Photo by Marko Manojlovic on

Continue reading...

The downsides of in-place patching – and a patching lab

Happy New Year to all of you at first. I hope you all had a good start – and for myself, I promise to blog a bit more again in 2024. Let me start with my first post since I received a question very often: Why should I patch out-of-place with a new Oracle Home? Since I need to patch a bit today I can easily show the downsides of in-place patching – and a patching lab.

It all started at OCW 2023

Ok, we didn’t really start it at OCW 2023 in

Continue reading...

Welcome aboard at Oracle, Alex Zaballa

Our PM team is slowly growing – and I am so happy about our newest team member. Welcome aboard at Oracle, Alex Zaballa!

Now I think I need to start learning a bit more Portuguese. Rodrigo is located in Brazil, and Alex relocated a while ago to the US but is Brazilian as well. I am really excited to have another super-smart guy in our team helping us with upgrades, (cloud) migrations, patching, Cloud Migration Advisor and CPAT, and other cool things. Personally, I enjoy working with people who have such a deep knowledge …

Continue reading...

Premier Support for Oracle Database 21c extended

You are reading correctly: Premier Support for Oracle Database 21c extended is the headline.

Premier Support for Oracle Database 21c extended

Photo by Tim Stief on Unsplash

Isn’t it an innovation release?

Yes, you are right. Oracle Database 21c is an innovation release only. And we boldly tell you for a longer while: Move your production estate and everything tied to it from Long Term to Long Term Support Release. This means: Bring everything to Oracle Database 19c, and then later move on to Oracle Database 23c.

An Innovation Release such as Oracle Database 21c should be fine for developments using new features but ideally not used …

Continue reading...

Can you use the UEK7 Linux kernel, or may you get some trouble?

Writing about a topic I have not much knowledge with is … no fun 🙂 But let me share this with you as one of my most trusted customers, Peter Lehmann, tested this and got trapped. The information being available was not crystal clear, and Peter‘s database did not start anymore when HUGEPAGES were enabled. So, the question is: Can you use the UEK7 Linux kernel, or may you get some trouble?

Where it all starts

Peter set up a new cluster with Oracle Linux 8.8 using an UEK7 kernel. And as …

Continue reading...

DOAG 2023 Conference – our talks this year

Time flies so quickly – and I guess I wrote this phrase already plenty of times on the blog. It is already November, and just a few weeks until Christmas. And this year, DOAG conference in Nuernberg is again in November – which means: next week. So, let me give you a quick overview for DOAG 2023 Conference – our talks this year.

When, who, where?

At first, DOAG 2023 will happen from November 21-24, 2023 at the usual superb location in Nuernberg. You find all the details on the DOAG webpage. …

Continue reading...

Monitor progress of Oracle Data Pump impdp

This blog post is a quick brain dump. I realized that I have so many “blog posts to write” that I need to dump the ideas or information much quicker. So, feel free to comment and correct. These queries may be useful when you run a larger import, and you would like to monitor progress of Oracle Data Pump impdp.

Monitor Data Pump progress during impdp

To monitor the progress of Data Pump during impdp you can use the following queries.

What object types are left?

select unique object_type_seqno, object_type
from system.sys_import_full_01
where 
Continue reading...

Oracle Database 19c is certified on OL9 and RHEL9

I know, many of you were asking several times already about the certification of the Oracle Database on Oracle Linux 9 and Red Hat Enterprise Linux 9. And originally I think an announcement was planned for Oracle Cloud World in Las Vegas. But certification mean that you really certify, and not just wave things through. We’ve done thorough testing, and some issues were found which needed to be fixed at first. Good news: Oracle Database 19c is certified on OL9 and RHEL9.

Certification Tab

You can check certifications quickly on MyOracle Support by yourself. …

Continue reading...

Important clarifications to the Oracle Database Error Correction Policy

When I came back from vacation a few weeks ago (or was it almost 2 months ago??) I learned that we have added some Important clarifications to the Oracle Database Error Correction Policy. The clarifications are mainly about how long you will be able to request a single fix for a given Release Update (RU). Take this not as a constraint but a motivation to argue internally to not stay on too old Release Updates.

Important clarifications to the Oracle Database Error Correction Policy

Photo by Saul Macias on Unsplash

 

How to find the important notes?

It is not easy to find this important note in MOS, …

Continue reading...

How many fixes are you missing?

Since we’ve had a public holiday in Germany yesterday, this feels almost like my Monday-morning-rant blog post. But seriously, this question came up so many times the past weeks. And I think it is worth a blog post to answer the question: How many fixes are you missing?

How many fixes are you missing?

Photo by Paul Hutton on Unsplash

Why would you want to know?

To be frank, customers I discussed the patch bundle topic with recently are often not interested in knowing how many fixes they are missing. Discussions quickly emerge into “quality” or “ease” or “cost” for how to apply patches. But rarely …

Continue reading...

September 2023 version of AutoUpgrade is available

It’s time again – and the new September 2023 version of AutoUpgrade is available for download to you.

Where to download it?

As usual, the MOS Note: 2485457.1 offers you access to the new release, and to the previous versions of the tool as well. This new version will show the following version information:

java -jar autoupgrade.jar -version

build.version 23.4.230921
build.date 2023/09/21 14:43:05 -0400
build.hash 165be072
build.hash_date 2023/09/21 13:05:52 -0400
build.supported_target_versions 12.2,18,19,21
build.type production
build.label (HEAD, tag: v23.4, origin/stable_devel, stable_devel)

This version will be also included in the Jan 2024 RU, 19.22.0, but not …

Continue reading...

In-person Upgrade Workshops in Brussels and Utrecht

For a long time we haven’t met in person I guess. But I know very well that the audiences in Brussels, Belgium, and Utrecht, Netherlands, are very active. And it’s actually the best to meet for In-person Upgrade Workshops in Brussels and Utrecht in October – not via zoom 🙂 And this is your change to sign up if you haven’t already.

When will it happen?

Very simple – and you are just one click away:

Both events …

Continue reading...

Your Upgrade / Migration / Patching Guide for OCW23

Thanks for using this blog post. It will be your Upgrade / Migration / Patching Guide for OCW23. You will find the slide decks to download, the coming talks, the HOL as well as the survey links and other important sources. We wil update it every day throughout the conference. If you have questions, please use the “Comment” option below the blog post. And we won’t post content BEFORE the session but instead AFTER the sessions.

Your Upgrade / Migration / Patching Guide for OCW23

All you need, day by day

Please find – grouped day by day – each of our talks with the survey links and …

Continue reading...

Your UPGRADE and MIGRATION program at OCW23

Are you coming to Oracle Cloud World 2023 and to Oracle DatabaseWorld at CloudWorld? Then you should read on since this may be your upgrade and migration program at OCW23. We are desperately looking forward to see and meet you in 2 weeks in Las Vegas. Don’t forget to add the talks you’d like to visit to your schedule as some of the rooms have limited capacity. And at least one of our labs is already sold out.

https://www.oracle.com/database/upgrades/#rc30p2

Who’s speaking and HOL’ing?

Speakers and your lab hosts will be:

  • Roy Swonger
  • Mike Dietrich
  • Daniel Overby Hansen
  • Rodrigo Jorge
Continue reading...