Oracle Database 18c (18.3.0) Upgrade and Migration hands-on Lab

Updated! 26-SEP-2018

SYSTEM REQUIREMENTS:

This hands-on lab runs in an Oracle VM VirtualBox environment. In order to run the lab effectively you will need the following.

Minimum Hardware:
  • CPU: Dual-core CPU
  • Memory: 8+ GB RAM
  • Disk space:
    • 25 GB for download of zip files
    • 75GB 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 5.0.10 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

You must accept the OTN License Agreement to download this software.
Accept License Agreement | Decline License Agreement
  1. Review the hands-on lab instructions them to understand what is included in the larger zip file download.
    • Navigate to www.mikedietrichDE.com
    • Select the instruction modules under the Hands-on Lab tab
  2. Download the VM image zip files. There are a total of 9 files:

    DownloadOracle_Upgrade_HOL_18c.ova.7z.001 (2,000,000,000 bytes)
    DownloadOracle_Upgrade_HOL_18c.ova.7z.002 (2,000,000,000 bytes)
    DownloadOracle_Upgrade_HOL_18c.ova.7z.003 (2,000,000,000 bytes)
    DownloadOracle_Upgrade_HOL_18c.ova.7z.004 (2,000,000,000 bytes)
    DownloadOracle_Upgrade_HOL_18c.ova.7z.005 (2,000,000,000 bytes)
    DownloadOracle_Upgrade_HOL_18c.ova.7z.006 (2,000,000,000 bytes)
    DownloadOracle_Upgrade_HOL_18c.ova.7z.007 (2,000,000,000 bytes)
    DownloadOracle_Upgrade_HOL_18c.ova.7z.008 (2,000,000,000 bytes)
    DownloadOracle_Upgrade_HOL_18c.ova.7z.009 (2,000,000,000 bytes)
    DownloadOracle_Upgrade_HOL_18c.ova.7z.010 (2,000,000,000 bytes)
    DownloadOracle_Upgrade_HOL_18c.ova.7z.011 (2,000,000,000 bytes)
    DownloadOracle_Upgrade_HOL_18c.ova.7z.012 (837,117,665 bytes)
  1. 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 (Upgrade-HOL.md5) 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.

     

    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: I recommend 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 20GB 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.

  2. Import the Oracle_Upgrade_HOL_18c.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 52GB of disk space. You may delete the .ova file once the import completes.
  3. 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.