New Oracle Database Upgrade Lab for Oracle 18.3.0
Our new and updated Oracle Database Upgrade Hands-On Lab for Oracle 18.3.0 is finally live and can be downloaded via this link:
Of course, Oracle 18.3.0 is inside to upgrade to. But we changed the entire instructions set a bit. We included a simple load generator. And we added way more performance stuff. And of course fallback. As soon as Oracle 18.4.0 becomes available, patching will be included in the instructions as well. Everybody should have used OPatch at least once 🙂
What’s in the lab?
You will find 3 database homes patched with the July 2018 patch bundles:
- 18.104.22.168 with PSU July 2018
- 22.214.171.124 with BP July 2018
- 18.3.0 including RU July 2018
Plus 5 databases. 3 non-CDBs and 2 CDBs.
UPGR– 126.96.36.199 non-CDB database
FTEX– 188.8.131.52 non-CDB database
DB12– 184.108.40.206 non-CDB database
CDB1– 220.127.116.11 CDB database
CDB2– 18.3.0 CDB database
This is what you’ll find inside the hands-on lab virtual image. Click on the picture to get a larger view.
What are the basic requirements?
Of course you will need Oracle VirtualBox 5.x and the VirtualBox extensions to be installed. And yes, the lab is BIG. You will need 64GB of free space and 8GB of RAM. See the download link for more information and the links to the required software. And then start here with the setup part.
What’s not in the lab?
We didn’t include the instructions. You will find them here on the blog. Simple reason for this change: We can correct potential errors – and we can extend them at any time with more content.
You can either start on this Main overview page or directly with Setup. Links to the next page are always on the button of each page.
Any further questions, suggestions etc?
Then please use the comment function of this page or drop me a message via Email, Twitter or LinkedIn.
Great lab! Easy to follow and probably the most clearly written lab procedures I have seen in a long time. The only problem I encountered was the Linux VM (VirtualBox VM) failed due to /u01 running out of space at the very last step in the lab.
you refer to the Fallback part, correct?
Please reset the lab to “start” and then do the fallback. Then you should not encounter space issues.
I will make this more clear in the instructions. “Fallback” should be seen as a separate, independent exercise.
Thanks Mike. I’ll check it out.
Mike, I checked my HOL work and mis-stated my problem location. My /u01 filled up (stopping the lab) toward the end of the Unplug – Plug lab session (the session just before Fallback).
then try to remove the FTEX database. Did you turn archivelog on?
Actually this does not happen when I run it. Hard to diagnose remotely.
@Tom Abazia Imported Virtual box starts with 2.4 G free space on root volume. However second volume has free space of 47G (directory /home was on second volume and /u01 was on root volume). I didn’t start any upgrades or exercises except starting and shutting down databases and pretty soon root volume(/u01 directory) was full and I was able to fix space shortage by shrinking second volume and extending root volume online without data loss.(thanks for google search)