A cool customer is building a patching pipeline. AutoUpgrade fits perfect in there, but few pieces of information were missing. Here's a little inspiration and how you can tell if AutoUpgrade downloaded new patches.
Daniel Overby Hansen
Daniel Overby Hansen
@dohdatabase.com
Product Management Architect for Database Upgrade, Migrations, and Patching at Oracle. Views expressed are my own.
434 followers74 following328 posts
AutoUpgrade now also downloads patches for Oracle Exadata systems. Learn how to download and extract the Quarterly Full Stack Download Patch.
AutoUpgrade 26.6 introduces stronger keystore security. If your existing setup suddenly stops working, new password and file permission requirements might be the reason.
AutoUpgrade now also downloads patches for Oracle Enterprise Manager. Learn how to spend less time in My Oracle Support and more time with your databases.
Want a selfie? No problem! Want to talk tech? Let's schedule a meeting.
Daniel Overby Hansen reposted
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…
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.
You can move Advanced Queues around with Data Pump. It's easy but don't forget the small details.
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.
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?
AutoUpgrade stores your secrets in a secure way. Now, it also fits better with automation.
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.
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.
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.
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.
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!
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.
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.
If your foreign key constraints don't validate and you're missing parent rows, that sounds like a critical problem. But not always...
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?
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?
Assess the patching readiness of your Oracle AI Database with Datapatch Sanity Checks and avoid the common pitfalls.
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.
Daniel Overby Hansen reposted
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?…
My team took all our knowledge on statistics and migrations and compiled into an all tech, no marketing webinar.
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.
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.
If you want to download ALL your patches with just one command, check out AutoUpgrade download mode. youtu.be/OQy6pbF4_ls?...
It's that time folks... www.oracle.com/security-ale...
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.
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.
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.
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.
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.
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.
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.
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...
📚 New Reading List is out! This week, we have more ⭕ #Oracle AI #Database goodies with a bit of 🤓 #Linux know-how and 🤖 #AI interaction 📖 Happy reading!
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.
Upgrading a single PDB is a faster and more flexible option compared to a full CDB upgrade. But take about on your rollback plan.
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.
A full-day, in-person workshop for free. All tech, no marketing!
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).
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!
Use these step-by-step instructions and AutoUpgrade to bring your non-CDB safely 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. For instance, what about those optimizer fixes that are turned off?
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.