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. If you're planning to come, check that your laptop has enough horsepower. Our minimum requirements are listed in the first lab: Hardware and Windows Minimum Requirements. 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 (../Overview) when participants arrive. For setting up lab workstations complete ../Hardware and Windows Preparation on all workstations set browser homepage to ../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 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 The timeslots listed here correspond to session timeslots at Open World (see discussion page). 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 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 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. 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 To add yourself on the volunteer schedule click here on EDIT -------------------------------------> The timeslots listed here correspond to session timeslots at Open World. 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. Tweet: TBD 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. Tweet: RAC Attack at #ukoug with #racsig and #pythian racattack.org UKOUG 2012 Volunteers To add yourself on the volunteer schedule click here on EDIT -------------------------------------> The timeslots listed here correspond to session timeslots at UKOUG. 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 -------------------------------------> Timeslots need to be defined. 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 The timeslots listed here correspond to session timeslots at tech13. 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