Sign in

Daniel Overby Hansen

@dohdatabase.com
433 followers 74 following 322 posts

Product Management Architect for Database Upgrade, Migrations, and Patching at Oracle. Views expressed are my own.

PostsRepliesMedia
Daniel Overby Hansen @dohdatabase.com · 29/09/2026
Want a selfie? No problem! Want to talk tech? Let's schedule a meeting.
dohdatabase.com
Let’s Talk at Oracle AI World
Want a selfie? No problem! Want to talk tech? Let's schedule a meeting.
011
Reposted by Daniel Overby Hansen
Mike Dietrich @mikedietrichde.com · 23/09/2026
AI World 2026: Pre-Event Masterclass: Upgrade, Migration and Patching AI World this year in Las Vegas is going to happen in about 4.5 weeks from now on. In case you'll be there on Sunday (which makes perfect sense this year), you may want to consider signing up at AI World 2026: Pre-Event…
mikedietrichde.com
AI World 2026: Pre-Event Masterclass: Upgrade, Migration and Patching
AI World this year in Las Vegas is going to happen in about 4.5 weeks from now on. In case you'll be there on Sunday (which makes perfect sense this year), you may want to consider signing up at AI World 2026: Pre-Event Masterclass: Upgrade, Migration and Patching. Yes, we are doing it again. A full day of specially curated content - with very little overlap with out talks and labs.
023
Daniel Overby Hansen @dohdatabase.com · 22/09/2026
Here's a unique opportunity to learn about upgrades, migrations, and patching from our entire product management team. A full-day of intense learning and knowledge sharing.
dohdatabase.com
8 Hours of Intense Learning at AI World
Here's a unique opportunity to learn about upgrades, migrations, and patching from our entire product management team. A full-day of intense learning and knowledge sharing.
021
Daniel Overby Hansen @dohdatabase.com · 15/09/2026
You can move Advanced Queues around with Data Pump. It's easy but don't forget the small details.
dohdatabase.com
How to Export/Import A Single Queue Using Data Pump
You can move Advanced Queues around with Data Pump. It's easy but don't forget the small details.
010
Daniel Overby Hansen @dohdatabase.com · 08/09/2026
Gold images gives you several advantages and makes the installation of a new Oracle home much faster. AutoUpgrade makes it easy to create and use your own gold images.
dohdatabase.com
AutoUpgrade New Features: Create and Use Your Own Gold Images
Gold images gives you several advantages and makes the installation of a new Oracle home much faster. AutoUpgrade makes it easy to create and use your own gold images.
022
Daniel Overby Hansen @dohdatabase.com · 01/09/2026
Starting with Oracle AI Database 26ai, Oracle delivers fully updated gold images. They are much easier to install compared to a full Release Update. But what if you really want the Release Update?
dohdatabase.com
AutoUpgrade New Features: Download 26ai Release Update Rather Than Gold Image
Starting with Oracle AI Database 26ai, Oracle delivers fully updated gold images. They are much easier to install compared to a full Release Update. But what if you really want the Release Update?
000
Daniel Overby Hansen @dohdatabase.com · 25/08/2026
AutoUpgrade stores your secrets in a secure way. Now, it also fits better with automation.
dohdatabase.com
AutoUpgrade New Features: Share the AutoUpgrade Keystore Across Servers
AutoUpgrade stores your secrets in a secure way. Now, it also fits better with automation.
022
Daniel Overby Hansen @dohdatabase.com · 19/08/2026
Exascale is the next-generation database storage, offers great functionality and integrates nicely with Data Pump. Here's how to export and import using Exascale storage.
dohdatabase.com
How to Use Data Pump with Exadata Exascale Storage
Exascale is the next-generation database storage, offers great functionality and integrates nicely with Data Pump. Here's how to export and import using Exascale storage.
121
Daniel Overby Hansen @dohdatabase.com · 11/08/2026
It's so convenient to download patches using AutoUpgrade. This enhancement makes it easier to include in your automation or just give you an overview of what you've downloaded.
dohdatabase.com
AutoUpgrade New Features: The Patch Overview
It's so convenient to download patches using AutoUpgrade. This enhancement makes it easier to include in your automation or just give you an overview of what you've downloaded.
000
Daniel Overby Hansen @dohdatabase.com · 05/08/2026
Are you patching Exadata? I'm looking into whether we can enable download of Exadata software/patches in AutoUpgrade. Would that be useful? What would like to download? I'd be interesting in hearing your feedback and ideas.
021
Daniel Overby Hansen @dohdatabase.com · 03/08/2026
Here’s how to upgrade your encrypted non-CDB to Oracle AI Database using refreshable clone PDB. This method preserves the source database for rollback if needed and minimizes downtime by copying data files in advance.
dohdatabase.com
Upgrade Encrypted Oracle Database 19c Non-CDB to 26ai and Convert to PDB Using Refreshable Clone PDB
Here’s how to upgrade your encrypted non-CDB to Oracle AI Database using refreshable clone PDB. This method preserves the source database for rollback if needed and minimizes downtime by copying data files in advance.
000
Daniel Overby Hansen @dohdatabase.com · 31/07/2026
Friday fun testing a coming feature in AutoUpgrade that allows you to create your own gold images. Would you use such a feature or do you prefer to install from scratch every time?
AutoUpgrade config file showing the use of a new feature to create user-created gold images.AutoUpgrade console showing the use of a new feature to create user-created gold images.AutoUpgrade config file showing the use of a new feature to create user-created gold images.
031
Daniel Overby Hansen @dohdatabase.com · 28/07/2026
You can enter your passwords into the AutoUpgrade keystore for safe-keeping. But what about automation? Here's a neat trick to fully automate the process of loading passwords into the AutoUpgrade keystore.
dohdatabase.com
Automating AutoUpgrade: Populating the Keystore
You can enter your passwords into the AutoUpgrade keystore for safe-keeping. But what about automation? Here's a neat trick to fully automate the process of loading passwords into the AutoUpgrade keystore.
011
Daniel Overby Hansen @dohdatabase.com · 22/07/2026
In the absence of Data Guard, you can use RMAN incremental backups to move and upgrade a database with little downtime. Here's how to do it!
dohdatabase.com
Upgrade Oracle Database 11g to 19c Using RMAN Incremental Backups
In the absence of Data Guard, you can use RMAN incremental backups to move and upgrade a database with little downtime.
130
Daniel Overby Hansen @dohdatabase.com · 14/07/2026
Data Pump rejects your import if the database time zone file is different. Even without any TIMESTAMP WITH TIME ZONE. Here's why and how you can solve it.
dohdatabase.com
How To Avoid ORA-39405 During a Data Pump Import
Data Pump rejects your import if the database time zone file is different. Even without any TIMESTAMP WITH TIME ZONE. Here's why and how you can solve it.
010
Daniel Overby Hansen @dohdatabase.com · 08/07/2026
In a recent migration we needed a PDB with a specific timezone file version. The OCI cloud tooling doesn't give you an option to specify it. Here's a neat trick that'll give you what you want.
dohdatabase.com
How to Create an OCI PDB with a Specific Time Zone File Version
In a recent migration we needed a PDB with a specific timezone file version. Here's how to do that.
011
Daniel Overby Hansen @dohdatabase.com · 01/07/2026
If your foreign key constraints don't validate and you're missing parent rows, that sounds like a critical problem. But not always...
dohdatabase.com
Understanding ORA-02298 And Missing Parent Rows During Data Pump Import
If your foreign key constraints don't validate and you're missing parent rows, that sounds like a critical problem. But not always...
000
Daniel Overby Hansen @dohdatabase.com · 25/06/2026
When working with encrypted databases a missing rekey may cause problems later on. Like when you try to use refreshable clone PDB on an encrypted database. Do you remember to rekey your database?
dohdatabase.com
When You Forget To Rekey Your Encrypted Database
When working with encrypted databases a missing rekey may cause problems later on. Like when you try to use refreshable clone PDB on an encrypted database.
021
Daniel Overby Hansen @dohdatabase.com · 23/06/2026
AutoUpgrade makes it so much easier to download tools for Oracle AI Database. Do you have a favorite tool that AutoUpgrade should download for you?
dohdatabase.com
AutoUpgrade New Features: Download Tools (AHF, CVU, SQLcl)
AutoUpgrade makes even easier to get all the software for Oracle AI Database.
010
Daniel Overby Hansen @dohdatabase.com · 18/06/2026
Assess the patching readiness of your Oracle AI Database with Datapatch Sanity Checks and avoid the common pitfalls.
dohdatabase.com
Is Your Oracle AI Database Ready For Patching?
Assess the patching readiness of your Oracle AI Database with Datapatch Sanity Checks and avoid the common pitfalls.
031
Daniel Overby Hansen @dohdatabase.com · 15/06/2026
You should probably patch your Oracle AI Database more often? Here's a bunch of ideas that may reduce the burden of patching. Do you have other ideas? Drop a comment and let's discuss.
dohdatabase.com
How to Make Oracle AI Database Patching Easier
You should probably patch more often. Here's some advice that can help you ease the patching burden.
010
Reposted by Daniel Overby Hansen
Mike Dietrich @mikedietrichde.com · 11/06/2026
How to deal with statistics when you migrate? Have you done migration projects in the past, or do you have some upcoming projects, and you wonder how you should treat all sorts of statistics in your database? What is the better option? Keep and migrate the existing ones? Regather them right away?…
mikedietrichde.com
How to deal with statistics when you migrate?
Have you done migration projects in the past, or do you have some upcoming projects, and you wonder how you should treat all sorts of statistics in your database? What is the better option? Keep and migrate the existing ones? Regather them right away? A partial-move approach? How to deal with statistics when you migrate? Then this is for you. …
174
Daniel Overby Hansen @dohdatabase.com · 10/06/2026
My team took all our knowledge on statistics and migrations and compiled into an all tech, no marketing webinar.
dohdatabase.com
Statistics and Migrations – Well-Kept Secrets Revealed
Join us for a zero marketing, all tech webinar.
021
Daniel Overby Hansen @dohdatabase.com · 04/05/2026
Recent Webinars on Database Patching Downloading patches from My Oracle Support is so last year. Use AutoUpgrade instead! How? Check these recent webinars and get up-to-date on the latest development in database patching.
dohdatabase.com
Recent Webinars on Database Patching
Downloading patches from My Oracle Support is so last year. Use AutoUpgrade instead! How? Check these recent webinars and get up-to-date on the latest development in database patching.
021
Daniel Overby Hansen @dohdatabase.com · 23/04/2026
The Easiest Way to Download the Latest OPatch You don't have to connect to My Oracle Support to find the latest OPatch. There's a much easier way.
dohdatabase.com
The Easiest Way to Download the Latest OPatch
You don't have to connect to My Oracle Support to find the latest OPatch. There's a much easier way.
063
Daniel Overby Hansen @dohdatabase.com · 22/04/2026
If you want to download ALL your patches with just one command, check out AutoUpgrade download mode. youtu.be/OQy6pbF4_ls?...
youtu.be
Virtual Classroom #27: Patch Smarter, Not Harder - Oracle Database Patching with AutoUpgrade
YouTube video by Oracle AI Database: Upgrade / Migration / Patching
021
Daniel Overby Hansen @dohdatabase.com · 09/04/2026
AutoUpgrade New Features: Download the Newest AutoUpgrade.jar Now, there's no excuse for using an old version of AutoUpgrade. Plus, a little peek at what the next version of AutoUpgrade brings. Hint: It's about AHF, CVU and SQLcl.
dohdatabase.com
AutoUpgrade New Features: Download the Newest AutoUpgrade.jar
Now, there's no excuse for using an old version of AutoUpgrade. Plus, a little peek at what the next version of AutoUpgrade brings. Hint: It's about AHF, CVU and SQLcl.
010
Daniel Overby Hansen @dohdatabase.com · 07/04/2026
AutoUpgrade New Features: Download Bundle Patches for Spatial and Text AutoUpgrade makes it even easier to get your patches with support for Oracle Text and Spatial bundle patches.
dohdatabase.com
AutoUpgrade New Features: Download Bundle Patches for Spatial and Text
AutoUpgrade makes it even easier to get your patches with support for Oracle Text and Spatial bundle patches.
021
Daniel Overby Hansen @dohdatabase.com · 31/03/2026
Upgrade Oracle Database PDB 19c to 26ai with Data Guard and Re-using Data Files (Enabled Recovery) You get the fastest upgrade by upgrading a single PDB. You can even bring the standby database along and protect your PDB immediately. But there are a few things to be aware of.
dohdatabase.com
Upgrade Oracle Database PDB 19c to 26ai with Data Guard and Re-using Data Files (Enabled Recovery)
You get the fastest upgrade by upgrading a single PDB. You can even bring the standby database along and protect your PDB immediately. But there are a few things to be aware of.
011
Daniel Overby Hansen @dohdatabase.com · 26/03/2026
Upgrade Oracle Database 19c PDB to 26ai with Data Guard and Restoring Data Files (Deferred Recovery) Upgrading a single PDB is the fastest option, but what about Data Guard? Here's how to upgrade a PDB while ensuring the standby protects the PDB.
dohdatabase.com
Upgrade Oracle Database 19c PDB to 26ai with Data Guard and Restoring Data Files (Deferred Recovery)
Upgrading a single PDB is the fastest option, but what about Data Guard? Here's how to upgrade a PDB while ensuring the standby protects the PDB.
031
Daniel Overby Hansen @dohdatabase.com · 24/03/2026
Upgrade Oracle Database 19c CDB to 26ai with Data Guard – Standby Offline Method Keep the standby offline during your upgrade to add another layer of safety. Here's how to do it and what you should be aware of.
dohdatabase.com
Upgrade Oracle Database 19c CDB to 26ai with Data Guard – Standby Offline Method
Keep the standby offline during your upgrade to add another layer of safety. Here's how to do it and what you should be aware of.
000
Daniel Overby Hansen @dohdatabase.com · 19/03/2026
Upgrade Oracle Database 19c CDB to 26ai with Data Guard – MAA Method Upgrading Data Guard is easy when you use AutoUpgrade. Here's one way of doing it - using the MAA method - which keeps downtime low.
dohdatabase.com
Upgrade Oracle Database 19c CDB to 26ai with Data Guard – MAA Method
Upgrading Data Guard is easy when you use AutoUpgrade. Here's one way of doing it - using the MAA method - which keeps downtime low.
022
Daniel Overby Hansen @dohdatabase.com · 17/03/2026
Here’s how to upgrade a single PDB using refreshable clone PDB. It’s a faster approach but you must take care of your standby database.
dohdatabase.com
Upgrade Oracle Database 19c PDB to 26ai with Data Guard using Refreshable Clone PDB
Here’s how to upgrade a single PDB using refreshable clone PDB. It’s a faster approach but you must take care of your standby database.
022
Daniel Overby Hansen @dohdatabase.com · 10/03/2026
Catch up or sharpen your "DBA-Linux" skills with these short educational videos from my colleagues over in the Linux dept. www.youtube.com/watch?v=7bq4...
youtube.com
Proc File System on Oracle Linux
YouTube video by Oracle Learning
020
Daniel Overby Hansen @dohdatabase.com · 24/02/2026
Here’s how to upgrade a single PDB using refreshable clone PDB. It’s a faster approach with an excellent rollback option; it preserves the source PDB.
dohdatabase.com
Upgrade Oracle Database 19c PDB to 26ai using Refreshable Clone PDB
Here’s how to upgrade a single PDB using refreshable clone PDB. It’s a faster approach with an excellent rollback option; it preserves the source PDB.
011
Daniel Overby Hansen @dohdatabase.com · 17/02/2026
Upgrading a single PDB is a faster and more flexible option compared to a full CDB upgrade. But take about on your rollback plan.
dohdatabase.com
Upgrade Oracle Database 19c PDB to 26ai
Here's how to upgrade a single PDB. It's a faster approach, but consider your rollback options.
021
Daniel Overby Hansen @dohdatabase.com · 27/01/2026
Here's how to upgrade your 19c non-CDB to Oracle AI Database 26ai when you have Data Guard and want to re-use the data files and go live faster.
dohdatabase.com
Upgrade Oracle Database 19c Non-CDB to 26ai and Convert to PDB with Data Guard and Reusing Data Files (Enabled Recovery)
Here's how to upgrade your 19c non-CDB to Oracle AI Database 26ai when you have Data Guard and want to re-use the data files and go live faster.
033
Daniel Overby Hansen @dohdatabase.com · 20/01/2026
What's the worst a speaker has put you through? I'm doing a presentation on public speaking and I'd like some example of what not to do. What do you think should be banned from public speaking or presentations?
500
Daniel Overby Hansen @dohdatabase.com · 20/01/2026
A full-day, in-person workshop for free. All tech, no marketing!
dohdatabase.com
Free Upgrade/Patching/Migration Workshops In Denmark, Sweden and Finland
A full-day, in-person workshop for free. All tech, no marketing!
011
Daniel Overby Hansen @dohdatabase.com · 15/01/2026
Brand-new monitors from Samsung today. Nice 27" ones. Built-in USB-C hub, ethernet, plus tons of USB-A. But not a single USB-C outlet... What on earth! That's just ridiculous. Yes, I should have done my homework, but come one. Who would produce such stuff today! 🫣😡
020
Daniel Overby Hansen @dohdatabase.com · 12/01/2026
Here's how to upgrade your 19c non-CDB to Oracle AI Database 26ai when you have Data Guard and want to re-use the data files (the easy, but slow way).
dohdatabase.com
Upgrade Oracle Database 19c Non-CDB to 26ai and Convert to PDB with Data Guard and Restoring Data Files (Deferred Recovery)
Here's how to upgrade your 19c non-CDB to Oracle AI Database 26ai when you have Data Guard and want to re-use the data files (the easy, but slow way).
000
Daniel Overby Hansen @dohdatabase.com · 08/01/2026
Upgrade your non-CDB to Oracle AI Database using AutoUpgrade and refreshable clone PDB. This method preserves the source database for rollback if needed and minimizes downtime by copying data files in advance. My absolute favorite!
dohdatabase.com
Upgrade Oracle Database 19c Non-CDB to 26ai and Convert to PDB Using Refreshable Clone PDB
Here's how to upgrade your non-CDB to Oracle AI Database using refreshable clone PDB. This method preserves the source database for rollback if needed and minimizes downtime by copying data files in advance.
020
Daniel Overby Hansen @dohdatabase.com · 05/01/2026
Use these step-by-step instructions and AutoUpgrade to bring your non-CDB safely to Oracle AI Database 26ai
dohdatabase.com
Upgrade Oracle Database 19c Non-CDB to 26ai and Convert to PDB
Use these step-by-step instructions and AutoUpgrade to bring your non-CDB safely to Oracle AI Database 26ai
132
Daniel Overby Hansen @dohdatabase.com · 29/12/2025
You made it! You've upgraded your database. But before allowing users back in, let's do a few final touches. For instance, what about those optimizer fixes that are turned off?
dohdatabase.com
Important Things after Upgrading to Oracle AI Database 26ai
You made it! You've upgraded your database. But before allowing users back in, let's do a few final touches.
010
Daniel Overby Hansen @dohdatabase.com · 22/12/2025
You need to download software and patches plus install a new Oracle home before you can upgrade. AutoUpgrade does all that with just two commands.
dohdatabase.com
Install a New Oracle home for Oracle AI Database 26ai
You need to download software and patches plus install a new Oracle home before you can upgrade. AutoUpgrade does all that with just two commands.
031
Daniel Overby Hansen @dohdatabase.com · 18/12/2025
Here's how you can upgrade your database to the next release of Oracle AI Database. Detailed step-by-step instructions for your container database.
dohdatabase.com
Upgrade Oracle Database 19c CDB to Oracle AI Database 26ai
Follow these step-by-step instructions and upgrade your CDB with ease.
050
Daniel Overby Hansen @dohdatabase.com · 16/12/2025
When migrating databases you can save time by excluding the audit trail. Here's how to do it.
dohdatabase.com
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.
040
Daniel Overby Hansen @dohdatabase.com · 11/12/2025
Preparations are the key to success. Here's my list of recommended actions that increases your chance of upgrading with success.
dohdatabase.com
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.
151
Daniel Overby Hansen @dohdatabase.com · 09/12/2025
While doomscrolling I came across an interesting discussion. How do you protect your database before an upgrade? Here are my thoughts!
dohdatabase.com
The Best Approach For Backup Before Upgrade
While doomscrolling I came across an interesting discussion. How do you protect your database before an upgrade?
211
Daniel Overby Hansen @dohdatabase.com · 05/12/2025
Seriously? Again!
100