RAC Attack - Oracle Cluster Database at Home/Hardware and Windows Minimum Requirements


This handbook will walk you through the process of creating a two-node Oracle RAC cluster on your own laptop or desktop computer.

A detailed explanation of virtualization is beyond the scope of this lab but here is a simple overview of what we are building:


Hardware Minimum Requirements

edit

Most modern laptop and desktop computers should be powerful enough to run a two-node virtual RAC cluster. In a nutshell, these are the recommended minimums:

  • Dual-core 2GHz 32-bit processor (it's been done with single-core)
  • 4GB memory (it's been done with 3GB)
  • Two physical hard disks - not partitions (it's been done with one)
    • External HD for laptops (it's been done with certain USB flash memory sticks)
    • 50 GB + 10.5 GB free space (it's been done with slightly less)
    • Support files larger than 2GB, e.g. NTFS (it's been done without 2GB file support, on FAT32)
  • Windows XP or Vista (Linux & Mac & Windows 7/8 are not directly covered in these instructions, but a supplementary PDF covering VirtualBox can be downloaded)

If your laptop or desktop does not meet these minimum requirements then it is not recommended to try completing the RAC Attack labs. Although it is possible to complete these labs with smaller configurations, there are many potential problems.

Windows Preparation

edit
  1. Reboot windows. After this clean boot-up, don't start any unneeded programs - for example email or instant messenger.
  2. If possible, disable virus scanning (so that your antivirus software[1] doesn't try to scan I/O on the virtual machine disks).
  3. Terminate any memory resident programs which are running, especially programs that help big applications "quick-start" (these often use up a lot of memory).

Hardware Verificaton

edit

Processor

edit
  1. From the Start menu, choose or type RUN. In the dialog box that appears, type msinfo32.
     
  2. Select System Summary in the left pane. Scroll down to Processor in the right pane. Verify that you have at least 2 cores and that the speed is at least 2000 Mhz.
     

Memory

edit
  1. Scroll down to Memory in the right pane. Verify that Installed Physical Memory is at least 4GB. Also, verify that Available Memory is at least 1.4GB. You can terminate programs which run in the foreground and background to increase the Available Memory.
     


Hard Disks

edit
  1. In the left pane, choose Components -> Storage -> Disks. Count the number of Disk Drive entries and verify that there are at least two.
     
Second Hard Disk
edit
Connection Storage Type
Most Preferred


 


Least Preferred
Inside Computer (SATA) - or -
USB 3.0 - or -
GigaBit Ethernet Direct
no network, not shared - direct to dedicated External Hard Disk
Hard Disk
not shared with anything else
USB 2.0
Thumb Drive Flash Memory
advertised / reviewed / tested at least 50 MB/s
GigaBit Ethernet to Network - or -
100 MegaBit Ethernet Direct
no network, not shared - direct to dedicated External Hard Disk
Thumb Drive Flash Memory
advertised / reviewed / tested at least 15 MB/s
Shared Hard Disk
shared with other programs
Free Space Requirements
edit

RAC Attack is carefully designed to use three directories and spread out I/O for the best possible responsiveness during labs. You can choose how to spread the directories across your hard disks, and the best configuration may vary depending on your connection and storage type.

Directory Name Description Free Space Suggested Location
RAC11g Operating System
Oracle RAC Software
50 GB Second Hard Disk (not flash)
RAC11g-shared Oracle RAC Data 7.5 GB Windows Hard Disk*
RAC11g-iso OEL Installation DVD (read-only) 3 GB Windows Hard Disk*

*page file is usually on Windows Hard Disk

Note: do not create the RAC11g directory (with OS and Oracle Software) on a Flash Thumb Drive.

Login Accounts

edit

RAC Attack requires a local windows user account with a password and with administrative privileges. You may login using a network or password-free account only if the login account has admin privileges and you know the password for a local account which also has admin privileges (and not an empty password).

If your account is not local, or if your account does not have local admin privileges then you can create an admin account by following the directions here.

Creating a Local Admin Account

edit
  1. From the Start menu, choose RUN. In the dialog box that appears, type cmd to launch a command prompt. On Windows 7 find the "search programs" field at the bottom of the Start menu. Type cmd in but don't run it. Right click on "cmd" then choose to "Run as administrator". After you have opened the command prompt as an admin user, run the following two commands:
    net user admin racattack /add
    net localgroup administrators admin /add
    

    Login: admin
    Password: racattack

Verifying the Login Account

edit
  1. Type net user %username% (if you're using a network or password-free login account then replace %username% with the local password-ed admin account). VERIFY the username, VERIFY that password required is yes, and VERIFY that local group memberships include Administrators.
     



  1. "What is Antivirus?". antivirus.comodo.com. Retrieved 2016-04-29.