RAC Attack - Oracle Cluster Database at Home/RAC Attack 12c/Software Components

RAC Attack - Oracle Cluster Database 12c at Home (e)

Overview

Events

Local Manual of Style

Bullpen (Newly Contributed Content)

Expanded Table of Contents

Part I: Setting Up RAC

1. Hardware Requirements
2. Software Components
3. Prepare Host
4. Install Linux
5. Create Cluster
6. Install Grid Infrastructure
7. Install Database Software
8. Create Database

Part II: Exploring RAC

1. Cluster Testing
2. Services, Failover and Load Balancing

   Part II still in development phase

Part III: Advanced Labs

1. Flex Cluster and Flex ASM
2. Policy Managed Database

   Part III still in development phase

Before starting you need to know what software will be installed. If attending an event, would be a good idea to download the software in advance to your laptop in order to avoid the download during the labs. The copyrighted software is not distributable so the volunteers will not be able to give you all the required software components. But organizers may have set up a proxy server to speed up downloads or provide at least the free software.

Windows 7 64 bit

This book covers Windows 7 64 bit as host even if all operating systems that can run VirtualBox 64-bit can be used. 64 bits are mandatory since Oracle 12c for Linux 32-bit is not available.

VirtualBox

This book uses VirtualBox as many Oracle specialists consider it as a mature and free virtualization solution, fully compatible with Oracle Software: https://www.virtualbox.org/. The VirtualBox version 4.3.26 and older versions from 4.2.12 up to 4.2.18 have been tested successfully with OEL6 and Oracle 12c. The latest successfully tested VirtualBox version is 5.0.8

A few virtualbox versions (4.3.14 to 22 if I remember well [1]) had serious problems on Windows. EL 6.4 to 6.7 have been tried without problems. [2]

Putty

One of the preferred SSH clients for Windows. You can download it here:

http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe

Vnc Viewer

The servers will be installed without X server, so you'll need VNC to get the graphics:

http://www.realvnc.com/download/get/1295/

Oracle Software

Oracle Enterprise Linux 6

Can be downloaded from http://edelivery.oracle.com/linux/.

1. Login to: http://edelivery.oracle.com/linux with your Oracle Account
2. On the Media Pack Search page, select:
Product pack: Oracle Linux Platform: x86 64 bit Click GO
3. Click on: Oracle Linux Release 6 Update 4 Media Pack for x86_64 (64 bit)

4. Click on the download button at the first line:

5. Once the download of the file V37084-01.iso is finished, rename it to Oracle_Linux_6_64.iso to distinguish it easily from other Oracle files.

Oracle Grid Infrastructure and Database 12c (12.1.0.1)

Can be downloaded from http://edelivery.oracle.com/.

1. Login to: http://edelivery.oracle.com/ with your Oracle Account
2. On the Media Pack Search page, select:
Product pack: Oracle Database Platform: Linux x86-64 Click GO
3. Click on: Oracle Database 12c Release 1 (12.1.0.1.0) Media Pack for Linux x86-64

4. Click on the download button for the following four packs:
• Oracle Database 12c Release 1 (12.1.0.1.0) for Linux x86-64 (Part 1 of 2)
• Oracle Database 12c Release 1 (12.1.0.1.0) for Linux x86-64 (Part 2 of 2)
• Oracle Database 12c Release 1 Grid Infrastructure (12.1.0.1.0) for Linux x86-64 (Part 1 of 2)
• Oracle Database 12c Release 1 Grid Infrastructure (12.1.0.1.0) for Linux x86-64 (Part 2 of 2)

5. The following files are downloaded:
• V38501-01_1of2.zip
• V38501-01_2of2.zip
• V38500-01_1of2.zip
• V38500-01_2of2.zip
After uncompressing them, there will be two folders: "grid" and "database" containing the full installation.