vagrant-vbox-rac

Vagrant setup to install one or more Oracle RAC clusters

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

Getting started

Pre-requisites:

• Vagrant
• Virtualbox

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

cd vagrant-vbox-rac

Update the submodules:

./update-repo.sh

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 (or use RHEL), change the parameter box: oravirt/ol75 to one of the following:

• oravirt/ol74
• oravirt/ol73
• oravirt/ol72
• oravirt/ol69
• oravirt/ol68
• oravirt/ol67
• oravirt/ol65
• oravirt/rhel75
• oravirt/rhel610

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.5
• create a 18.3 container database called 'orclcdb'
• create a pdb called 'orclpdb'
• sys/system passwords are Oracle_123
• The diskgroups are called crs, data & fra and uses asmlib for device naming persistency.

NOTE: The default config will consume ~74GB of storage. 40GB of this is to accomodate the GIMR database in 18.3. 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

Modifying the Oracle installation, GI (Ansible style)

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:

• 18.3.0.0
• 12.2.0.1
• 12.1.0.2
• 12.1.0.1
• 11.2.0.4
• 11.2.0.3

Modifying the Oracle installation, DB (Ansible style)

• THIS SECTION NEEDS TO BE RE-WRITTEN AS IT IS NO LONGER CORRECT. USE ENVIRONMENT VARIABLES FOR NOW.

Modifying the Oracle installation (using environment variables)

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.2.0.1 dbver=12.1.0.2 dbtype=RAC dbstorage=ASM vagrant up

Logging in to the VM(s)

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.

Install more than 1 cluster

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)

These are the Oracle binaries that should be used.

For 18.3.0.0:

    LINUX.X64_180000_db_home.zip
    LINUX.X64_180000_grid_home.zip

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