vagrant-vbox-si-asm

Vagrant setup to install an Oracle single instance database on ASM.

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-si-asm.git

cd vagrant-vbox-si-asm

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 a VM 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 udev for device naming persistency.

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 (Ansible style)

If you want to install a different version of GI , edit the extra-provision/ansible-oracle/group_vars/vbox-si-asm 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-si-asm 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.

Adding more ORACLE_HOMES, or databases to an existing home

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-si-asm.

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.

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 e.g: setup=true giver=12.1.0.2 dbver=12.1.0.2 vagrant up

Logging in to the VM

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

• run vagrant ssh from within the directory, then sudo to oracle/root
• ssh to VM using the ssh binary of your choice, i.e: ssh 192.168.9.62 -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.

These are the Oracle binaries that should be used.

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