Upgrade Oracle Database 19c CDB to Oracle AI Database 26ai
Follow these step-by-step instructions and upgrade your CDB with ease.
How to Exclude Audit Trail From Data Pump Export
When migrating databases you can save time by excluding the audit trail. Here’s how to do it.
How to Prepare Your Oracle Database for Release 26ai
Preparations are the key to success. Here’s my list of recommended actions that increases your chance of upgrading with success.
The Best Approach For Backup Before Upgrade
While doomscrolling I came across an interesting discussion. How do you protect your database before an upgrade?
RAC Rolling Patching in Autoupgrade – Looking for Early Testers
Support for RAC rolling patching in AutoUpgrade has been on our wishlist for a while. Finally, our developers are about to write the last lines of code.
If you’d like to give it a try, here’s your chance.
Upgrade to Oracle AI Database 26ai
Get a head-start on your upgrade to Oracle AI Database 26ai. Get to know the basics – also about the multitenant conversion.
How to Use NOLOGGING to Make Imports Faster
NOLOGGING operations are all about making data loads faster. A Data Pump import is all about data loading. Here’s how you can do it with Data Pump, along with the pitfalls you must be aware of.
AutoUpgrade New Features: Get Latest JDK Patches
Three small letters in your AutoUpgrade config file, and your SecOps team will thank you!
New Webinars
Free learning coming your way! Sign up today, so you don’t miss out. All tech, no marketing!
How To Export To ASM Storage – The Full Picture
Here’s a guide for moving data using Data Pump and ASM storage. It includes instructions for transferring the file between the two systems.
How to Fix Errors in AutoUpgrade Download Mode
To use AutoUpgrade download mode, you must be able to connect to specific Oracle servers. Here’s a list of requirements and a few hints for solving common problems.
Using Data Pump Exports As Long-Term Storage
How do you use all the options in Data Pump to make the most efficient export to long-term storage? Here’s a list of parameters that I would consider using.
How I Think You Should Create Your Container Databases
In the multitenant architecture in Oracle AI Database, the container database is essential. If you create it the right way, you can avoid some difficulties later on. Here’s my recommendation for creating container databases.
That’s a Wrap! Oracle AI World 2025
Flip through our slides and get updated on the news on Oracle AI Database 26ai. Also, get a glimpse of my impressions from an intensive experience.
Oracle Influencers
Here a list of Oracle people that I follow for updates on Oracle database tech. Have a look – perhaps you’re missing out.
Copy Data Pump Files Before the End of the Export
If your migration is tight on time, you can save time by copying the Data Pump dump files before the export completes.
How To Upgrade 100 PDBs And Move Them To Another Server
If you need to move 100 PDBs to new hardware and upgrade to Oracle Database 23ai, what would you do? AutoUpgrade and Refreshable Clone PDBs sounds like a perfect match.
Oracle AI World – Come Say Hi!
Want to stay updated on Oracle Database upgrades, migrations and patching? Here’s a list of sessions at Oracle AI World that’ll give you a full update.
AutoUpgrade New Features: A Very Easy Way To Generate A Config File
Writing a config file is essential for using AutoUpgrade efficiently. There are many parameters to choose from, but here’s a really easy way of getting started.
Patching Eats Your SYSTEM Tablespace
Patching any piece of software is essential. Datapatch is smart and keeps your Oracle Database protected at the cost of space in SYSTEM. But you can reclaim that space. How much can you save?
AutoUpgrade New Features: Create Oracle Home Path Dynamically
Having the database patch level as part of the Oracle home makes it easy to get an overview of your Oracle homes. AutoUpgrade can include release and patch level in your Oracle home path automatically. This change makes it easier to automate your patching.
Data Pump Export Doesn’t Use Schema Name to Exclude a Table
Although Data Pump is a very versatile and flexible tool, it sometimes won’t do what you need. So, let’s talk about workarounds.
How To Downgrade a PDB from Oracle Database 23ai
Even months after an upgrade, you can go back to the previous release of Oracle Database – with NO data loss. A downgrade is a powerful option that you hopefully never need.
AutoUpgrade New Features: Patch OCW Component In Oracle Home
Staying fully up-to-date is now even easier when you patch with AutoUpgrade.
AutoUpgrade New Features: Custom Oracle Home Name
When AutoUpgrade creates Oracle homes for you, you get more control over the details.
Can I Use the Oracle Database 23ai Preinstall RPM for Oracle Database 19c?
A customer wanted to prepare for Oracle Database 23ai by using the 23ai preinstallation RPM for new servers. Would that work for Oracle Database 19c?
How To Install Data Pump Bundle Patch On Running Database Without Downtime
The Data Pump bundle patch is important for any running Data Pump jobs. Installing the bundle patch is easy – and you can do it without downtime.
The Easiest Way To Download Patches for Oracle Grid Infrastructure
You can use AutoUpgrade to download patches for Oracle Grid Infrastructure. Use the patches in your own automation, Fleet Patching and Provisioning, or other tools.
Oracle DatabaseWorld
Get an overview with the keynotes or dive into the details in specialized sessions.
Fixing AutoUpgrade PATCH111 Error On Oracle Linux 9
Here’s how to fix that annoying error when installing an Oracle home on Oracle Linux 9 using AutoUpgrade
Where Is The OJVM Bundle Patch For Oracle Database 23ai?
If you have JAVAVM installed in your Oracle Database, you are used to apply the OJVM bundle patch. But where did it go in Oracle Database 23ai?
AutoUpgrade New Features: Install Oracle Home on Brand-New, Empty Server
You can use AutoUpgrade to install an Oracle home on a brand-new, empty server.
Previously, AutoUpgrade used an existing Oracle home to determine how to create a new Oracle home. Now, you can use config file parameters to instruct AutoUpgrade on installing the new Oracle home.
This allows you to use AutoUpgrade to prepare…
Pump Your Data Pump Skills
Never stop learning!
Invest two hours and in return you get expert knowledge on Oracle Data Pump.
When A Refreshable Clone Takes Over The Service
Another good reason why your application should not use the default service when connecting to the database.
Data Pump Creates Your Indexes Even Faster
Without any configuration, Data Pump now creates your indexes faster during import. This can significantly reduce the overall runtime.
AutoUpgrade New Features: Run root.sh After Oracle Home Creation
AutoUpgrade Patching continues to make it even easier to patch your Oracle Database. After installing a new Oracle home, it will automatically run the root.sh script if there’s sudo privileges.
How to Patch Oracle Net Listener
Don’t forget to patch the Net Listener when you’re patching your Oracle Database. It’s very easy, but still there are a few things to consider.
How to Patch Oracle Database on Exadata Cloud@Customer using Out-Of-Place
Don’t miss out on the benefits of out-of-place patching. It’s easy using the cloud tooling.
Upgrade a PDB to Oracle Database 23ai Using Replay Upgrade
Oracle Database 23ai introduces Replay Upgrade for easier PDB upgrades – at least at first glance. But there are still important tasks that you must carry out.
AutoUpgrade New Features: Better Automation To Patch Oracle Database on Windows
Although, Oracle Database runs differently on Windows, you can still use the power of AutoUpgrade to patch or upgrade your database. Here’s how to do it.
AutoUpgrade New Features: Include Monthly Recommended Patches When Patching
Use AutoUpgrade to conveniently get access to the very latest bundle of critical fixes for a Release Update. AutoUpgrade now supports Monthly Recommended Patches.
Using Refreshable Clone PDBs from a Standby Database
When upgrading larger databases using refreshable clone PDBs, it’s worth considering to offload the cloning work to a standby database. Here’s how to do it.
The Easiest Way to Download 19.27 Release Update
Let me show you the easiest way to get the latest Release Updates. Once you see this, you’ll never download patches any other way.
AutoUpgrade New Features: Using Proxy to Download Patches
Don’t let a proxy server stop you from using the download mode in AutoUpgrade. Here’s how to connect through a proxy, so you can download patches in a jiffy.
Get the Slides and Recording Of “Migration to Oracle Autonomous Database – Part 1: Planning”
Last week, we aired our first webinar in our 4-part series on migration to Oracle Autonomous Database. Get the recording, slides and Q&A to boost your knowledge.
Hey, Let Me Kill Your Network!
Refreshable clone PDBs are a great way of upgrading PDBs. And they are super fast too. Perhaps even too fast…
Full-day Workshop in The Netherlands and Belgium
Mike Dietrich and I are hosting advanced workshops on Oracle Database 19c and 23ai, covering practical upgrades, migrations, and new features. Registration is required; join us in Utrecht and Vilvoorde.
AutoUpgrade Never Fails, But When It does
Help yourself, by helping us. If you run into problems with AutoUpgrade, stuff all the evidence into a zip file, so we can start troubleshooting.
AutoUpgrade New Features: Control Start Time When Using Refreshable Clone PDBs
Refreshable clone PDBs are great for migration and upgrades. The latest enhancement gives you even tighter control over the entire process.
Introduction to Patching Oracle Data Guard
It’s easy to patch Oracle Data Guard using AutoUpgrade. Let’s look at the options and find the best method for your Oracle Database.
How To Patch Oracle Data Guard Using AutoUpgrade And Standby-First Patch Apply With Switchover
Standby-first patch apply is a straightforward method for patching an Oracle Data Guard. Reduce the interruption to the time it takes to perform a switchover. It can be easily done using Oracle AutoUpgrade.
Avoid Problems on the Primary Database by Testing on a Snapshot Standby
Take your patching skills to the next level by testing patches on your standby database.
“Testing on the standby? You must be kidding!”
No, I’m not. Snapshot standby allows you to detect problems before they hit the primary database and affect your users.
How To Patch Oracle Data Guard Using AutoUpgrade For Non-Standby-First Installable Patches
Occasionally, you run into patches that are not standby-first installable. Using AutoUpgrade, you can still apply such patches with little effort. Here’s how you do it!
How To Patch Oracle Data Guard Using AutoUpgrade And Standby-First Patch Apply With Restart
Standby-first patch apply is a straightforward method for patching an Oracle Data Guard. It can be easily done using Oracle AutoUpgrade.
Why Is the Data Pump Bundle Patch Not Included in Release Updates?
Learning why also gives you insights into the patching process of Oracle Database. Did you know that you can apply the Data Pump bundle patch completely without downtime?
AutoUpgrade New Features: Extended Platform Support
Use AutoUpgrade Patching on even more platforms. This also means you can download patches to multiple platforms using one config file and one command.
Full Day Workshop in London
A great opportunity to learn directly from Product Management about patching, upgrading, multitenant and so much more. Sign up before it’s too late.
AutoUpgrade New Features: List All Checks
Don’t do things twice! Especially when it comes to upgrading and patching. Learn about all the checks executed by AutoUpgrade, so you can trim your runbook and reduce the load during maintenance windows.
How to Patch Oracle RAC Database 19c Using Manual Out-Of-Place
You can patch Oracle RAC Database without using OPatchAuto. You can do it out-of-place manually which is handy if you want to automate your patch process and have more control.
Which Grid Infrastructure Should I Install on My Brand New Exadata?
For a mission-critical system, you want to minimize risk to ensure maximum stability. How does that influence your choice of software?
Recreate Database Services After Moving An Oracle Database
It’s important that you connect to Oracle Database via services. It brings many benefits and it is the recommended method. But how do you keep those services when you move a database around?
Patch Me If You Can
When you patch your Oracle Database, it’s important to get it right to avoid downtime. Sharpen your skills in our hands-on lab.
It’s better to fail in our lab, than in production.
Can I Use Data Pump for Incremental Backups of a Table?
What exactly is an incremental export. What are the requirements? Are there any other tools or techniques you can use?
Upgrade Oracle Base Database Service to Oracle AI Database 26ai
Upgrading a Base Database Service is easy—just press the button. But what happens underneath the hood, and where can you find all the details?
How To Roll Back After Patching
If you run into problems after patching, it’s easy to roll back. Either fully automated using AutoUpgrade or even after go-live using a manual approach. Get the details.
Grid Infrastructure 19c Out-Of-Place Patching Fails on AIX
Patching Grid Infrastructure on AIX might cause problems when you follow my recommendations and use out-of-place patching. Here’s how to overcome it.
Reflections On 2024
What happened in 2024? Which was the most popular blog post? How can you make 2025 even better?
Fast Refresh Materialized Views and Migrations Using GoldenGate
Fast refresh materialized views are often vital for performance in an Oracle Database and business processes might depend entirely on them. When you migrate your database using Oracle GoldenGate there are several options at your disposal.
Fast Refresh Materialized Views and Migrations Using Transportable Tablespaces
Fast refresh materialized views are often vital for performance in an Oracle Database and business processes might depend entirely on them. When you migrate your database how do you ensure that a costly complete refresh won’t be needed?
AutoUpgrade New Features: Upgrade RMAN Catalog Schema
After upgrading and patching, you must upgrade the RMAN catalog schema if you are using RMAN backups. The latest version of AutoUpgrade automates this step for you.
AutoUpgrade New Features: Drop Database Link When Using Refreshable Clones
I’m a huge fan of refreshable clones for upgrades and non-CDB to PDB migrations. This little enhancement to AutoUpgrade makes it even easier to use.
Control The Final Refresh When Using Refreshable Clone PDBs in AutoUpgrade
Refreshable clone PDBs are a great method for migrating and upgrading Oracle Database. AutoUpgrade completely automates it, but sometimes, you need to be in control. Here’s how to get more control over the process.
AutoUpgrade New Features: Update Enterprise Manager Configuration
To further automate upgrade and patching of Oracle Database, AutoUpgrade now interacts with Oracle Enterprise Manager. Use the new functionality to create blackouts and update target configuration.
Easier Patching of Oracle Database on Windows
You can now use the new AutoUpgrade Patching functionality on Windows. Get the details and learn how to easily get the latest version of AutoUpgrade
How to Patch Oracle Restart 19c and Oracle Data Guard Using Out-Of-Place Switch Home
Patching out-of-place offers many advantages. Here’s how you can do it for Oracle Data Guard in an Oracle Restart configuration.
Goodbye X, Hello Bluesky
The Oracle community on Bluesky is booming. Don’t miss out and join the tech discussion over there. It’s like Twitter in the good old days.
How to Patch Oracle Restart 19c and Oracle Database Using Out-Of-Place Switch Home
Patching out-of-place gives you control and it reduces risk. You can patch Oracle Restart and Oracle Database in one operation. Here’s how to do it.
How to Upgrade Oracle Database with Username and Password
Normally, you upgrade Oracle Database using ” / as sysdba”. But you can also upgrade without native operating system authentication and rely on username/passwords instead.
What Is Data Pump Import Doing In PROCACT_SCHEMA
A customer noticed Data Pump spent a lot of time on PROACT_SCHEMA. Learn how we identified the underlying issue and saved almost four hours of import time. Plus, a few words about the PROCACT_SCHEMA phase.
An Important Milestone
Your feedback matters! Learn why feedback is the fuel for my blog. Plus, understand why this, the 200th blog post, is an important milestone.
How to Patch Oracle Database With One Command
AutoUpgrade continues to make your DBA life easier. The latest enhancement allows you to patch a database with one command – and that includes downloading patches and building the new Oracle home.
Faster Data Pump Import of LOBs Over Database Link
Network imports are convenient but come with limitations. If you are importing a huge LOB can you overcome the limitations?
Big Patching News Ahead
The latest version of AutoUpgrade makes patching Oracle Database so much easier. How can you learn more and make the next patch cycle a breeze?
VIEWS_AS_TABLES – A Hidden Data Pump Gem
A powerful feature that allows advanced transformation and faster network imports when used with the QUERY parameter.
Can I Name My PDB in Lowercase?
What are the requirements for PDB names in Oracle Database? Can you name your PDB in lowercase?
How to Speed up Data Pump Imports Using NOVALIDATE Constraints
If you’re short on time, you can transform constraints to “not validated”. Potentially, this is a huge time saver, but be aware of the drawbacks.
Finish 2024 With Great Tech Learning
DOAG 2024 Conference + Exhibition is a marvelous tech event. The speaker line-up is world-class and there is a guarantee for learning new things
How to Solve DCS-12300:Failed to Clone PDB During Remote Clone (DBT-19407)
Cloning a PDB from 12c to 23ai might cause an error because the Multimedia component is installed. Here’s how to fix it.
How to Trace Oracle Data Pump
Here’s my favorite recipe for diagnosing Oracle Data Pump issues. Use this approach to get the best starting point for tracing Oracle Data Pump.
Our Real World Database Upgrade and Migration Workshop Is Back on the Road
We have three more full-day workshops in the pipeline. Join us for a fun day – all tech, no marketing!
Sure, Let Me Analyze This 200.000-Line Log File
Large migrations often produce huge log files. How can you digest all that information and determine the outcome of the migration?
Oracle CloudWorld 2024 – It’s a Wrap
The final words from CloudWorld 2024 and the slides from our sessions. Plus, learn how to save $100 on your OCW25 registration.
Oracle CloudWorld Day 3+4
The day of “The Party” – plus a visit to see The Sphere. The craziest event venue you could imagine.
Oracle CloudWorld Day 2
Get to the CloudWorld hub and experience all the fuzz. Pet the dogs and come by our booth to hear about the new groundbreaking changes for patching Oracle Database.
A Few Details about Using Refreshable Clone PDB for Non-CDB to PDB Migration
AutoUpgrade and refreshable clone PDB is an awesome method for migrating non-CDB databases. Pay attention to a few details so you don’t run into problems.
An Intense Learning Experience with the Product Management Team
Supercharge your Oracle CloudWorld experience — start with our pre-event training!
The Best Questions on Oracle Multitenant
Get the Q&A from our last webinar about Multitenant. There are many good questions that you can use to deepen your knowledge.
Something went wrong. Please refresh the page and/or try again.
Databases Are Fun 