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.
Daniel Overby Hansen
@dohdatabase.com
Product Management Architect for Database Upgrade, Migrations, and Patching at Oracle. Views expressed are my own.
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.
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.
dohdatabase.com
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?
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.
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.
dohdatabase.com
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!
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.
dohdatabase.com
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.
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.
dohdatabase.com
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.
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.
dohdatabase.com
If your foreign key constraints don't validate and you're missing parent rows, that sounds like a critical problem. But not always...
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...
dohdatabase.com
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?
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.
dohdatabase.com
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?
AutoUpgrade New Features: Download Tools (AHF, CVU, SQLcl)
AutoUpgrade makes even easier to get all the software for Oracle AI Database.
dohdatabase.com
Assess the patching readiness of your Oracle AI Database with Datapatch Sanity Checks and avoid the common pitfalls.
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.
dohdatabase.com
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.
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.
dohdatabase.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?…
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. …
mikedietrichde.com
My team took all our knowledge on statistics and migrations and compiled into an all tech, no marketing webinar.
Statistics and Migrations – Well-Kept Secrets Revealed
Join us for a zero marketing, all tech webinar.
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.
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
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.
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
If you want to download ALL your patches with just one command, check out AutoUpgrade download mode. youtu.be/OQy6pbF4_ls?...
Virtual Classroom #27: Patch Smarter, Not Harder - Oracle Database Patching with AutoUpgrade
YouTube video by Oracle AI Database: Upgrade / Migration / Patching
youtu.be
Connor McDonald on Database and SQL@connormcd.bsky.social · 4mo agoIt'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 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 Bundle Patches for Spatial and Text AutoUpgrade makes it even easier to get your patches with support for Oracle Text and Spatial bundle patches.
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
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 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 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 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 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 – 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 – 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.
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
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.
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.
dohdatabase.com
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...
Proc File System on Oracle Linux
YouTube video by Oracle Learning
youtube.com
Gerald Venzl@gvenzl.bsky.social · 5mo ago📚 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.
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.
dohdatabase.com
Upgrading a single PDB is a faster and more flexible option compared to a full CDB upgrade. But take about on your rollback plan.
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.
dohdatabase.com
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.
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.
dohdatabase.com
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?
A full-day, in-person workshop for free. All tech, no marketing!
Free Upgrade/Patching/Migration Workshops In Denmark, Sweden and Finland
A full-day, in-person workshop for free. All tech, no marketing!
dohdatabase.com