Since I decided to get rid of my old lab and create a new one, I started looking for some options and found and Oracle git repository for Vagrant deployments.
The repository is very complete and the "OracleRAC" deployment was almost perfect of what I wanted to start with, specially the option to use VirtualBox or KVM/libVirt
After some tests, I decided to fork the Oracle repository and add some changes so I could also learn a bit more about Vagrant and the scripts they added to it (they are very good way to understand how Oracle clusters are deployed or Databases are created)
If you are looking for a good and simple deployment, please do use the Oracle repository, I'm sharing my fork since they could be people thinking about doing the same and maybe this could help them in the process, but I don't really think I added anything very useful to most people.
Anyway, please have a look to the fork if you think it could be good for you :)
This is the list of modifications made to the amazing original project
- Second rac cluster added to be deployed independently
- Extra 19c Database created in cluster "rac1" (See "db2_name:/db2_home/pdb2_name" etc.. under "config/vagrant.yml")
- No databases are created in "rac2" (The intention is to create more scripts to create Standby Databases there)
- Extra packages installed (nano highlight git mlocate bash-completion bash-it)
- Extra packages to be able to install 11g databases (elfutils-libelf-devel-0 gcc-4*x86_64* gcc-c++-4*x86_64* numactl-devel-2*x86_64*)*
- Changed Diskgroups to have External Redundancy and RDBMS compatibility to 11.2 in RECO case (Seems like you still need to change "_asm_allow_older_clients" to TRUE to be able to install 11g)
- Bash profile modified (Current SID configured and pmon processes running)
- oracle user added to sudoers with no password (I know, not very secure, but this is for a test after all)
- DNS 188.8.131.52 added to resolv.conf
- ORCL_software moved to have a central place for both Clusters
- Added extra script to modify oratab file (Not working for second node of the cluster though)
- Fred Denis oracle-scripts downloaded into /home/$USER/bin
- sqlcl installed using Connor Mcdonald "getsqlcl" script
The way is deployed is the same way than the original one, just need some extra configuration added into "config/vagrant.yml" and allocate Oracle Database 19c Software into "ORCL_software".
For more info, check the Readme file
Hope you enjoy or at least makes you have a look of how useful Vagrant can be :)