This page describes SETUP steps for the new Oracle 18c Database Upgrade Hands-On Lab.
- Setup Information
- Inside the lab
- Space requirements: 64GB hard disk space
- Memory requirements: 8GB RAM minimum
- CPU requirements: Dual-core CPU
The lab is configured to request 6GB of RAM when it starts up. You can adjust this with the
SETTINGS for the lab of Virtual Box:
Login with username:
If you need to change the keyboard settings (preconfigured is
English-US (default) and
German) please do the following.
On the Linux desktop, click on “SYSTEM”, choose “PREFERENCES”, then “KEYBOARD”. In the “KEYBOARD PREFERNCES” option window choose the 2nd tab “LAYOUTS” and click on “ADD”. Then choose your desired keyboard.
You can then always switch the current keyboard layout by clicking on the “
en” characters in the menu bar. As the default is set to “
English-US" you may change the default as otherwise every xterm will always open with English keyboard settings at first. You can always alter the keyboard on the fly. There’s no need to open a new xterm to change the setting temporarily for this xterm.
All passwords are set to: oracle
This applies to the OS user
oracle as well as to the database accounts for
You can switch between the different environments by typing:
From the picture below you can see the available environments and the shortcuts to switch between any of them.
If you need to alter these files or create new ones, find them in
/usr/local/bin/ and alter them with
There is an additional environment variable
$OH18 defined for convenience. This points to the 18c Oracle Home, and will be used several times in the lab.
This is what you’ll find inside the hands-on lab virtual image. Click on the picture to get a larger view.
- Oracle 22.214.171.124 –
- Oracle 126.96.36.199 –
- Oracle 18.1.0 –
The lab contains also 5 different databases:
UPGR– 188.8.131.52 database (non-CDB)
FTEX– 184.108.40.206 database (non-CDB)
DB12– 220.127.116.11 database (non-CDB)
CDB1– 18.104.22.168 database (CDB)
CDB2– 18,1.0 database (CDB)
This is VERY IMPORTANT for the entire lab.
This color means: Execute on the OS level in an xterm:
This color means: Execute in SQL*Plus:
This way you can copy&paste from the instructions if necessary without having trouble with prompts.