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:
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/ol74oravirt/ol73oravirt/ol72oravirt/ol69oravirt/ol68oravirt/ol67oravirt/ol65oravirt/rhel75oravirt/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 & fraand usesasmlibfor 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
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.012.2.0.112.1.0.212.1.0.111.2.0.411.2.0.3
- THIS SECTION NEEDS TO BE RE-WRITTEN AS IT IS NO LONGER CORRECT. USE ENVIRONMENT VARIABLES FOR NOW.
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
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 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
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent