HOL 19c Setup

« PREVIOUS «
MAIN INDEX 19C HOL » GENERATE LOAD »

This page describes SETUP steps for the new Oracle 19c Database Upgrade Hands-On Lab.

Index

Setup Information

Space and memory requirements – and login

  • Space requirements: 64GB hard disk space
  • Memory requirements: 8GB RAM minimum
  • CPU requirements: Dual-core CPU

The lab is configured to request 8GB of RAM when it starts up. You can adjust this with the SETTINGS for the lab of Virtual Box before startup:

Click on the “oracle” user tab on the login screen and type in the password: oracle

VERY IMPORTANT:

If the login screen does not appear but instead you get a BLACK screen after the reboot process, then please check this link here:

In the cases we encountered during the first run of the labs, two people struggled with it. The:
WaylandEnable=false
parameter brought the solution. I set this for the downloadable image already but people who get the lab via a USB drive in the early stages may miss this setting.

Keyboard layout and preferences

If you need to change the keyboard settings (preconfigured is English-US (default) and German) please do the following:

1.
2.
3.

On the Linux desktop, click on the PENGUIN icon in the left upper corner, then choose “SYSTEM SETTINGS”, then under HARDWARE: “INPUT DEVICES”. The first item is “KEYBOARD”. Choose the “LAYOUT” tab, then click on “CONFIGURE LAYOUTS” and “ADD” the keyboard you’d want to add.

You can then always switch the current keyboard layout by clicking on the “en” (or “de“) 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.

Inside the lab

Username and Passwords

All passwords are set to: oracle

This applies to the OS user root and oracle as well as to the database accounts for SYS and SYSTEM.

Switching environments

You can switch between the different environments by typing: . upgr
This reads: dot <space/blank> upgr

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 root privileges.

There is an additional environment variable $OH19 defined for convenience. This points to the 19c Oracle Home, and will be used several times in the lab.

HOL overview picture

This is what you’ll find inside the hands-on lab virtual image.

It contains 3 different Oracle Homes:

  • Oracle 11.2.0.4 – /u01/app/oracle/product/11.2.0.4
  • Oracle 12.2.0.1 – /u01/app/oracle/product/12.2.0.1
  • Oracle 19.3.0 – /u01/app/oracle/product/19

The lab contains also 5 different databases:

  • UPGR – 11.2.0.4 database (non-CDB)
  • FTEX – 11.2.0.4 database (non-CDB)
  • DB12 – 12.2.0.1 database (non-CDB)
  • CDB1 – 12.2.0.1 database (CDB)
  • CDB2 – 19.3.0 database (CDB)

Notation conventions

This is VERY IMPORTANT for the entire lab.

This color means: Execute on the OS level in an xterm:

. upgr18
sqlplus / as sysdba

This color means: Execute in SQL*Plus:

shutdown immediate
startup open read only;

This way you can copy&paste from the instructions if necessary without having trouble with prompts.


« PREVIOUS «
MAIN INDEX 19C HOL » GENERATE LOAD »
Share this: