8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Oracle Database 18c RAC On Oracle Linux 7 Using VirtualBox and Vagrant


Anonymous said...

Hey Tim, Very good way to create a test/play RAC without having to go through the whole 9-yards!!
Question: You say that "The finished system includes the host operating system, three guest operating systems, two sets of Oracle Grid Infrastructure (Clusterware + ASM) and two Database instances all on a single machine"

Anonymous said...

1. I have a Win10k Pro box with VirtualBox installed. I presume the 1 DNS node and 2 RAC nodes will be created as VMs accessible from VirtualBox?
2. If so, would I be installing vagrant on the Win10k box?
3. Do the git clone on the Win10k box to create the directory structure that you show?

Anonymous said...

Thanks in anticipation. I have never worked with Vagrant.

Tim... said...

Hi.

1) Yes. Three new VMs on yout PC.
2) Yes. VirtualBox, Vagrant and Git client all on your PC.
3) Yes. Git clone on your PC.

Cheers

Tim...

Anonymous said...

Hi Tim,
Where do I set the value for time zone? I notice it might has show British Time in the log output.
I want to set the time zone to EST for East Coast USA.

Tim... said...

Hi.

It picks it up from the OS. Once installed you can manually reset it if you like. Google "oracle rac timezone".

Cheers

Tim...

Anonymous said...

Hi Tim,
How do I place these asm disk below to my /u05 dir on my E: drive before kick off the 'vagrant up' command? Once installed, it placed them into a dir called /u05 on my C: drive.
asm_disk_1: /u05/VirtualBox/shared/ol7_183_rac/asm_disk_1.vdi
asm_disk_2: /u05/VirtualBox/shared/ol7_183_rac/asm_disk_2.vdi
...

Tim... said...

Hi.

Replace them with a Windows path to a directory that exists. Could be anything, like:

asm_disk_1: C:\VirtualBox\shared\ol7_183_rac\asm_disk_1.vdi

You just need to specify a suitable path for you OS.

Cheers

Tim...

Anonymous said...

Thanks, Tim.
That make sense. I didn't realize that I can specify a Windows path like that for the asm disk files.

Tim... said...

Hi.

I altered the article of include and example of a Windows path, just in case anyone else was confused.

Cheers

Tim...

Anonymous said...

That'd be very useful.

Anonymous said...

By the way, Tim, is there a similar way to also change the Windows path for /u01 ?

Tim... said...

Hi.

Yes. I used "./ol7_183_rac1_u01.vdi" for example to put it into the current directory where "vagrant up" is run from. You can use a full path and put it anywhere if you want.

Cheers

Tim...

Anonymous said...

That's so cool. Thank you.

Anonymous said...

Hi Tim,

I tried to follow thorugh the installation. Whilst I understood the flow, I could not finish as I believe my Mac needs more resources such as memory. I have 8G Ram ans 100GB free space.

What would you recommend for a minimum spec machine? Either Mac or Windows?

Tim... said...

Hi.

If you add up the memory you can see it comes to 21G for the VMs, and you need some system memory on top of that. I was able to use 6G on the two RAC nodes, but it was really slow, so I don't think it's worth trying on less than 32G and 4 core machine. SSD would be nice. :)

Cheers

Tim...

Akhlaq said...

Hi Tim,
Thanks for the great article.Can you tell me where is example of a Windows path?My vagrant runs without error but does not runs the scripts.Please advise.

Regards,

Tim... said...

Hi.

I don't understand the question. This runs fine on a Windows. I wrote it on Windows and I run it on Windows.

Cheers

Tim...

Akhlaq said...

Tim,
What i meant was the paths in vagrant file.How to set them for windows environment.As i mentioned earlier setup.sh script is not running because of incorrect path in vagrant file.

Regards,

Anonymous said...

I have set the parameters like this
config.vm.synced_folder "F:/VM2/config", "/home/vagrant_config"
config.vm.synced_folder "F:/VM2/shared_scripts", "/home/vagrant_scripts"
and getting this error
vm:
* The host path of the shared folder is missing: F:VM2☼nfig
* The host path of the shared folder is missing: F:VM2 hared_scripts

Tim... said...

Hi.

You don't need to alter the paths in the Vagrantfile. The work fine. They are relative (not fully qualified) and the vagrant file doesn't care about "/" or "\". Like I said, I run this on windows.

Email me using tim(at)oracle-base.com. Easier to discuss via email than here.

Cheers

Tim...

Alex said...

Hi Tim,
Any parameters that I change, even with defaults, node2 deploy fails every time with "Host key verification failed'. Is this linked to Vbox version (Im using newest 6.0.12) or is it something that Im doing wrong?default:
Passwordless SSH Setup for oracle. Sun Sep 22 09:17:49 UTC 2019
default: Host key verification failed.
Fails for both root and oracle
Thanks!

Tim... said...

Hi.

In both the article and the README.md in GitHub it explains that this is expected, and you can ignore this warning. It works fine...

Cheers

Tim...

Alex said...

Went ahead with node 1 and the GI is running properly.
That's a really amazing effort to put these together, congratulations Tim!

Anonymous said...

this way of training is not good. please train as previous method.

Tim... said...

Hi.

Not sure what you mean. If you mean using the GUI installer, that is not really something I would recommend for learning, as I would never expect someone to do this in a real job. All work should be scripted. All those scripts are present in this build, whether you call them from Vagrant, or run them manually.

Cheers

Tim...

Tim... said...

I wrote this to explain my stance on this.

https://oracle-base.com/blog/2020/01/29/why-no-gui-installations-anymore/

Cheers

Tim...

Anonymous said...

Hi Tim, This is great!
Is there anyway of configuring the servers to have a bridged adapter connection after creation of the rac servers?
I tried to shutdown the VMs, change the servers network to bridged and start them up but the vagrant up command overwrites it and sets it back to NAT.
Thanks

Tim... said...

Hi.

You will have to change the Vagrant config to use bridging connections. I've never done this, so you'll need to look it up I guess.

Cheers

Tim...

Anonymous said...

I often read the older rac articles and used them as a trainig before going to a customer.
People who want to install RAC in VB do so to learn about the installation process step by step.
How do the disks become asmdisks or what is the runclufy. Preconfigures RAC image is available at Oracle.
There is no usecase for a mass deployment of Oracle RAC installations ;)

Tim... said...

Hi.

All those things are explained as part of the vagrant build. All the same setup work is done, but it is scripted rather than manually clicking buttons on screens. Read the contents of the shell scripts. You will see this.

"There is no usecase for a mass deployment of Oracle RAC installations" : Odd. You don't want a repeatable process for deployments? I would be much happier going to a customer with a tried and true set of scripts for a silent installation that *always* worked, rather than turning up expecting to click on buttons.

I would also suggest you check out what the Enkitec folks are doing. They are the thought leaders on Exadata and RAC work, and they script all their builds. Often using Vagrant to practice stuff before doing it at customers.

I get the feeling you think that scripting is for play and GUI is for work, and I would suggest it is the other way around.

I understand preconfigured RAC images are available from Oracle, but that is not what these Vagrant builds represent. They are a step-by-step set of instructions on how you configure every step of the way. They just so happen to be runnable, even by people who don't care how to set up RAC, but want to use it.

If you want to keep using the GUI to do everything, that is your choice, but I would not employ someone with that preference. Everything needs to be scripted. I wrote about this here.

https://oracle-base.com/blog/2020/01/29/why-no-gui-installations-anymore/

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.