Derzeit keine Unterlagen zum Download verfügbar.
Oracle Database 21c should be out soon – but have you upgraded to Oracle 19c yet? And should you upgrade to Oracle 21c? That’s one of the many question you’ll get an answer for in this 45 min talk. I will demonstrate the upgrade to Oracle 19c and 21c – and highlight important differences and things
October 19-30 – APAC Virtual Groundbreakers Tour
- Website: https://www.apacgbt.com/?anchor=SCHEDULE
- Registration: https://oracle-groundbreakers-apac-virtual-tour-2020.heysummit.com/
- Agenda: https://oracle-groundbreakers-apac-virtual-tour-2020.heysummit.com/schedule/
- AutoUpgrade to Oracle 19c and 21c
- Oct 28, 2020 – 8:00h CEST
- Sign up here: https://oracle-groundbreakers-apac-virtua, Gl-tour-2020.heysummit.com/talks/autoupgrade-to-oracle-database-19c-and-21c/
Oracle Database 19c is the release you all need to upgrade to right now. And AutoUpgrade is THE tool which eases your life a lot. Whether you have only 5 databases or thousands, whether you plan to stay with non-CDB or migrate your databases to PDBs, AutoUPgrade will do all this for you with just a single config file – completely unattended but fully
The October 2020 Version of AutoUpgrade is available now for download since Friday last week. As usual, you can access it easily via MOS Note: 2485457.1 – AutoUpgrade Tool.
What’s new in the October 2020 version?
As usual you find the change.log at the end of MOS Note: 2485457.1 – AutoUpgrade Tool for the most recent Oracle Database upgrade tool. You will find the following fixes and enhancements:
- BUG_31709141 Allow the job state to be reset when database is restored manually
- AUPG-1862 ORA-65173 occurs when running the fix for
This may become a longer blog post. One of the customers I work with for many years contacted me a few weeks ago. After upgrade to 19c, it looked like as if some Unified Auditing Policies weren’t correct anymore. It started as a tiny issue, but thanks to the customer who analyzed down to the bones, it seems to be bigger than we thought at the beginning. So you may Check your Unified Auditing Policies after upgrading to Oracle 19c as well.
Actually a lot of my customers use Unified Auditing these …Continue reading...
In our Fallback talk we promote a backup strategy for large DWHs and database which are on purpose in NOARCHIVELOG mode. But last week I learned that there is something important to know about AutoUpgrade and the Partial Offline Backup Strategy. Otherwise you may hit a
Partial Offline Backup Strategy?
I won’t explain in all details what this is. If you’d like to read more, please find all the necessary information on my blog post from July 17, 2018:
with graphics included. In brief, you take …Continue reading...
In my previous blog post I demonstrated how you can upgrade with AutoUpgrade between two servers. This a very typical scenario where you get new server, often also with a newer operating system version installed. But I was wondering if you can use Oracle AutoUpgrade between two servers – and Plugin?
AutoUpgrade between two servers
Please see my previous blog post about all the details:
Upgrade and Plugin?
At the end of it, I was curious if I couldn’t just plugin afterwards. But I …Continue reading...
I try to catch up with missing AutoUpgrade posts. And I should have written this one a while earlier ideally. Just yesterday a colleague asked me about it. So it’s time now to describe how to use Oracle AutoUpgrade between two servers.
The Oracle Database 19c Upgrade Guide has this section about the scenario:
And you see that it consists of 5 steps:
- Run the -mode analyze step on source server
- Run the -mode fixups step on source server
- Shutdown and
I knew, one fine day I will have to dig into TDE. Resistance is futile. There were so many questions regarding AutoUpgrade with Transparent Data Encryption (TDE) in the past weeks and months. And the team is still working hard on a solution to make the non-CDB to PDB plugin flawless and automated for such cases. But I won’t cover the latter in this post here. I will solely focus on the database upgrade itself.
Almost everybody of you reading this blog post may have more knowledge of Transparent Data Encryption than I. …Continue reading...
In this blog post I’d like to demonstrate how to skip a fixup in AutoUpgrade. This can be very useful in cases where you know that an issue may happen. Recently we saw several cases with unexpected long runtime for the gathering of fixed objects stats.
During the analyze phase, AutoUpgrade creates a <SID>_checklist.cfg file. You will find it in your job’s prechecks subdirectory, e.g.
My SID is DB12, and 100 is the job number.
This is how the db12_checklist.cfg looks in my example:
[SID] [DB12] ========================================== [container] [DB12]… Continue reading...
I have heard and received this question several times. And I always pointed people to the status logs in AutoUpgrade’s logging directory. But I wasn’t aware how simple the monitoring can be. Kudos to my colleague Meir Burmanov from Oracle Israel for explaining me today how you can simply monitor AutoUpgrade: Refresh Status Information automatically.
Like it – and it’s very simple
This won’t be a long blog post. And maybe there are even more fancier ways to do the monitoring. But for me it does the job. And it is super simple. …Continue reading...
Thank you for participating in our 4 Database Upgrade to Oracle 19c seminars in the past two weeks. There were over 800 questions during the seminars – and it was a good idea that we prerecorded them. This way, I could answer your questions as it was a more convenient time for me than for Roy. We enjoyed it a lot – and from the feedback I read, most of you enjoyed it, too. Now please read about Upgrade Seminars 2020 – Recap and Videos on-demand below.
I uploaded all 4 decks …Continue reading...
Thank you for participating in the first two seminars. Roy and I did already the “Release and Patching Strategy” webinar on Tuesday, June 23. And today “AutoUpgrade to Oracle 19c”. So it time for Upgrade Seminars 1 and 2 – A quick recap, slides download and more.
I uploaded the slides already to https://mikedietrichde.com/slides/#WEB2020. Of course, I will upload the other slide decks as well to the same location.
As soon as the recordings page has been completed, we will send out an email. And I will post the links …Continue reading...
Roy and I delivered a similar seminar already for the Australia and New Zealand region. And now it is time at a more convenient time zone setting for EMEA and India. So if you are not tired of web seminars yet, please sign up for our Upgrade to Oracle Database 19c – Virtual Classroom Series.
4 Web Seminars – Going far beyond upgrades
The idea for this series of 4 web seminars is to cover not only the database upgrade itself. You will get much more than technical upgrade information. And we will …Continue reading...
Actually I blog about this topic for the simple reason that currently you won’t find helpful information in MyOracle Support. And I’ve seen this issue now twice in a row at Enterprise customers. You may see AutoUpgrade in trouble when you are short on RAM. During one of the restarts AutoUpgrade initiates you may get an ORA-600.
What you may see
At first, the alert.log – and this is the strange pattern here – does not give you any indication about this ORA-600. You will find it only in the logs written by autoupgrade.jar:…Continue reading...
I have to confess, this feature is out and available for quite a while. But only unofficially. AutoUpgrade can upgrade and plug in a non-CDB into a CDB. But it lacked flexibility. And we didn’t test it a lot. Hence, you could find it documented in our Hands-On Lab instructions. And we did this exercise with you already in our sold-out labs at OOW 2019 as well. But since a week and a bit, it is officially supported: AutoUpgrade and Plug In to a CDB – with a single command (and video).
Create… Continue reading...
Actually this weekend Roy and I would have flown from Australia to New Zealand. We planned at least 5 seminars. And we’ll do them in person as soon as conditions allow. If you are not tired yet of all these seminars offered to you, then we have the right offering for you.
And not only for those of you based in Australia and New Zealand. Singapore, Japan, Korea and other countries in this part of the globe. Roy and I will run for 4+1 Seminars: Upgrade, Migrate, Consolidate to 19c – not only for …Continue reading...
Thanks a lot to all of you who participated also in our second seminar. Below you find now 3 Live Seminars: Upgrade and Performance Seminar 2 Questions answered.
Your Questions, our Answers for Seminar 2: Upgrade and Performance
I this blog post I answer all questions from the second seminar about AutoUpgrade to Oracle 19c and Performance Stability. Please find the links to the other QAs for Seminar 1 (Release Strategy, Patching and Cool Features) and Seminar 3 (Migration to Multitenant) below in the Links section of this blog post.
Sometimes there is just a simple question at the beginning. Like Daniel and I discussed this morning. Does AutoUpgrade check if the time zone file in source is higher than in target? While we discussed this, I downloaded the patches already to try it out. And in addition, I could double-check whether the time zone patches for 19c are now RU-independent finally. But the question remains for Upgrade: What if your time zone in source is newer than in target?
My intention wasn’t initially to write a longer blog post. But read below …Continue reading...
What if … something goes wrong during your database upgrade with AutoUpgrade? Of course, this never happens. But just in case, no worries – one of the really big advantages of AutoUpgrade (and the command line upgrade with “dbupgrade” as well) is its resumability and restartablity. But in this blog post I would like to cover a bit more. I will show you more details on Troubleshooting, Restoring and Restarting AutoUpgrade.
And as often, the cause for this blog post is an email from Hervé Schweitzer, the CTO of dbi-services. Hervé told …Continue reading...
If you don’t deal with databases upgrades every day but just want to see a short and good overview about how to do a successful database upgrade, then this is for you. A few days ago we’ve made the Oracle Database Upgrade – Quick Start Guide available for download.
Why a Quick Start Guide?
If database upgrades are your daily topic, you won’t need our quick start guide. But if you need a short overview about the right steps to approach an upgrade, this guide is for you. Thanks to my PM colleague, …Continue reading...
Thanks to all our customers who participated in our evaluation test for RAC upgrade support with the AutoUpgrade Tool. And my colleagues worked hard to deliver the new version as quickly as possible. Just to make sure: This is not an April’s fools blog post. Since 2 days, you can download AutoUpgrade – New Version with RAC Database Upgrade Support.
Where to download it?
As usual, you can download the newest version – in this case 19.8 aka 20200327 from MOS Note: 2485457.1:
You simply copy the new version into your 19c (or …Continue reading...
Today my headline sounds a bit like “Little Red Riding Hood and the Big Bad Wolf” – but there is a reason why I’d like to write about about OJVM and the Mitigation Patch – Things to know in 2020. We are working with a customer right now where preupgrade.jar gave a warning about the existence of the Mitigation patch in an 126.96.36.199 home – despite the fact that JAVAVM is not configured in this database. And this looked strange to us.
A quick search on my blog shows me that …Continue reading...
Several times I’ve got asked by customers if AutoUpgrade does change the COMPATIBLE parameter. So let me explain what happens to COMPATIBLE when you upgrade. And give you also some hints about AutoUpgrade and the COMPATIBLE parameter.
Does AutoUpgrade change COMPATIBLE?
No. Clearly, AutoUpgrade does not change the COMPATIBLE parameter for several reasons. At first, we recommend to not change the COMPATIBLE parameter right after the upgrade if you can afford another downtime soon after. By keeping COMPATIBLE on the previous (before upgrade) value, you have the choice to revert back to the previous …Continue reading...
Actually this question came up internally. I did have no doubt that you don’t have to license Java in order to use AutoUpgrade. But a colleague had such doubts. So let’s clarify: Do you need to license Java for AutoUpgrade?
Or phrased in a different way: “Since Java 8 requires a Java subscription now. Does autoupgrade come with a license?”
Of course, No!
But where do the doubts come from? Actually this link here does not list the “Oracle Database” as a product. But there is this MOS Note …Continue reading...
Last week I’ve had one of those travel weeks where I accumulate many working hours already by flying and having layovers and delays at lovely airports. Plus of course, I work in addition and deliver full-day workshops. And see customers. Still, I won’t complain as I like my job a lot. Especially meeting with customers and discussing various upgrade and migration topics can be really challenging sometimes. And I can confess, Canada rocks – and is really cold in winter. Seriously …
One of these weeks …
When you travel to Canada in winter, especially in a January, you can …Continue reading...