I am jealous, and so happy. There are so happy about the fact that we have such skilled minds in the industry. One of them is Marcus Vinicius, an Oracle ACE Pro from Brazil who lives in Dallas, TX in the US. And besides being a real wizard he is also a super-nice guy. No idea where all these Brazilian Oracle experts “grow” but I am very proud to have two of the best in the world in our team. But back to Marcus. People do super-cool stuff … AutoUpgrade Composer is something Marcus put out in the wild.
… Continue reading...config file
ORA-12850 when you run AutoUpgrade?
Nicola made a comment the other day informing me that they hit an issue on some of their databases when upgrading. But is there a general issue with ORA-12850 when you run AutoUpgrade? Or is this error just the reflection of another issue? Let’s see, I will explain this and include a workaround as well.
Photo by Jamie Street on Unsplash
What is the problem?
Nicola traced it down mostly already. During the upgrade of their CDBs, this error happened in some runs:
with segments as (select /*+ MATERIALIZE PARALLEL(2) */ tablespace_name, inuse from( select ds.tablespace_name, row_number() over (partition by… Continue reading...
Can I convert a non-CDB into a CDB?
Those of you who work with the Multitenant or CDB architecture for a longer time may find this blog post title strange. But as I learned the other week at the German Oracle User Group conference (DOAG 2024), others still have this question: Can I convert a non-CDB into a CDB?
Photo by Jeffery Ho on Unsplash
Can you convert?
Short answer: No.
End-of-blog-post.
Well, of course, not.
Let me explain this a bit more.
When you have a non-CDB database today, you can’t convert it into a CDB (Container Database). This path isn’t possible but there is another path. …
Continue reading...AutoUpgrade’s Patching: The feature you waited for
Over the almost past 6 years since we unleashed it, AutoUpgrade changed Oracle Database upgrades significantly. But we’ve been asked so many times about one missing feature. And now it is available. Still in V.1, not feature complete (yet). And we know that you have wishes and desires. Stay with us, it’s going to improve rapidly. So, let us kick off AutoUpgrade’s Patching: The feature you waited for.
Photo by Ashim D’Silva on Unsplash
Wait a bit … AutoUpgrade Patching??
Yes, you are right. AutoUpgrade can patch your database from home A to home B for a longer …
Continue reading...Upgrading a non-CDB to Oracle Database 21c with AutoUpgrade
Yesterday I wrote about the installation of Oracle Database 21c on Linux. But today it is time for Upgrading to Oracle Database 21c with AutoUpgrade.
AutoUpgrade
You may have heard it already from us and other colleagues, but we can’t repeat it often enough: There is only one recommended tool to upgrade your databases – and this is AutoUpgrade.
In my 21c home, I’m checking the deployed version of AutoUpgrade at first:
[CDB3] oracle@hol:/u01/app/oracle/product/21/rdbms/admin $ java -jar autoupgrade.jar -version build.hash 57ab246 build.version 21.1.3 build.date 2021/04/21 13:32:13 build.max_target_version 21 build.supported_target_versions 12.2,18,19,21 build.type production
Now please …
Continue reading...Create and adjust the config file for AutoUpgrade 19c
This is the first of a series of blog post explaining the new AutoUpgrade utility step-by-step. You’ll find the tool and overview information in The New AutoUpgrade Utility in Oracle 19c
In this blog post here I will explain and demonstrate how you can create a sample config file and adjust it for a standard database upgrade.
You will see how to add additional options and change default settings. Furthermore, I will showcase how to change, adjust and tweak init.ora parameters during or after upgrade in the upcoming blog posts.
