A kill-switch terminates blocking sessions during patching You will find a good number of datapatch posts on my blog. And with Oracle AI Database 26ai from RU 23.26.0.0.0 onward (the October 2025 RU), we introduce a new functionality when you run datapatch: A kill-switch terminates blocking…

Oracle Software Install using AutoUpgrade on a Brand New VM! #OracleDB #DB19c #AIDB26 #AutoUpgrade bijoos.com/oraclenotes/...

The October 2025 Release of AutoUpgrade (25.6) is available It's October - and while the leafs keep falling on the northern hemisphere, the October 2025 Release of AutoUpgrade (25.6) is available. Get it now - and find the list of features and fixes below. How to download it? As usual, that’s very…

Oracle AI World 25: Upgrade to Oracle AI Database 26ai – let’s do it again We'll do it another time. This is your chance in case you missed our session on Tuesday: Marco Polo 806, Level 1 Upgrade to Oracle AI Database 26ai: Best Practices and Customer Experience We collided with the delayed…

Oracle AI Database 26ai replaces Oracle Database 23ai Read more here: mikedietrichde.com/2025/10/14/o...

ORA-43907: Potential behavior change with Oracle RU 19.28.0 As I said multiple times, we have the best and most knowledgeable customers out there. Julian Frey is one of them, and there is a good and legit reason why he is an ACE Director since (I think) two years. Julian alerted me the other day…

Oracle AI World 2025: Your guide to Upgrade, Migration and Patching Sessions Oracle OpenWorld had been renamed to Oracle CloudWorld, and it got rebranded to Oracle AI World this year. And we PMs, Alex, Daniel, Rodrigo and myself look forward to see you there. It's a perfect opportunity to touch…

Full Day Upgrade / Migration / Patching Workshop in Prague on September 17, 2025 Summer season is almost over. And in between Oracle AI World in Las Vegas in October and now, there is one chance to meet us for a Full Day Upgrade / Migration / Patching Workshop in Prague on September 17, 2025.…

AutoUpgrade patching – getting started with Connor McDonald AIOUG OC Yatra 2025 is over, and I somehow recovered as well. As I wrote here, it was (again) an incredible experience with all those wonderful people (you!!) and those crazy speakers (us!) - and I learned a lot again. Still, I had no…

⚠️Don’t miss a one-of-a-kind learning opportunity at Oracle CloudWorld 2025 ⚠️ www.youtube.com/watch?v=Mbi4... @mikedietrichde.com @dohdatabase.com @dbarj.com.br

Were you aware of the two hidden columns in CDB-Views? Learning something new every day is the best part of my job. And as you can see and read on the blog, thanks to YOU, I learn a lot. This one I learned from Johannes Ahrends at my workshop for ora2know in Munich in early July this year. Were…

The August 2025 version of AutoUpgrade (25.4) is available This time the AutoUpgrade team did magic and included so many great new features and useful enhancements into the new version of AutoUpgrade. So, please note: The August 2025 version of AutoUpgrade (25.4) is available for download. You…

AHUBFILE files in ASM in Oracle 23ai – what is it? I really love our customers. Many people are so super-smart. A few weeks ago I delivered a full-day hands-on workshop for ora2know in Munich and some (positively) crazy people fly in very early morning from the other end of Germany to attend.…

Recap AIOUG OCYatra 2025 – a trip through India I just returned the other day from the most strenuous trips I do once a year: The AIOUG Oracle Community Yatra tour. 6 cities in 9 days. It's a wild ride with flights and bus transfers in between, monsoon rain, heat and nasty mosquitos - but it is…

@julianfrey.ch on stage at #OCYatra25 today in Pune, India, doing a great job explaining how to use the Oracle REST API as a DBA in a full (luckily A/Ced) room. @thatjeffsmith.com would be proud on him certainly!! @oracleace.bsky.social @swissouc.ch #oracleDBAsRunTheWorld #19c #23ai #OCI #ADB

Curious about upgrades to Oracle Database 23ai? 🤔 What's the easy approach? 🥳 What's the fast approach? 🤓 Check the recording of "Upgrade to Oracle Database 23ai" from Oracle DatabaseWorld 2025. www.youtube.com/watch?v=sF6B... @mikedietrichde.com

#OCYatra25 kicks off today in #Bangalore at the Oracle Tech Hub with an energized huge crowd of awesome people wanting to learn and evolve!! Thanks to @aioug.bsky.social for organizing this super event - and there are 5 additional cities to come. #Ai #ADB #Oracle #autonomous #23ai #19c

OCW25 – Pre-Event Training: Mastering Oracle 23ai Upgrades Time flies so quickly. Soon we'll get together again in Las Vegas for Oracle Cloud World 2025. This year, it will be in October where hopefully it's a few degrees colder (or less hot) than in early September last year. And as in the past…

AutoUpgrade migration to Oracle 23ai Exascale with Refreshable Clones Those of you who have been to our workshops in the past 3 years know that we promote one feature as the ultimate killer feature for moving to Oracle Database 19c and 23ai: Refreshable Clones. These work not only from PDB to PDB,…

ora2know Hands-On Workshop: Upgrade to Oracle 19c and 23ai Let's kick it off. When the ora2know group started at DOAG conference in Nuernberg in November 2024, we committed ourselves to support them. And this is exactly the reason why I am going to invite you to this unique event in Munich on July…

Yes, the #Oracle AutoUpgrade tool can emcli - see how to set automated Enterprise Manager blackouts during upgrade process: www.martinberger.com/2025/05/stre... @oracleace.bsky.social @mikedietrichde.com @dohdatabase.com

The May 2025 version of AutoUpgrade (25.3) is available Many of you know it and downloaded it already. But just in case you are not aware yet, let me give you a quick summary since the May 2025 version of AutoUpgrade (25.3) is available for download. How to download it? That's very simple. You…

RMAN speaks a bit more to you since 19.25 Not a big deal - but Samo has brought this to my attention. And the RMAN development and PM team was happy to help and shed some light here. But one after another - what actually is the topic here? Well, RMAN speaks a bit more to you since 19.25 - which…

A lot of people are ready to have some fun upgrading Oracle Databases to 23ai at Oracle DatabaseWorld: Multicloud AI Edition - NY

Awesome #Oracle #Database customer crowd today in Utrecht in the Netherlands for our Advanced Real World Upgrade and Migration Workshop to #19c and #23ai with @dohdatabase.com #OracleDBAsRunTheWorld is not just a slogan - it's absolutely true, fact and reality.

DB_LOST_WRITE_PROTECT default change in RU 19.26.0 ORAdiff is an amazing tool I use at least once a day. And if you did the same before applying 19.26.0 or moving from 19.25.0 to 19.27.0, you may have spotted this change as well. There is a DB_LOST_WRITE_PROTECT default change in RU 19.26.0. What…

DBMS_OPTIM_BUNDLE and the standby database? I could have sworn that I had blogged about it. Aleksey had a comment on the blog and I could not find the answer. But I knew that I had discussed this topic with several people in email already. Maybe it has fallen off my long list of future blog posts.…

Utrecht in Spring is beautiful – and we’ll be there on May 6 No worries, I don't start writing a travel blog. Or, maybe one day I will. But not for now. Daniel and I will be on the road again next week for a full day workshop in Utrecht on May 6 and in Brussels on May 7. Brussels is sold out…

New interesting underscores for more than 255 _FIX_CONTROLs I keep saying this - we have the best and most skilled customers. Christian Klose from my Franconian home region contacted me via LinkedIn and asked for some assistance with an SR. I confess, I replied way too late (information overflow).…

Small Pages not allowed for SGA from 19.27 and newer on Exadata Having good friends in Oracle is key. And honestly one of the best things in my role. Philippe Fierens, product manager for Oracle's Fleet Patching and Provisioning mailed me yesterday night sharing that there an interesting change…

April 2025 Patch Bundles and a new OPatch Where are they? I saw some so-called "social" media rants this morning already about the missing April 2025 bundles, and people comparing file sizes of opatch wondering what has been forgotten to be included. So let me write a few words about April 2025…

DST Time Zone Patches missing in 23ai Release Updates We work right now with a number of customers going live or being live on Oracle Database 23ai already. And tomorrow will be the release date for the quarterly Release Update, in this case for Oracle Database 23.8.0. But you should be aware of…

Fasten your seatbelts ... and sign up for our new Virtual Classroom series: go.oracle.com/LP=114938?el...

How do find new features in Oracle Release Updates (RUs)? I know, not everybody is a huge fan of new features in RUs. But how do find new features in Oracle Release Updates (RUs)? Are the listed anywhere? They are, no worries. At least since Oracle Database 19c. New Features in RUs? I can already…

Just tech - come with us on our journey in 4 episodes ... Migration to ADB - from planning to execution, and how DBAs may benefit from it.

ORA-12850 when you run AutoUpgrade? Nicola made a comment the other day informing me that they hit an issue on some of their databases when upgrading. But is there a general issue with ORA-12850 when you run AutoUpgrade? Or is this error just the reflection of another issue? Let's see, I will…

Upgrade 19c and 23ai Workshop in London on April 9, 2025 London calling! Your chance to attend our first full-day Upgrade 19c and 23ai Workshop in London on April 9, 2025 in a decade. Yes, you read correctly. We've run such a workshop the last time in 2014. This was when you used an iPhone 6 at…

Final blog post about datapatch cleanup and purge? Uh ... this was a long journey. In September 2022 Jannes Arends contacted me showing me his growing SYSTEM tablespace with every patch cycle. And not only for the CDB$ROOT only but in every PDB. Over time, I wrote some blog posts I link at the end…

ADB Migration: Why does my SPA report has so many errors? I'm dealing lately with several migration to Oracle Autonomous Database, mostly to ADB Serverless (called "shared" a while ago, in short: ADB-S). With one of the customers we run SQL Performance Analyzer reports with about 1500 statements.…

The 25.1 version of AutoUpgrade is available for download It's time for a new version of AutoUpgrade. The 25.1 version of AutoUpgrade is available for download. And you should refresh your existing versions quickly since we added plenty of new and long awaited features but we of course fixed also…

Refreshable clone with AutoUpgrade but keep your RAC configuration? I had to shorten the headline a bit. It got very bulky saying at first: Use a Refreshable Clone with AutoUpgrade from non-CDB to PDB but keep your RAC configuration alive. Well, you see, that's bulky. But it describes the case I…

Queries on dictionary tables are slow in Oracle Multitenant? I love to learn something new every day. And on Friday afternoon last week I learned something new again. It started (as often) with a very simple question from a colleague working from the Oracle Malaga office in Spain. The customer has…

Remember ORA-39405 with impdp? There is a fix for it Remember my blog post about time zone problems during import from one year ago? When you try to import into an Oracle database and your source database you exported from had a higher time zone (DST) patch level than the target, the impdp failed…

Who’s who in CDB_SERVICES, SERVICE$, and more? I visited a customer recently, and they will use Refreshable Clone PDBs to move from Oracle Database 19c to Oracle Database 23ai. So far, nothing special. But after cloning there was an issue with the services creation with srvctl. We started querying…

Am 14. Feb halte ich eine #DOAG #WebSession mit dem Titel "Oracle AutoUpgrade in a Nutshell", bei der ich die Möglichkeiten von AutoUpgrade vorstelle und darauf eingehe, was man unbedingt beachten muss. @oracleace.bsky.social @mikedietrichde.com @doagev.bsky.social meine.doag.org/event/id.876...

News and updates in opatch 12.2.0.1.45 (Jan 2025) Are you interested in the news and updates in opatch 12.2.0.1.45 (Jan 2025)? This is the opatch version being released on January 21, 2025 together with the January Release Updates (RUs) and other patch bundles. What's new in opatch 12.2.0.1.45…

Patch list in MOS Note: 555.1 is not conflict-free Actually this is not an alerting blog post but just a hint. At DOAG conference in Nürnberg several customers came by after our patching talk on Thursday in Tokio and complained that the Patch list in MOS Note: 555.1 is not conflict-free, and thus…

Large migration project? MViews in your database? Minimal outage? Oracle GoldenGate? Then extra steps are necessary to avoid FULL REFRESH of the MViews. @dohdatabase.com explains it in all detail - and be prepared for some really complex deep-dive read ... #Migration #OGG

Should you attempt double-hop Oracle Database upgrades? A long while ago I wrote a blog post about multiple-hop upgrades. And just recently I received many questions about whether one could skip Oracle Database 19c, and rather move into Oracle Database 23ai directly. So, the ask is: Should you…

Data Pump Bundle Patch for Oracle Database 23ai While I blogged in the past already several times about how important the Data Pump Bundle Patch for all kinds of migrations is, a question was in my inbox this morning: Is there a separate note for the Data Pump Bundle Patch for Oracle Database…