HOL 18c Setup

This page describes SETUP steps for the new Oracle 18c 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 6GB of RAM when it starts up. You can adjust this with the SETTINGS for the lab of Virtual Box:

 

Login with username: oracle
and password: oracle

Keyboard layout and preferences

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

HOL 18c Setup  ==> HOL 18c Setup

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.

HOL 18c Setup

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 $OH18 defined for convenience. This points to the 18c 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. Click on the picture to get a larger view.

HOL 18c SetupIt contains 3 different Oracle Homes:

  • Oracle 11.2.0.4 – /u01/app/oracle/product/11.2.0.4
  • Oracle 12.1.0.2 – /u01/app/oracle/product/12.1.0.2
  • Oracle 18.1.0 – /u01/app/oracle/product/18

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.1.0.2 database (non-CDB)
  • CDB1 – 12.1.0.2 database (CDB)
  • CDB2 – 18,1.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.


==> NEXT: Generate Application Load