ThatJeffSmith

Introducing the OTN Developer Day Database 12c VirtualBox Image

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:

Everything you need to get your 12c on! #FREE

Everything you need to get your 12c on! #FREE

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.

You'll point to the .OVA file you've just downloaded...

You’ll point to the .OVA file you’ve just downloaded…

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:

Have lots of memory? It's OK to be greedy...

Have lots of memory? It’s OK to be greedy…

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.

Read it!

Read it!

This will take a few minutes – or however fast you can write out those 2 huge files, ~= 12GB.

Windows lies, but it will take awhile.

Windows lies, but it will take awhile.

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.

Oracle Enterprise Linux 6 is booting up!

Oracle Enterprise Linux 6 is booting up!

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 :)

The DevDay 12c Developer Database Image Desktop for the oracle user

The DevDay 12c Developer Database Image Desktop for the oracle user

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.

Oh HR, how I have missed thee...

Oh HR, how I have missed thee…

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.

The container is ORCL, the pluggable is accessed via service 'PDB1'

The container is ORCL, the pluggable is accessed via service ‘PDB1′

Bonus Tips

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.