This project provides Oracle Database support on top of rails-dev-box.

• VirtualBox

• Vagrant 1.1+

• VirtualBox needs support for 64-bit guests

Building the virtual machine is this easy:

• Download Oracle Database 11g Express Edition for Linux x64. The file name is oracle-xe-11.2.0-1.0.x86_64.rpm.zip.

    host $ git clone https://github.com/yahonda/rails-dev-box-runs-oracle.git
    host $ cp oracle-xe-11.2.0-1.0.x86_64.rpm.zip rails-dev-box-runs-oracle/puppet/modules/oracle/files/.
    host $ cd rails-dev-box-runs-oracle
    host $ vagrant up

That's it.

After the installation has finished, you can access the virtual machine with:

    host $ vagrant ssh
    Welcome to Ubuntu 12.04 LTS (GNU/Linux 3.2.0-23-generic x86_64)
    ...
    vagrant@rails-dev-box:~$ sqlplus system/manager@localhost/XE

Port 3000 in the host computer is forwarded to port 3000 in the virtual machine. Thus, applications running in the virtual machine can be accessed via localhost:3000 in the host computer.

Similarly, Oracle's default network listener port 1521 in the host computer is forwarded to port 1521 in the virtual machine. Oracle tools in the host computer can connect to the database in the virtual machine:

    host $ sqlplus system/manager@localhost/XE

• Everthing in rails-dev-box

• Oracle Database 11g Express Edition

Just clone your Rails fork in the very directory of the Rails development box in the host computer:

host $ ls
README.md   Vagrantfile puppet
host $ git clone https://github.com/rails/rails.git

Vagrant mounts that very directory as /vagrant within the virtual machine:

vagrant@rails-dev-box:~$ ls /vagrant
puppet  rails  README.md  Vagrantfile

Clone the oracle-enhanced repository as you do Rails.

host $ ls
README.md   Vagrantfile puppet rails

host $ git clone https://github.com/rsim/oracle-enhanced.git

host $ ls
oracle-enhanced README.md   Vagrantfile puppet rails

Just execute as described steps below.

vagrant@rails-dev-box:$ cd /vagrant
vagrant@rails-dev-box:$ cd /vagrant/oracle-enhanced
vagrant@rails-dev-box:$ bundle
vagrant@rails-dev-box:$ rake spec

If your host is behind a firewall and 'vagrant up' gets errors running apt-get or installing RVM, then create ~/.vagrant.d/Vagrantfile to update the virtual machine's proxy settings:

    # ~/.vagrant.d/Vagrantfile
    Vagrant.configure('2') do |config|
      config.vm.provision :shell, :inline => "echo 'Acquire::http::proxy \"http://proxy.example.com:80/\";' >> /etc/apt/apt.conf"
      config.vm.provision :shell, :inline => "echo 'Acquire::https::proxy \"http://proxy.example.com:80/\";' >> /etc/apt/apt.conf"
      config.vm.provision :shell, :inline => "echo 'export http_proxy=http://proxy.example.com:80/' > /etc/profile.d/vagrant_proxy.sh"
      config.vm.provision :shell, :inline => "echo 'export https_proxy=http://proxy.example.com:80/' >> /etc/profile.d/vagrant_proxy.sh"
    end

Change the proxy name and port to be your network's proxy.

This project is based on rails-dev-box and vagrant-ubuntu-oracle-xe.

Thanks to everyone who contributes to these projects.

Please email me [email protected]