I created this blog last year so I could write down the steps taken to create an Oracle Education classroom environment using Oracle VirtualBox. I teach Oracle Education classes for Austin Community College (ACC) and also for RFD & Associates, Inc. under a program called the Workforce Development Program. You can see my previous blog post for a description of the Workforce Development Program. Tomorrow I’m teaching a class at ACC to do all of the below with my students from the DBA I and DBA II courses plus a special guest, so I thought it was finally time to start getting this all down.
There are a number of steps to create the classroom environment. Over the next few weeks I intend to write a post for each of the steps. As each post is written, I’ll update each step in the list below to point to those posts.
Here’s the steps that I took to create the classroom environment:
- Download and install Oracle VirtualBox including the Extension Pack.
- Download the Oracle Linux ISO from edelivery.oracle.com/linux.
- Create a virtual machine running Oracle Linux.
- Create a local yum repository from the DVD content and add asmlib downloaded from linux.oracle.com.
While you could just use an online repository instead of a local repository, the local repository allows you to install RPMs even if you are not connected to a network. I find this is nice from time to time, and we are more worried about the Oracle Database than we are about having the most up to date Linux environment.
- Install asmlib, asmsupport, and the oracle-validated RPMs and create the required directories including a stage directories for Oracle Grid Infrastructure and Oracle Database.
We’re also going to make the Linux User IDs and Group IDs match the training material.
- Install Oracle VirtualBox Guest Additions.
- Install rlwrap.
Optional, but oh so nice.
- Create the ASM disks and then configure and start ASM.
- Configure the Oracle user’s environment including a really nice login.sql script.
- Download Oracle Grid Infrastructure and Oracle Database 11g R2.
- Install Oracle Grid Infrastructure and create a +FRA (Fast Recovery Area) disk group in addition to the +DATA disk group.
- Install the Oracle Database software.
- Use the Database Creation Assistant to create a Database instance.
If you follow the above steps, you’ll have a training environment that matches the Oracle training material for the majority of the Oracle Database Administrator training classes (but not all, for instance the Real Application Clusters or RAC class is obviously a bit different).