Setup a VirtualBox based Database Lab Environment

Oracle provides a lot of useful Oracle VirtualBox Pre-built Appliances.

In this blog post, I will describe the few extra steps I take after download in order to setup my lab environment on my work MacBook Pro.

  1. First step is download
  2. Secondly, I import the .ova file in Virtual Box
  3. Start the newly created VM and upgrade the Guest additions (this is described int he Oracle VirtualBox documentation)
  4. Check the Guest OS’s IP by issuing the command ifconfig -a
  5. Shutdown the VM
  6. In VirtualBox, select the VM, click Settings, Network, Adapter 1 (choose the one that is attached to NAT, if there is use of the adapter to attach a NAT):
  1. Click port forwarding and ensure that, at least the net8 and ssh port forwarding settings are set as in the picture:
  1. Go to ‘Shared folders’ and add the Mac’s home directory (in my case, it is /Users/radu.parvu) and check the box ‘Auto-mount’
  2. Go to ‘Display’ and set the Graphics Controller as VMSVGA. Do not enable 3D Acceleration
  3. Save the settings and start the VM
  4. In the shell on the host OS, ssh into the guest: ssh -p 2222 oracle@localhost
  5. In the host, start the Oracle SQL Developer
  6. Setup the connection to the container:
  1. Setup the connection to the pluggable database:

Steps tested with: VirtualBox Version 6.1.16 r140961 (Qt5.6.3)

Leave a Reply