Vagrant setup to install one or more Oracle RAC clusters

The provisioning step of this vagrant solution is: https://github.com/oravirt/ansible-oracle

Pre-requisites:

• Vagrant
• Virtualbox

Clone this repository: git clone --recursive https://github.com/oravirt/vagrant-vbox-rac.git

cd vagrant-vbox-rac

Edit the hosts.yml file if you want to change the ip, number of cpu's, amount of RAM etc.

If you want to use a different version or Oracle Linux, change the parameter box: oravirt/ol73 to one of the following:

• oravirt/ol74
• oravirt/ol72
• oravirt/ol68
• oravirt/ol67
• oravirt/ol65

These boxes are prepared with all Oracle pre-req packages installed

Download the Oracle binaries (see below) and place them in the swrepo directory. Alternatively, if you already have a directory where all Oracle binaries are located, change the synced_folders: src to point to your local directory (/Users/xxx/Downloads/oracle)

And then: setup=true vagrant up

This will (by default):

• create 2 VM's based on Oracle Linux 7.3
• create a 12.2 container database called 'orclcdb'
• create a pdb called 'orclpdb'
• sys/system passwords are Oracle123
• The diskgroups are called crs, data & fra and uses asmlib for device naming persistency.

NOTE: The default config will consume ~60GB of storage. 40GB of this is to accomodate the GIMR database in 12.2. If you want to install a different version, you can just change the size of the crs disk in hosts.yml to something smaller

If you just want to create the machine, and not run the provisioning step run this:

vagrant up

For more detail on how the vagrant part of this project works, look at this

If you want to install a different version of GI , edit the extra-provision/ansible-oracle/group_vars/vbox-rac-dc1/2 file and change the parameter oracle_install_version_gi to either of:

• 12.2.0.1
• 12.1.0.2
• 12.1.0.1
• 11.2.0.4
• 11.2.0.3

If you want to install a different version of the database , edit the extra-provision/ansible-oracle/group_vars/vbox-rac-dc1/2 file and change the following:

Under oracle_databases, change the parameter oracle_version_db: to one of the following:

• 12.2.0.1
• 12.1.0.2
• 12.1.0.1
• 11.2.0.4
• 11.2.0.3

If you want to change other parameters they're all under oracle_databases.

If you want to install more than 1 ORACLE_HOME (using different version etc), just uncomment the part that is commented in extra-provision/ansible-oracle/group_vars/vbox-rac-dc1/2.

It is also possible to add more homes & databases than those already configured.

After you've done the changes, run vagrant provision again, and it will install the new home and/or create the database.

You have the possibility to override some of the defaults using environment variables, as described in more detail here.

But it is basically a simple matter of setting provisioning_env_override: true in hosts.yml, and then e.g:

setup=true giver=12.1.0.2 dbver=12.1.0.2 dbtype=RAC dbstorage=ASM vagrant up

To log on to the VM (ssh), you have the following options:

• run vagrant ssh <vmname> from within the directory, then sudo to oracle/root
• ssh to VM using the ssh binary of your choice, i.e: ssh 192.168.7.10 -l oracle (vagrant/vagrant, oracle/oracle, root/root). The oracle user also have sudo rights

For each database created there is a /home/oracle/.profile_<dbname> created which have all the environment variables set up for this particular database.

To install more than 1 cluster, just comment out the commented part in hosts.yml (called vbox-rac-dc2). Since the Vagrant provisioner works on 1 hostgroup at the time, it will first create the vbox-rac-dc1 cluster, and then move on the vbox-rac-dc2. This will take ~2H

It is possible to just create the machines (just vagrant up) and then run Ansible as a separate step manually. Doing it this way cut the runtime down to ~80min (on the same hardware)

For 12.2.0.1:

    linuxx64_12201_database.zip
    linuxx64_12201_grid_home.zip

For 12.1.0.2

    linuxamd64_12102_database_1of2.zip
    linuxamd64_12102_database_2of2.zip
    linuxamd64_12102_grid_1of2.zip
    linuxamd64_12102_grid_2of2.zip

For 12.1.0.1:

    linuxamd64_12c_database_1of2.zip
    linuxamd64_12c_database_2of2.zip
    linuxamd64_12c_grid_1of2.zip
    linuxamd64_12c_grid_2of2.zip

For 11.2.0.4:

    p13390677_112040_Linux-x86-64_1of7.zip
    p13390677_112040_Linux-x86-64_2of7.zip
    p13390677_112040_Linux-x86-64_3of7.zip

For 11.2.0.3:

   p10404530_112030_Linux-x86-64_1of7.zip
   p10404530_112030_Linux-x86-64_2of7.zip
   p10404530_112030_Linux-x86-64_3of7.zip