This article will cover the following topics:
- Downloading, Installing & Running the Oracle 11G Virtual Machine.
- Starting up Oracle 11G and launching Enterprise Manager.
- Logging in with SQL Developer 3.1 EA.
- Working with the Demo SCHEMA.
Note: I’m working on an IBM Thinkpad with Windows XP SP2 running at 1.6GHZ with 3.0GB of RAM. The VM is running on RedHat Linux.
Downloading, Installing & Running the Oracle 11G Virtual Machine.
Step 1: You will want to download Oracle VM VirtualBox from here (avaliable for Windows/Mac/Solaris/Linux): Oracle VM VirtualBox Download.
If you don’t have an Oracle account you will have to create one for free.
Once the download is complete continue with the installation process. I used the default installation options throughout the install. Once the instillation is complete run the application and you should see a screen similar to this:
Step 2: Next you will need to download the Virtual Image (Oracle Developer Day.ova) from here: Oracle Developer Day.ova
Step 3: Once the download is complete, we are ready to launch the VM.
- Using VM VirtualBox import your VM: File -> Import Appliance to launch Appliance Import Wizard.
- Click Choose… browse to the which contains Oracle Developer Days.ova (select the file) then click Next> to begin importing the virtual machine.
Step 4: Now we can launch the Oracle Dev Virtual Machine. Double-click the OTN Developer Days VM. Click OK to close the Virtualbox Information dialogs. The VM will launch and boot into RedHat Enterprise Linux 5 (this will take few minutes), once booted in you can login using the following credentials:
User Name: oracle
Starting up Oracle 11G and launching Enterprise Manager.
Now that the Oracle VM is up and running we can start Oracle and login to the Enterprise Manager. In order to stat Oracle simply type “emctl start dbconsole” into the console which appeared on your desktop when you logged into GNOME and hit enter. This will launch Oracle Enterprise Manager 11G. It took a few minutes to bootup for me, but once it is booted up you can log-in by going to the folling URL in your VM’s web browser:
User name: system
Connect As: SYSDBA
Logging in with SQL Developer 3.1 EA
The VM comes with oracle SQL Developer EA (the icon is on the desktop). I’ve been using SQL Developer for a while now and find it just as powerful as TOAD or any of the other mainstream Database IDE’s.
You can launch SQL Developer and login to the System account, you should see Auto-Generated Local Connections in the Connections pane on the left. Expand the Auto-Generated Local Connections branch, this will allow you to login to the system-oracle account (password: oracle).
Once connected to system-oracle, right click on system-oracle and select Scheme Browser, this will allow you to select the Demo schema which I will be referring to in other articles related to Oracle and PL/SQL.
At this point you should have everything you need to start learning and experimenting with Oracle and PL/SQL in a consolidated Virtual Machine Environment!