Oracle XE 11g on Ubuntu 12.04 using Vagrant

This project enables you to install Oracle 11g XE in a virtual machine running Ubuntu 12.04, using Vagrant and Puppet.

Acknowledgements

This project was created based on the information in Installing Oracle 11g R2 Express Edition on Ubuntu 64-bit by Manish Raj, and the GitHub repository vagrant-oracle-xe by Stefan Glase. The former explains how to install Oracle XE 11g on Ubuntu 12.04, without explicitly providing a Vagrant or provisioner configuration. The latter has the same purpose as this project but uses Ubuntu 11.10.

Requirements

• You need to have Vagrant installed.
• The host machine probably needs at least 4 GB of RAM (I have only tested 8 GB of RAM).
• As Oracle 11g XE is only available for 64-bit machines at the moment, the host machine needs to have a 64-bit architecture.
• I have tested this project on a host machine running Ubuntu 12.04, but other operating systems should also work, as long as they can run Vagrant.

Installation

• Check out this project:

    git clone git://github.com/buckett/vagrant-ubuntu-oracle-xe
  

• Download Oracle Database 11g Express Edition for Linux x64. Place the file oracle-xe-11.2.0-1.0.x86_64.rpm.zip in the directory modules/oracle/files of this project.

• Run vagrant up from the base directory of this project. This should take a few minutes.

You should now be able to connect to the new database at localhost:1521/xe as system with password manager. For example, if you have sqlplus installed on the host machine you can do

sqlplus system/manager@//localhost:1521/xe

Troubleshooting

It is important to assign enough memory to the virtual machine, otherwise you will get an error

ORA-00845: MEMORY_TARGET not supported on this system

during the configuration stage. In the Vagrantfile 512MB MB is assigned. Lower values may also work, as long as (I believe) 2 GB of virtual memory is available for Oracle, swap is included in this calculation.