# RAC Attack - Oracle Cluster Database at Home/Events

RAC Attack is on the road!! Come visit us in person and we'll help you setup RAC on your laptop, using this wikibook.
This wiki page is used for both visitor information and for organizer and volunteer coordination. If you have experience with RAC then please feel welcome to volunteer. And no matter who you are, please help us keep the information on this page up-to-date!

## RAC Attack Events

| Dates | Country/Event | Time | RAC Attack Location | Organizers |
| *** UPCOMING EVENTS *** |||||
| *** PAST EVENTS *** |||||
| 2011-Oct-3/4/5/6 | USA: OpenWorld | 9am - 1pm every day | OTN Lounge (attached to Howard Street Tent) | Alex Gorbachev, Jeremy Schneider (email) |
| 2011-Dec-6 | UK: UKOUG | 09:00 - 18:35 | Overhang gallery above exhibition hall | Alex Gorbachev, Jeremy Schneider (email) |
| 2012-Feb-15/16 | USA: RMOUG | During exhibition opening hours | Exhibition hall near Pythian and APRESS booths | Alex Gorbachev |
| 2012-Mar-21/22 | Norway: OUGN Spring Seminar | Day 1: From 11:00 / Day 2: TBC | Day 1: Radisson BLU Scandinavia, Oslo / Day 2: Color Magic (boat) | Martin Bach, Martin Nash |
| 2012-Oct-1/2/3/4 | USA: OpenWorld | 9am - 1pm | OTN Lounge | Jeremy Schneider (email) |
| 2012-Nov-20/21/22 | Germany: DOAG | Exhibition opening hours | Exhibition Hall | Bjoern Rost |
| 2012-Dec-3/4/5 | UK: UKOUG | Exhibition opening hours | Exhibition Hall Balcony | Alex Gorbachev, Bjoern Rost (email) |
| 2013-Apr-8/9 | USA: Collaborate | Mon 9:45-12:45, Mon 2:30-5:30, Tue 10:45-1:30 | Mon AM Mile-High Foyer, Mon PM & Tue Mile-High 1E | Jeremy Schneider (email) |
| 2013-Sep-23/24/25/26 | USA: OpenWorld | 10am - 2pm on Tue and Wed | OTN Lounge (lobby of Moscone South) | Yury Velikanov |
| 2013-Nov-14 | Japan: JPOUG - Tokyo | 2pm - 6pm | Akihabara, Conference UDX | Kamran Aghayev A. |
| 2013-Nov-21 | USA: NoCOUG - San Jose, CA | 2pm - 6pm | Los Altos Room | Iggy Fernandez, Gwen Shapira, Terry Sutton, Ian Jones, Jimmy Brock |
| 2013-Dec-2 | UK: UKOUG_TECH13 | 8:30am - 5pm on monday | Main Floor | Osama Mustafa ,helping in the morning Philippe Fierens |
| 2014-Jan-15 | Latvia: LVOUG | 6pm - 10pm | Startup Latvia | Yury Velikanov, Andrejs Vorobjovs, Juris Trosins, Maris Elsins (participated 25 geeks) |
| 2014-Feb-5/6/7 | USA: RMOUG Training Days 2014 | 10:00am - 4:00pm, Thu 06-Feb 2014 and Fri 07-Feb 2014 | Colorado Convention Center, Denver CO USA | Bobby Curtis |
| 2014-Mar-11 | Ireland: Irish OUG | 10:00am - 4:00pm | The Convention Centre, Dublin, Ireland | Marcin Przepiorowski |
| 2014-Apr-7-11 | USA: IOUG Collaborate 2014 | 6 April, Sun, Pre-Conference | Las Vegas | Yury Velikanov, Ludovico Caldara |
| 2014-Jun-5-6 | Finland: OUGF Harmony 2014 | 5 June 12:00-16:00 | Lappish Kota 1 | Bjoern Rost, Kamran Aghayev A., Philippe Fierens |
| 2014-July-11 | Argentina: ArOUG OTN Tour 2014 | 11 July 14:00-18:00 | Sala C, Universidad de San Andres, 25 de Mayo 586, Buenos Aires | Kamran Aghayev A., Marcelo Ochoa, Nelson Calero |
| 2014-July-15 | Uruguay: UYOUG OTN Tour 2014 | 15 July 9:00-17:00 | Universidad ORT Campus centro | Kamran Aghayev A., Nelson Calero, Hans Forbrich |
| 2014-September-17 | Switzerland: Geneva, Local initiative | 17 September 17:00-22:00 | Trivadis Offices | Ludovico Caldara |
| 2014-September-28 | USA: OperWorld 2014 | TBD | OTN Lounge | Bobby Curtis |
| 2014-November-3 | USA: ECO 2014 | TBD | Raleigh, NC: East Coast Oracle Pre-Conference Session | Erik Benner |
| 2014-November-19 | NZ: NZOUG Conference 2014 | 9:00 to 12:30 | University of Auckland, Session 260-073 | Osama Mustafa |
| 2015-April 12 | USA: IOUG Collaborate 2015 | April 12th, Sun, Pre-Conference | Las Vegas | Ludovico Caldara |
| 2015-August-19 | Germany: Duesseldorf, Local initiative | 19 August 16:00-22:00 | Trivadis Offices | Markus Flechtner (More Information) |
| 2015-August-22 | USA: Chicago (COUG) | 22 August 10:00-18:00 | Schaumburg Library | Alfredo Abate (More Information) |
| 2015-September-17 | Switzerland: Geneva, Local initiative | 17 September 17:00-22:00 | Trivadis Offices | Ludovico Caldara [More Information] |
| 2015-October-25 | USA: OpenWorld | 10:00 am - 4:30 pm | OTN Lounge | Bobby Curtis |
| 2015-November-18 | USA: Michigan Oracle Users Summit (More Information) | 18 November 09:00-17:00 | Schoolcraft College, Livonia, MI | Mark Bobak |
| 2015-November-20 | Mexico: Oracle Tech Day Guadalajara 2015 (More Information) | 10 am - 5 pm | Oracle Mexico Development Center, Zapopan, Jalisco | René Antúnez, Alex Zaballa, Ricardo Gonzalez |
| 2015-December-3 | USA: Georgia Oracle User Group (More Information) | 9:30 am - 4:00 pm | Oracle Offices, Atlanta, GA | Erik Benner |
| 2015-December-7 | UK: UKOUG_TECH15 (More Information) | All Day | ICC Birmingham - Exhibition Hall | Ludovico Caldara, Tim Hall, etc |
| 2016-January-21 | Germany: DOAG noon2noon | 14:00 - 20:00 | GHotel Würzburg | Bjoern Rost, Martin Bach |
| 2016-April-10 | USA: IOUG Collaborate 2016 | 9 am | South Seas Ballroom C | Seth Miller, Nelson Calero, Alfredo Abate |
| 2016-May-17 | USA: Great Lakes Oracle Conference | 10 am - 4 pm | Cleveland Public Auditorium, Cleveland, OH | Alfredo Abate, Mark Bobak |
| 2016-May-18 | Canada: Toronto Oracle User Group | 8 am - 4 pm | Oracle Office @Front Street | Slavko Stemberger, Eric, Nirmal Krish |
| 2016-August-5 | Peru: OTN Tour Peru (More Information) | 4:00 pm - 10:00 pm | GBS Offices, Lima, Peru | Nelson Calero, Ronald Vargas |

## Volunteers

If you have some experience with RAC then please hang out for one or two hours and help a few of our peers get a two-node cluster going on their laptop!

## Organizers
### Event Format

Key questions for determining event format:
* Who will help participants with problems as they work through the labs?
** Organizer(s) only
** Organizer(s) plus volunteer mentors
* What computers will participants use?
** BYO laptop - participants run cluster on their own machine (OOW11)
** Rental laptops - costs more, more reliable (Collaborate)
** Both (UKOUG11)
* What USB hard drive is the Oracle software destination?
** Participant BYO hard drive
*** participant takes cluster home
*** cannot legally allow jumpstarts or give database software; to stay legal, participant must start at beginning and download oracle software
** Event hard drives
*** more expensive for organizer (or sponsor), participant cannot take cluster home
*** can pre-download software and legally allow jumpstarts
** Both
*** Must take responsibility for participant and volunteer behavior
* What options (if any) will be provided to help participants get started faster?
** Pre-Downloaded Software (OEL, Database, GI)
** Jumpstart - scripts to instantly decompress and setup virtual machine images at later points in the lab
** Rental Laptops with First Lab Already Complete - i.e. virtualization software is already setup, participant can immediately jumpstart
In Jeremy's experience, most participant recruitment happens at the event. Many (but not all) people have a laptop they can use. Very few have an external hard drive which they can use.

### Material Requirements

This is a master list. Specific requirements depend on the event format; see questions above.
* Equipment
** Printed Books (See Create Full Book)
** Rental Laptops
** Feedback Forms, Stickers for Hard Drives
** Cameras for taking photos during event (cell phones are usually used)
** Event-specific twitter hashtag (can also use generic #racattack hashtag if desired)
** optional: USB-Powered Hard Drives (used to recommend at least 1 per anticipated concurrent participant, recently many people run off local hard drive only)
* Venue
** Internet Connection - always required until we finalize a printable version of the handbook
** Power strips
** Tabletop workspace
** Signs, Banners - vector graphics are available
** Whiteboard is optional
** Projector & Screen is optional

### To Do Pre-Event

* Event
** Coordination with Event Schedule
** Inclusion in Program
** Approval for Signage
* Publicity
** Volunteer Recruitment
** Event Advertising (blogs, twitter, mailing lists, personal emails, linkedin, etc)
* Run-through labs to test online tutorials, test ext hd and create jumpstart images
** Make sure that flag is set to prompt for destination drives
* Print feedback forms and any needed labels for jumpstart hard drives
* Prepare a getting-started slide if a projecter & screen will be used
* Complete the first lab on rental laptops so that they are ready for jumpstarts
* Send reminder emails to first-day volunteers just before the event
* Prepare a very brief "getting-started" explanation which you can give to participants as they start

### To Do At-Event

* Write getting-started instructions on the white-board or put a getting-started slide on the projecter
* If multi-day event, send reminder emails each day for volunteers on following day
* Be friendly and invite passers-by to try the lab
* Have fun!
* Refer participants to the website and mailing list as they leave
* Keep records
** Number of participants each day
** Which labs were completed, roughly how long it took
** Compliments and criticisms (anonymous)

### To Do Post-Event

* Return rental equipment
* Email your records to the racattack list

### Notes for Organizing Classes

Few thoughts about best practices for settings up labs
* the "introduction" or kickoff is crucial. having "options" for which track or where to start is nice, but might be overwhelming for many participants. perhaps it would be much better to give specific instructions for shorter events.
** has worked well to start with patching lab, then jumpstart and do GI install next
** another good option for beginners is the services & failover lab
* startup cluster DB before class so that it's running and window is already open when people arrive, helps carry momentum from introduction speech
* could also be good to have web browser already open to home page (RAC Attack - Oracle Cluster Database at Home/Overview) when participants arrive.
For setting up lab workstations
* complete RAC Attack - Oracle Cluster Database at Home/Hardware and Windows Preparation on all workstations
* set browser homepage to RAC Attack - Oracle Cluster Database at Home/Overview
* clean desktop: delete all unneeded icons
** keep: my computer, recycle bin, vmware server home page, putty, vncviewer, winscp, procexp
** icons for jumpstarting - but note that this whole jumpstarting thing should be re-worked when we switch to virtualbox, just need to retain some simple and automated way to reset environment to any point during the labs
** if there's a second virtualization software installed (like virtualbox) which is not being used for this class, make sure to delete its icon from the desktop so participants don't get confused and run the wrong one!!

## Archives
### OpenWorld 2011 Publicity

This year at Oracle OpenWorld, get hands-on experience with RAC! (A key part of Exadata.) Hang out at the OTN Lounge with experts from the IOUG RAC SIG and get an 11gR2 RAC cluster database running inside virtual machines on your own windows-based laptop. Experiment boldly - if you make a mistake then you won't have to start over; we can "reset" your virtual machines to any point in the labs. To get the most out of this experience, we recommend that you bring a USB-powered external hard drive with 100G of free space - you can buy one online for about $40. More info at http://racattack.org/e
Event logo is available as a vector graphic at https://github.com/ardentperf/racattack/blob/master/graphics/racattack-event-logo.svg

### OpenWorld 2011 Volunteers

| | Monday |
| 9:00 - 10:45 | Bjoern Rost (via mail), Martin Nash (email) |
| 11:00 - 12:15 | Frits Hoogland (email) |
| 12:30 - 1:45 | Sergio Del Rio (sent email) |
| | Tuesday | Wednesday |
| 9:00 - 10:00 | Bjoern Rost (via mail), Fuad Arshad (email) | Riyaj Shamsudeen (email), Karl Arao (email) |
| 10:15 - 11:30 | Tim Hall (email), Tariq Farooq (email) | Tim Gorman (sent email) |
| 11:45 - 1:00 | Tim Hall (email), K.P. Singh (email) | Gwen Shapira (email),Syed Jaffer Hussain (email) |
| | Thursday |
| 9:00 - 10:15 | Markus Michalewicz (sent email), Syed Jaffer Hussain (email) |
| 10:30 - 11:45 | Kai Yu (sent email), Tariq Farooq (email) |
| 12:00 - 1:15 | Markus Michalewicz (sent email), Dave Herring (email) |

### UKOUG 2011 Publicity

This year at UKOUG, get hands-on experience with RAC! (A key part of Exadata.) On Tuesday, hang out in the overhang gallery above the exhibition hall with experts from the IOUG RAC SIG and get an 11gR2 RAC cluster database running inside virtual machines on your own windows-based laptop. Experiment boldly - if you make a mistake then you won't have to start over; we can "reset" your virtual machines to any point in the labs. To get the most out of this experience, we recommend that you bring a USB-powered external hard drive with 100G of free space - you can buy one online for about $40. More info at http://racattack.org/e

### UKOUG 2011 Volunteers

Note: did not end up recruiting volunteers. But FYI, these were the timeslots coordinated with Tuesday session timings:
09:00 - 10:10 // 10:10 - 11:15 // 11:15 - 12:25 // 12:25 - 13:25 // 13:25 - 14:40 // 14:40 - 15:35 // 15:35 - 16:40 // 16:40 - 17:50 // 17:50 - 18:35

### OUGN Spring Seminar 2012 Publicity

As part of Oracle User Group Norway's Spring Seminar 2012 (http://www.ougn.no/spring-seminar-2012) you will have opportunity to get hands-on experience building an Oracle RAC database using virtual machines on your own laptop with help from experts including Martin Bach (co-author of "Pro Oracle Database 11g RAC on Linux"). You will be welcome to spend as much time as you would like, or as little as you can spare. We'll help you get started, explain step-by-step or troubleshoot what's gone wrong.
To get the most out of this experience, we recommend that you bring a USB-powered external hard drive with 100G of free space or have an SSD with appropriate space on your laptop. You do need your laptop to set it up - not just hard-drive to copy. The labs are designed for Windows-based laptops but we will assist Mac OS X and Linux users as well. H/w requirements are on racattack.org and you can also start going via laptop preparation steps at home to save time at the conference.

### RMOUG 2012 Publicity

This year at RMOUG, get hands-on experience with Oracle RAC. Hang out in the exhibition hall with the experts from the RAC SIG and Pythian and get an 11gR2 RAC cluster database running inside virtual machines on your own laptop. You can drop in for few hours during the conference between the sessions or spend there the whole day setting up the environment and running through the labs.
To get the most out of this experience, we recommend that you bring a USB-powered external hard drive with 100G of free space or have an SSD with appropriate space on your laptop. You do need your laptop to set it up - not just hard-drive to copy. The labs are designed for Windows-based laptops but we will assist Mac OS X and Linux users as well. H/w requirements are on racattack.org and you can also start going via laptop preparation steps at home to save time at the conference.
Event logo is available as a vector graphic at https://github.com/ardentperf/racattack/blob/master/graphics/racattack-event-logo.svg

### OpenWorld 2012 Publicity

This year at Oracle OpenWorld, you will have the opportunity to get hands-on experience building an Oracle RAC database using virtual machines on your own laptop with help from the experts in the IOUG RAC SIG and Pythian. Find us in the OTN Lounge - you will be welcome to spend as much time as you would like, or as little as you can spare. We'll help you get started, explain step-by-step or troubleshoot what's gone wrong.
To get the most out of this experience, we recommend that you bring a USB-powered external hard drive with 100G of free space or have an SSD with appropriate space on your laptop. You do need your laptop to set it up - not just hard-drive to copy. The labs are designed for Windows-based laptops but we will assist Mac OS X and Linux users as well. H/W requirements are on racattack.org and you can also start going via laptop preparation steps at home to save time at the conference.

### OpenWorld 2012 Volunteers

To add yourself on the volunteer schedule click here on EDIT ------------------------------------->
Rules:
* two timeslots for each volunteer
* two volunteers for each timeslot
* event organizers will setup, teardown and bring materials. one event organizer will always be on-hand at the RAC Attack table.
| | Monday |
| 9:00 - 10:30 | Leighton Nelson, Arup Nanda |
| 10:45 - 12:00 | Hans Forbrich, Chet Justice |
| 12:15 - 1:30 | Tim Hall, John Clarke |
| | Tuesday | Wednesday |
| 9:00 - 10:00 | Martin Nash , Jason Arneil | Karl Arao, Rikard Sjöholm |
| 10:15 - 11:30 | Tim Gorman, Hans Forbrich | Tim Hall, Frits Hoogland |
| 11:45 - 1:00 | Andy Kerber, Kai Yu | Michael Abbey, Frits Hoogland |
| | Thursday |
| 9:30 - 11:00 | Martin Nash, Bjoern Rost |
| 11:15 - 12:30 | Michael Abbey, Kai Yu |
Please send your contact info to an organizer! They will try to remind you the day before your volunteer slot.

### DOAG 2012 Publicity

Bei der diesjährigen DOAG Konferenz in Nürnberg vom 20. bis 22. November haben Teilnehmer die Chance, selbst Erfahrung mit der Installation, Einrichtung und dem Betrieb von Oracle RAC Clustern mit virtuellen Maschinen auf dem eigenen Notebook zu sammeln. Experten der RAC SIG helfen bei der Einrichtung und stehen auch sonst für alle Fragen zu Clusterdatenbanken zur Verfügung. Ob als Pausenfüller zwischen Konferenzsessions oder als Aktivität für einen kompletten Tag: Den Zeitaufwand kann jeder selbst bestimmen und es ist keine vorherige Anmeldung erforderlich.
Um allerdings das Maximum herauszuholen, empfehlen wir, neben einem eigenen Laptop auch eine weitere externe USB-Festplatte mit mindestens 100GB mitzubringen. Der Workshop war ursprünglich gedacht für Windows Computer mit vmWare, wurde aber mittlerweile auch auf VirtualBox portiert und funktioniert damit auch auf MacOS und Linux. Die genauen Hardwareanforderungen finden sich auf racattack.org
Wer keine eigenen Laptop hat oder mitbringen möchte, kann die Demos auch an zwei bis drei von uns gestellten Rechnern durchspielen, verpasst dann aber die Gelegenheit, sein eigenes Lab mit nach Hause zu nehmen.

### UKOUG 2012 Publicity

This year at UKOUG, you will have the opportunity to get hands-on experience building an Oracle RAC database using virtual machines on your own laptop with help from the experts from the IOUG RAC SIG and Pythian. Find us on the Exhibition Gallery on Monday 11am - 3pm and Tuesday 9am - 3pm. You will be welcome to spend as much time as you would like, or as little as you can spare. We'll help you get started, explain step-by-step or troubleshoot what's gone wrong.
To get the most out of this experience, we recommend that you bring a USB-powered external hard drive with 100G of free space or have an SSD with appropriate space on your laptop. Please bring your own laptop! (We will have few laptops to borrow if required). The labs are designed for Windows-based laptops but we will assist Mac OS X and Linux users as well. H/W requirements are on www.racattack.org and you can also start doing preparation steps at home on your laptop, to save time at the conference.
It's advised to download Oracle Enterprise Linux and Oracle Database and Grid installation media if you want to take your environment home after the workshop (you must agree with the license online). See http://en.wikibooks.org/wiki/RAC_Attack_-_Oracle_Cluster_Database_at_Home/Download_Oracle_Enterprise_Linux and http://en.wikibooks.org/wiki/RAC_Attack_-_Oracle_Cluster_Database_at_Home/Create_RAC_Attack_DVD. If you don't have Linux installed to prepare the image in the last list and didn't proceed to Linux install at home, just go to http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linuxsoft-085393.html and download two files for Oracle Database and one for Grid Infrastructure. Remember to download 32 bit versions of Linux and Oracle media!
We are setting up either on the old version of VMware Server 2 or using Virtual Box.

### UKOUG 2012 Volunteers

To add yourself on the volunteer schedule click here on EDIT ------------------------------------->
Rules:
* two timeslots for each volunteer
* two volunteers for each timeslot
* event organizers will setup, teardown and bring materials. one event organizer will always be on-hand at the RAC Attack table.
| | Monday (3.12.) |
| 11:00 - 12:30 | Bjoern Rost, Alex Gorbachev |
| 12:30 - 13:45 | Juris Trošins (vol.), Bjoern Rost |
| 13:45 - 15:00 | Michael Abbey, Alex Gorbachev |
| | Tuesday (04.12.) |
| 9:00 - 11:00 | Alex Gorbachev, Juris Trošins (vol.) |
| 11:00 - 13:30 | Michael Abbey, Alex Gorbachev |
| 13:30 - 15:00 | Alex Gorbachev |
Please send your contact info to an organizer (Alex Gorbachev, Bjoern Rost)! They will try to remind you the day before your volunteer slot.

### OpenWorld 2013 Volunteers

To add yourself on the volunteer schedule click here on EDIT ------------------------------------->
Rules:
* one/two timeslots for each volunteer
* two volunteers for each timeslot
* event organizers will setup, teardown and bring materials. one event organizer will always be on-hand at the RAC Attack table. (??)
* Volunteers
* Yury Velikanov (~2x4h slots)
* Leighton Nelson (~2x4h slots)
* Bobby Curtis (1x4h slot)
* Seth Miller (1x4h slot)
* Hans Forbrich (2+x4h slot)
* Ludovico Caldara (2x4h slots)
* Bertrand Drouvot (1x4h slot)
* Osama Mustafa (1x4h slots)
* Kamran Aghayev (1x4h slots)
* Bjoern Rost
* Tim Hall (~2x4h slots)
* Martin Nash

### UKOUG 2013 Volunteers

RAC ATTACK will be available this year at UKOUG_TECH13 Here From 2 Dec to 4 Dec 2013
Volunteer this Year
* Volunteer Names
* Osama Mustafa
* Marcin Przepiorowski
* Philippe Fierens
* Bertrand Drouvot
* Martin Bach
* Maris Elsins
Rules:
* two volunteers for each timeslot
* event organizers will setup, teardown and bring materials. one event organizer will always be on-hand at the RAC Attack table.
| | Tuesday |
| 9:00 - 11:30 | Bjoern |
| 11:15 - 12:45 | Maris Elsins, Andrejs Karpovs |
| 12:45 - 14:45 | Osama, Martin Nash |
| 14:45 - 17:00 | Marcin Przepiorowski |
| 17:00 - 18:30 | |