Vagrant — Oracle RAC Lab on OEL 8

# -*- mode: ruby -*-
Vagrant.configure("2") do |config|
  config.vm.box              = "generic/oracle8"
  config.vm.box_check_update = false

  # Shared disk path (must exist on host)
  SHARED_DISK_PATH = File.join(File.dirname(__FILE__), "shared_disks")

  [["rac1", "192.168.56.41", "192.168.56.51"],
   ["rac2", "192.168.56.42", "192.168.56.52"]].each_with_index do |(name, pub_ip, priv_ip), idx|

    config.vm.define name do |node|
      node.vm.hostname = name
      node.vm.network "private_network", ip: pub_ip,  name: "vboxnet0"
      node.vm.network "private_network", ip: priv_ip, name: "vboxnet1"

      node.vm.provider "virtualbox" do |vb|
        vb.name   = "Oracle-RAC-#{name.upcase}"
        vb.memory = 8192
        vb.cpus   = 2
        vb.customize ["modifyvm", :id, "--ioapic", "on"]

        # Shared storage — only create on first node
        if idx == 0
          Dir.mkdir(SHARED_DISK_PATH) unless Dir.exist?(SHARED_DISK_PATH)

          ["asm1", "asm2", "asm3"].each do |disk|
            disk_file = "#{SHARED_DISK_PATH}/#{disk}.vdi"
            unless File.exist?(disk_file)
              vb.customize ["createhd", "--filename", disk_file,
                           "--size", 10240, "--variant", "Fixed"]
              vb.customize ["modifyhd", disk_file, "--type", "Shareable"]
            end
            vb.customize ["storageattach", :id,
              "--storagectl", "SATA Controller",
              "--port", ["asm1","asm2","asm3"].index(disk)+1,
              "--device", 0, "--type", "hdd",
              "--medium", disk_file, "--mtype", "shareable"]
          end
        else
          # Attach existing shared disks to second node
          ["asm1","asm2","asm3"].each_with_index do |disk, port|
            vb.customize ["storageattach", :id,
              "--storagectl", "SATA Controller",
              "--port", port+1, "--device", 0,
              "--type", "hdd",
              "--medium", "#{SHARED_DISK_PATH}/#{disk}.vdi",
              "--mtype", "shareable"]
          end
        end
      end

      node.vm.provision "shell", path: "scripts/rac_prereqs.sh",
        args: [name, pub_ip, priv_ip]
    end
  end
end

#!/bin/bash
# scripts/rac_prereqs.sh
set -e

NODE_NAME=${1:-rac1}
PUBLIC_IP=${2:-192.168.56.41}
PRIVATE_IP=${3:-192.168.56.51}

echo "=== RAC Prerequisites for ${NODE_NAME} ==="

# Install Oracle Grid/RAC prerequisites
dnf install -y oracle-database-preinstall-19c
dnf install -y unzip libaio bc nfs-utils

# Create grid user
useradd -g oinstall -G dba,racdba,asmadmin grid
echo "grid" | passwd --stdin grid

# Configure /etc/hosts for all nodes
cat >> /etc/hosts << EOF
192.168.56.41  rac1        # Node 1 public
192.168.56.42  rac2        # Node 2 public
192.168.56.51  rac1-priv   # Node 1 interconnect
192.168.56.52  rac2-priv   # Node 2 interconnect
192.168.56.61  rac1-vip    # Node 1 VIP
192.168.56.62  rac2-vip    # Node 2 VIP
192.168.56.70  rac-scan    # SCAN IP
EOF

# Configure ASM shared disks
dnf install -y oracleasm-support
oracleasm init
oracleasm configure -i << ASMCFG
oracle
dba
y
y
ASMCFG

# Mark shared disks for ASM
oracleasm createdisk DATA1 /dev/sdb
oracleasm createdisk DATA2 /dev/sdc
oracleasm createdisk FRA1  /dev/sdd

# Setup SSH equivalency between nodes (simplified)
mkdir -p /home/oracle/.ssh /home/grid/.ssh
chmod 700 /home/oracle/.ssh /home/grid/.ssh

echo "=== RAC Node ${NODE_NAME} prerequisites done ==="
echo "Next: Install Grid Infrastructure, then RAC database"

# On rac1 as grid user
crsctl status res -t

# Check database status
srvctl status database -d ORCL

# Check all RAC instances
srvctl status instance -d ORCL -i ORCL1
srvctl status instance -d ORCL -i ORCL2

# Connect to RAC
sqlplus sys/Oracle@123@//rac-scan:1521/ORCL as sysdba
SELECT instance_name, host_name, status FROM gv$instance;

# Check ASM
sqlplus / as sysasm
SELECT name, state FROM v$asm_diskgroup;