Jump to content

RAC Attack - Oracle Cluster Database at Home/Events

From Wikibooks, open books for an open world

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

[edit | edit source]
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

[edit | edit source]

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

[edit | edit source]

Event Format

[edit | edit source]

Key questions for determining event format:

  1. Who will help participants with problems as they work through the labs?
    • Organizer(s) only
    • Organizer(s) plus volunteer mentors
  2. What computers will participants use?
    • BYO laptop - participants run cluster on their own machine (OOW11)
    • Rental laptops - costs more, more reliable (Collaborate)
    • Both (UKOUG11)
  3. 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
  4. 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

[edit | edit source]

This is a master list. Specific requirements depend on the event format; see questions above.

  1. 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)
  2. 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

[edit | edit source]
  1. Event
    • Coordination with Event Schedule
    • Inclusion in Program
    • Approval for Signage
  2. Publicity
    • Volunteer Recruitment
    • Event Advertising (blogs, twitter, mailing lists, personal emails, linkedin, etc)
  3. 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
  4. Print feedback forms and any needed labels for jumpstart hard drives
  5. Prepare a getting-started slide if a projecter & screen will be used
  6. Complete the first lab on rental laptops so that they are ready for jumpstarts
  7. Send reminder emails to first-day volunteers just before the event
  8. Prepare a very brief "getting-started" explanation which you can give to participants as they start

To Do At-Event

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

To Do Post-Event

[edit | edit source]
  1. Return rental equipment
  2. Email your records to the racattack list


Notes for Organizing Classes

[edit | edit source]

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

[edit | edit source]

OpenWorld 2011 Publicity

[edit | edit source]

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

Tweet: #RAC ATTACK in OTN Lounge at #OOW11. VMs on your windows laptop.
       Bring an external HD for best results. 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

[edit | edit source]
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

[edit | edit source]

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

Tweet: #RAC ATTACK tue in ex hall at #UKOUG. VMs on your windows laptop. 
       Bring an external HD for best results. http://racattack.org/e

UKOUG 2011 Volunteers

[edit | edit source]

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

[edit | edit source]

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

[edit | edit source]

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

[edit | edit source]

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.

Tweet: #racattack in OTN Lounge at #oow every day 9a-1p. expert
       help building a cluster DB in VMs on your own laptop.

OpenWorld 2012 Volunteers

[edit | edit source]

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

[edit | edit source]

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.

Tweet: TBD


UKOUG 2012 Publicity

[edit | edit source]

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.

Tweet: RAC Attack at #ukoug with #racsig and #pythian racattack.org

UKOUG 2012 Volunteers

[edit | edit source]

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

[edit | edit source]

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

[edit | edit source]

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