Different handling of UNLIMITED QUOTA when you revoke the DBA role between 11.2.0.4 and future releases

Different handling of UNLIMITED QUOTA when you revoke the DBA role between 11.2.0.4 and future releases 4

Looking forward to YATRA 2024 Tour in India

Looking forward to YATRA 2024 Tour in India 0

Reuse Object IDs in Oracle Database 19c and 23ai

Reuse Object IDs in Oracle Database 19c and 23ai 10

Virtual Classroom Seminar 20: Migration to Oracle Multitenant 23ai – Part 2

Virtual Classroom Seminar 20: Migration to Oracle Multitenant 23ai - Part 2 0

Why isn’t the newest JDK in this Oracle Release Update?

Why isn't the newest JDK in this RU? 3

Virtual Classroom Seminar #19 “Move to Oracle 23ai” is available – and #20 is coming soon

0

Oracle Database 23ai is available in the cloud and as Free

15

Upcoming In-Person Workshops in May 2024 in Copenhagen, Stockholm and Frankfurt

Upcoming In-Person Workshops in May 2024 in Copenhagen, Stockholm and Frankfurt 2

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 48

Different handling of UNLIMITED QUOTA when you revoke the DBA role between 11.2.0.4 and future releases

“Oh heck” you may think. “Why is he blogging about 11.2.0.4?”. But as a matter of fact, I work right now with a customer in Germany where we try to lift a fairly large database into Autonomous Database Serverless (ADB-S). And as I love to learn new things every day but (as most of us) have just limited brain capacity, I prefer to put things on the blog. Only challenge as Klaus from our team demonstrated to me yesterday: I need to remember that I wrote something about it. Anyhow, since we still have a number of customers on Oracle …

Continue reading...

Looking forward to YATRA 2024 Tour in India

Time flies so quickly – and it is already July again. Next week I will fly out to India. And I am looking forward to YATRA 2024 Tour in India. It is always a vibrant experience with tons of energy in every room, with fully motivated people, awesome food and often some travel challenges, too.

What you need to do if you haven’t already? REGISTER NOW!!

Why should you register? Watch this video 🙂

Continue reading...

Reuse Object IDs in Oracle Database 19c and 23ai

I love to learn something new every day. And thanks to my Dutch friend, Robert Pastijn, I learned about a limitation of how many objects you can create in an Oracle database. Nothing to worry about, the limit is very high at a little bit over 4.2 billion. But in order to prevent hitting it, we introduced a mechanism to Reuse Object IDs in Oracle Database 19c and 23ai.

Reuse Object IDs in Oracle Database 19c and 23ai

Photo by Rosie Sun on Unsplash

What is the mechanism?

First of all, this is ON and enabled in Oracle Database 23ai by default. But in case you need this …

Continue reading...

Virtual Classroom Seminar 20: Migration to Oracle Multitenant 23ai – Part 2

Needed a long title here. And if you haven’t registered yet, please do so now. Thursday, June 27, 2024, we are going to deliver our (potentially last for this year) Virtual Classroom Seminar 20: Migration to Oracle Multitenant 23ai – Part 2. If you missed part 1, no worries, you can watch it on-demand anytime.

Again, we have an exciting deep-dive tech agenda with lots of bits and pieces, and thinks you may not know yet. Hence, regardless if you are already in the Multitenant architecture, or whether you plan to migrate …

Continue reading...

Why isn’t the newest JDK in this Oracle Release Update?

Quick blog post only since I received this question 3x this week in various ways from customers. Why isn’t the newest JDK in this Oracle Release Update? Let me try to answer and explain it.

Why isn't the newest JDK in this RU?

Photo by Jan Kronies on Unsplash

JDK in the Oracle Home

Actually, when you look at your Oracle Home, you will find a subdirectory:

/u01/app/oracle/product/19/jdk
$ tree -L 1
.
├── bin
├── COPYRIGHT
├── include
├── javafx-src.zip
├── jmc.txt
├── jre
├── jvisualvm.txt
├── legal
├── lib
├── LICENSE
├── README.html
├── release
├── THIRDPARTYLICENSEREADME-JAVAFX.txt
└── THIRDPARTYLICENSEREADME.txt

And in the bin directory, there is …

Continue reading...

Virtual Classroom Seminar #19 “Move to Oracle 23ai” is available – and #20 is coming soon

Thanks to the over 350 people who attended our Virtual Classroom Seminar #19 – Move to Oracle Database 23ai: Everything you need to know about Multitenant PART 1 on May 16, 2024. And thanks as well for asking so many questions during the seminar. In case you couldn’t attend, or you’ve had to leave earlier, we are sharing the recording with you, and of course the slides as well.

Virtual Classroom Seminar #19 - Move to Oracle Database 23ai - Multitenant Part 1

What were the topics in VC#19?

In VC#19 we talked about the Oracle Multitenant architecture, how to design a new deployment, how the dictionary is laid out. In addition, you will …

Continue reading...

Oracle Database 23ai is available in the cloud and as Free

You may have watched the announcement of Larry Ellison together with our EVP Juan Loiza this evening. And yes, Oracle Database 23ai is available in the cloud and as Free Developer Edition as of now.

Oracle Database 23ai announcement by Larry Ellison and Juan Loiza

Click on the picture to watch the announcement

What are we announcing?

Please see the important links for more information about the recent announcements Larry Ellison and Juan Loiza made today.

Continue reading...

Upcoming In-Person Workshops in May 2024 in Copenhagen, Stockholm and Frankfurt

Daniel and I are looking forward to welcome you at one of our upcoming workshops in Copenhagen, Stockholm or Frankfurt. But please register ONLY if you can make it in-person. This is not a virtual event, we don’t stream it. You need to come to one of the locations by yourself.

Upcoming In-Person Workshops in May 2024 in Copenhagen, Stockholm and Frankfurt

Screenshot

Real World Database Upgrade and Migration to Oracle Database 19c and 23c

We will cover almost everything from the Release Strategy to Patching Best Practices, the quickest path into Oracle Multitenant, AutoUpgrade options, Performance Stability and of course Oracle Database 23c New Features.

Join us for a full …

Continue reading...

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