If you’re looking for an already configured Oracle Database 12c environment with a database already setup and all the software you need to learn database programming, design, and administration concepts, then look no further:
This Stuff is all FREE
The virtualization software is VirtualBox – that’s free. And it runs on any OS, including Windows, Macs, and *NIX. You’ll need to go download and install that first.
Are you ready to get started? Awesome. Then start up VirtualBox. You’ll get the Oracle VM VirtualBox Manager up and running. You’ll want to IMPORT an appliance.
We’ve already built the appliance for you. And by ‘we’ I mean @krisrice – so go thank him.
It’s going to take you awhile to download – it’s about 5GB in size.
Once you have downloaded the file as referenced on this page – you’ll need to agree to the license/terms, and use your Oracle Single-Sign On account (also free!), then do the import and point to the .OVA.
Next you’ll be prompted to approve of the VM settings. There are two that I want you to take a look at before just saying ‘Yes’ to everything:
The image requires at least 1 GB of RAM to run. Remember, we’re running Oracle Database 12c, on a Linux image, plus you’ll be running a browser, and probably SQL Developer, or the Modeler, or APEX, or all of those. If you have it, bump the memory up to 2GB.
Also, the OS ‘disks’ are by default going to be sitting on your C: drive. Make sure that drive is ‘fast’, has contiguous blocks available (defrag first if necessary), and enough space. I’ve switched mine over to my D: partition.
Then click ‘Ok.’
Say ‘Yes’ to the License Agreement.
This will take a few minutes – or however fast you can write out those 2 huge files, ~= 12GB.
Start the VM!
Select the vm in the manager and hit the ‘Start’ button. You’ll know you’re good if you see this screen.
If you see this error…
“This kernel requires an x86-64 CPU, but only detected an i686 CPU.”
Your BIOS is going to need to be updated. You’ll want to enable the virtualization technology. There’s a good tutorial on how to do that here.
Now, back to the image…
Logon as oracle/oracle – this is the user that owns the install, the labs, and software.
Your desktop should come up, and will look a little something like this – without the annoying arrows and blocky words I added 🙂
Where to get started?
Well, you could click on the big penguin circle and launch the labs, pick one and follow the instructions. Or, you could fire up SQL Developer and start mucking around.
In either case, you MIGHT want to create a snapshot for the VM first – this will give you a backup of your image you can go back to in case you ever screw it up beyond repair. This would be faster probably than re-downloading the OVA file, importing it, etc.
For SQL Developer, you can create a connection to the CDB or the PDB. Yes, this is a Multitenant installation.
The CDB instance is ‘ORCL’ and the PDB instance is ‘PDB1’. To connect to the database with all the sample data, you’ll want to go in as HR or SYS to the PDB1 ‘service.’ PDBs are accessible via the service, not the SID.
If you want to clone a PDB, then you’ll need to create a SYS-level connection to the CDB and access the DBA – Container Database node.
If you have networking setup correctly, you’ll be able to connect to your database from your host machine – just figure out what your IP is first. You’ll want to confirm your machine can ‘see’ the VM on it’s network.
This can get…complicated…on Windows. Thankfully many people have written up nice dedicated blog posts on the subject. Eddie Awad has this one that seems pretty thorough.
If you’re lazy, can you can setup port forwarding such that talking to port 1521 on your host auto goes to port 1521 on the Linux image.