Oracle Database 19c (19.9.0) Upgrade and Migration hands-on Lab

Updated! 28-Jan-2021

SYSTEM REQUIREMENTS:

This hands-on lab runs in an Oracle VM VirtualBox environment. VirtualBox 6.1 is the minimum recommended Version.

In order to run the lab effectively you will need the following.

Minimum Hardware:

  • CPU: Dual-core CPU
  • Memory: 8+ GB RAM
  • Disk space:
    • 36.95 GB for download of zip files
    • 85.24 GB for expanded VM image
  • NOTE: If your hardware is near the minimums, you will need to adjust the virtual machine settings inside VirtualBox. See below.

Required Software:

  • Any 64-bit OS on which Oracle VirtualBox is available
  • Oracle VM VirtualBox 6.1 or later. Download the latest version from http://www.virtualbox.org
  • Also include the VirtualBox Extensions package. This is a separate download from the same location

INSTALLATION

Review the hands-on lab instructions to understand what is included in the larger zip file download.

Download the VM image zip files. There are a total of 4 files:

Download
Oracle Database Upgrade and Migration - Hands-on Lab 19.9.0

This is a multi-part zip archive. The method for expanding this depends on your operating system. Note that some older zip utilities cannot deal with files larger than 2GB. And, sometimes zip will have a problem (it can be used to unzip as well) while unzip works just fine. If you have a problem unzipping the file, please use a more modern utility.

Note that an MD5 Checksum file (md5.lis) has been provided so that you can verify your downloaded files. Please use this to verify that none of the files was corrupted by network gremlins during the download process. These instructions can also be downloaded as Upgrade_HOL_README.

Windows: use 7-zip to open the first file in the archive. This should automatically expand the archive for you.

Linux: bring up your file manager and double-click on the first file. This should start the archive utility for your desktop environment, such as File Roller if you use Gnome.

Mac OS X: A good option is The Unarchiver, a free utility in the Mac App Store. The latest Stuffit Expander seems to have issues with multipart zip archives.

Unzip this zip file into the location where you want the virtual machine to reside on disk. The resulting VirtualBox Appliance (.ova) file will consume approximately 21GB of disk space. The next step will be to import this appliance into VirtualBox. You may want to delete the zip files to save disk space.

  1. Import the HOL19c-2020oct.ova appliance using the VirtualBox application. This option should be under File -> Import Appliance... You will need to accept the license before importing. The resulting VM will consume another 85.24 GB of disk space. You may delete the .ova file once the import completes.
  2. BEFORE STARTING THE VIRTUAL MACHINE: use the VirtualBox Settings -> System panel to adjust the number of CPUs and amount of RAM dedicated to the VM. There is a slider for each of these settings.

Suggested settings:

Motherboard -> Base Memory: 8192 MB RAM

Processor: 2+ CPUs

Make sure that the value is not in the red area of the slider for CPUs or Memory.

You may also want to disable the USB port, as this is not needed for the lab.

STARTUP:

The lab will start at the Linux login screen. Login with a username of 'oracle' and a password of 'oracle'.

All passwords in the VM environment are 'oracle'. This is true for OS users such as root, and for Oracle users such as sys or system.

It is a good idea to take a snapshot after your initial login to the desktop. This will allow you to easily reset the VM and start over if desired.