Vagrant enbles creating virtual machines easily, Puppet helps to setup Linux machine. In this example we will install Oracle database on Oracle Enterprise Linux Vagrant box using Puppet. Before we continue, Vagrant must be setup on your machine. There are a lot of tutorials on how to install Vagrant, one of the best is Vagrant official site. Also you need VirtualBox installed. Once you can see your Vagrant version (using vagrant --version
command) and VirtualBox installed you can continue with this tutorial.
So, in order to create new VM with Oracle database follow these steps:
Download and unzip file from here or clone it from my GitHub repo
https://github.com/paykin/vagrant-oracle-11g
to your hard disk.Download Oracle Database installation from Oracle downloads site. For this tutorial we need Oracle Database 11g Release 2 (11.2.0.1.0) for Linux 64bit (Linux x86-64). There are 2 files to download. You need to place them to
vagrant-oracle-11g/modules/oracle/files
directory. While it is downloading, proceed to next step.In
Vagrant
file you may set machine host name, amount of memoryIn
manifests/base.pp
you can set Oracle database parametersIn command line, go to directory you extracted attached file and write
vagrant up
.
That’s it. Installation will take a while, on my machine it too about 10 minutes. When it finishes, you can connect to the machine via SSH, issuing vagrant ssh
command. If you prefer using standard ssh, you can connect to it with ssh vagrant@localhost -p 2222
command. Vagrant default root password is vagrant
.
In order to validate that everything works, you can run sqlplus / as sysdba
and execute some simple query, say SELECT SYSDATE FROM dual
. If you see current date – everything works ok. Also you can connect using SqlDeveloper or any othe client.