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).
To be very honest, when I posted a few days ago, Oracle Database 19c is certified on OL8/RHEL8 I didn’t check for the Oracle Clusterware (OCW) certification. I blindly assumed that this is the case. But from comments and discussions on twitter, I realized it may be necessary to point this out explicitly to avoid confusion. Even though my fellow mate, RAC Product Manager Anil Nair has pointed it out already many times: Of course, Oracle Clusterware is certified on OL8/RHEL8 as well.
Find it on MOS
Your source for certification information …Continue reading...
Oh … I’d say this was the question I’ve got asked the second most often in the past months (after a potential extension for Oracle 18.104.22.168 support): When will Oracle certify OL8 and RHEL8? And I read this question internally even more often. Now thanks to my team mate Daniel Overby Hansen who spotted it on Twitter on the weekend, we can tell you that … finally … drum roll … Oracle Database 19c is certified on OL8 and RHEL8.
How do you get the information?
Go to MyOracle Support and hit …Continue reading...
Yesterday, Daniel pinged me to discuss an upgrade testing scenario I had evaluated briefly by myself a while ago. I can’t remember why I gave up. But Daniel had some great ideas and tried already a lot in our OCI cloud. We want to use a refreshable PDB. And keep it up to date, then upgrade it. The idea of this approach: Whereas a CLONE or RELOCATE uses the initial command as the marker, a REFRESH would allow me to be way more in synch. So the question is: Upgrade Testing with a Refreshable PDB – does this work?… Continue reading...
This is the third and final QA blog post for the Seminars we did in the last week of April 2020. Thank you for your attendance. I will publish the replay recordings as soon as they are available and link them as well. For now, please find here 3 Live Seminars: Multitenant Seminar 3 Questions answered.
Your Questions, our Answers for Seminar 3: Multitenant
|103||We are in the process of migrating to Oracle Cloud using the xtts method for cross platform migration and we seem to be encountering an issue with it|
Thanks a lot to all of you who participated this week in the 3 live Seminars about Database Upgrade, Performance Stability and Multitenant. We were just overwhelmed but so many tuning in. And I hope you’ve enjoyed it. As promised here you’ll get more. So find here for all 3 Live Seminars: Slides Download and Questions Seminar 1 answered. Once the recordings are published, I will tell you via the blog of course as well.
Thanks again also to Laura Garcia Villareal from Oracle University. If you have more questions regarding …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...
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...
In the past I wrote some articles about cloning PDBs to new environments. And I added a post about RELOCATE as well. But I realized that I have no specific blog post about a very typical scenario: Upgrade Testing – Online Clone a PDB to 19c.
I have an Oracle 22.214.171.124 CDB with a PDB, and another Oracle 19.6.0 CDB. I will hot clone the PDB from 126.96.36.199 to the higher version CDB, and then upgrade the PDB.
The motivation to do it this way is to allow testing for the application …Continue reading...
From time to time I get questions regarding the certification of Oracle Fail Safe. And just the other day, a customer asked: Is Oracle Fail Safe 4.2.1 certified with Oracle Database 19c? I briefly browsed my blog posts about Oracle Fail Safe from the past, and even though I mentioned that the certification for 4.2.1 on Oracle 188.8.131.52 may apply to later versions, I never updated it.
Is Oracle Fail Safe 4.2.1 certified with Oracle Database 19c?
Yes, it is. But you may want to know where you can read and find this information.
The latest version of Oracle Fail …Continue reading...
We are running the AutoUpgrade-for-RAC beta test since last week. And the first issue one customer encountered … is neither an AutoUpgrade nor a RAC issue. It has to do with APEX and SPATIAL, and missing grants. APEX is invalid after upgrading to 12.2 – ORA-20001
What is happening?
You are doing an upgrade to Oracle Database 184.108.40.206. And you receive a number of errors during the component validation phase.
19:04:14 SQL> EXECUTE dbms_registry_sys.validate_components; ...(19:04:15) Starting validate_apex for APEX_180100 ORA-20001: MISSING GRANT: grant execute on "MDSYS"."SDO_DIM_ARRAY" to APEX_180100 ORA-20001: MISSING GRANT: grant execute on… Continue reading...
This topic is included in our Multitenant slides for a long time. But whenever I want to point somebody to the blog post, I realize that it’s not on the blog yet. Actually I discussed this topic recently during a customer visit again. It’s time to put it on the blog. When you use Oracle Multitenant: Be aware of the silent COMPATIBLE change.
Mixed version environments
When you work with Oracle Multitenant, the sooner or later you will have mixed version environments. This may be CDBs with Oracle 220.127.116.11 or Oracle 18.104.22.168 together with …Continue reading...
Wow, this took a long while. Thanks to my team mate, Data Pump Product Manager Bill Beauregard who went through the complex approval process, the new Oracle 19c Hands-On Lab is available now for download. And in addition, I adjusted the instructions on the blog as well.
What you’ll get …
At first, the download is huge. All together, you will download 13 files summing up to 25GB. When you unzip it, you will get an OVA file. Then you will need to import this appliance into Oracle VirtualBox. The lab will …Continue reading...
Since last year we organize regional Oracle Open World conferences. Not as big as the one in San Francisco (or in Las Vegas this and the following years), but still an exciting event. And for me, it will be the first time in a week to attend and speak at OOW London. Let me give you a very quick overview on our OOW London 2020 – Upgrade Talk and more.
Upgrade Best Practices – Thursday, Feb 13 – 13:50-14:25h – Arena B – Zone 2
No idea who has cut down the tech …Continue reading...
Today Roy and I received a question from a colleague about the RELOCATE feature in Multitenant. And I’d like to shed some light and this topic a bit more. Upgrade PDBs with RELOCATE – How does it work?
RELOCATE and UPGRADE?
At first, it looks very promising to me. RELOCATE uses the HOT CLONE functionality of Multitenant but then relocates the PDB from one to another CDB. You need to fulfill a few important requirements, for instance:
- Local Undo must be enabled in both CDBs
- This limits the technique to at least Oracle
Internally we can use a Gold Image service at Oracle. I can download a zip with 19.6.0 included. But externally for you as customers, the download of 19.6.0 required that you download 19.3.0 at first, then apply 19.6.0 on top of it. But a day ago, a tweet by my Belgium friend Philippe Fierens caught my attention. Do we offer patched Gold Images already?
What is a Gold Image?
Since Oracle 18c, the installation routine has changed to the better. You download zip file containing the Gold Image, you create a directory and …Continue reading...
All of you upgrading your databases with AutoUpgrade or planning to do so can now download the newest version of our AutoUpgrade tool. We are offering the 20191220 version. If you ask yourself why we release the December version in January 2020, there’s a simple answer. We do extensive system testing with it before releasing it to the public.
Download 20191220 AutoUpgrade
You can always download the newest and some previous versions of the AutoUpgrade tool via this note:
At the bottom of the …Continue reading...
The year is almost over and many of you will take off in your well-deserved holidays. At this point it’s not time yet for a 2019 summary or my “Best Records of 2019” list, but to highlight a great success story from Swiss Mobiliar Insurance’s Oracle team.
Mobiliar Insurance – never heard about them?
There are actually two typical situations when you’ve never heard about Mobiliar Insurance (“Die Mobiliar“) before. You either don’t live in Switzerland and you never visited one of our workshops nor any of the talks Alain Fuhrer and …Continue reading...
These are good new in case you plan to use Oracle Database 22.214.171.124 longer in production. Just last week we extended the Extended Support for Oracle Database 126.96.36.199 by one additional year.
Extended Support Extension for Oracle 188.8.131.52
Before, the Extended Support for Oracle 184.108.40.206 ended end of July 2021. Now you can purchase it until end of July 2022. For those of you who have it included in your contract anyway (for instance if you have a ULA or PULA), these are great news.
Please see:Continue reading...
This is a short “Black Friday” blog post. And just if you are tired already of hunting supposed-to-be-bargain-buys, you may need something to relax – and watch this Video: Best Practices to Upgrade to Oracle Database 19c.
Roy recorded it as part of the Quest Experience Week. We’d like to share it with you here.
Just click on the picture below to open a new TAB and watch the 1 hour video:
If you are looking for the slide deck, you can download them from:
Our intention with the AutoUpgrade as the single tool to upgrade your databases was initially: You have one big config file for your databases. And you will use this file to upgrade your databases unattended. Ideally you run an “
analyze” at first, then you schedule a “
deploy” for overnight or the next weekend or whenever it is convenient for you. But sometimes people have different needs. In this particular case several people asked whether you can run multiple AutoUpgrade tools in parallel on the same server. Hence, I’d like to explain the first of more AutoUpgrade …
Monday morning – it’s time to write a new blog post. And actually I will set priorities based on what you reported to me in the past week. This way it may prevent others from hitting the same pitfall. The AutoUpgrade may fail when patch
ID column is
What is happening?
You start a database upgrade with autoupgrade. But the initial check will fail with a message like this:
AutoUpgrade tool launched with default options There was an error initializing the patching information for entry upg2
The AutoUpgrade won’t kick …Continue reading...
Nürnberg and München are just 175 km away from each other, a bit more than 1 hour by train. Still I felt a post-conference blues already when I boarded the ICE train yesterday to head back to the south. It was an awesome conference – again. Except for one thing which I will write about below. So here’s my report on DOAG 2019 – Recap and a personal complaint.
DOAG 2019 – What an agenda
I knew it before already. But my VP, Roy Swonger, visited DOAG Conference in Nürnberg for the first time. …Continue reading...
Please apologize that it took me a bit longer to upload a new version of our comprehensive slide deck. You can download now a new version of “Upgrade / Migrate / Consolidate to Oracle 19c” via the blog’s download page.
Why is there a new version?
Since Oracle Open World 2019 we have a new corporate template. And while I like the graphics quite a bit, I’d say, the people who built it have a good sense for graphics. But they aren’t powerpoint experts. In fact, almost every slide had to be adjusted. This may not be a huge …Continue reading...
I wanted to put this on the blog for quite a while but forgot to do so. Since Oracle Database 19c, Oracle Fail Safe has been deprecated. What does this mean?
Deprecation of Oracle Fail Safe
First of all, deprecated does not mean desupported. Oracle Fail Safe is still fully supported. But since Oracle 19c, you will find this note in the Windows Admin Guide:
Oracle Fail Safe is deprecated as of Oracle Database 19c. It can be desupported and unavailable in