Archive for the ‘Oracle 11g R2 RAC’ Category

IOUG Vritualization Webinar Recording is online.   Leave a comment

The IOUG vritualization Webinar presented by Saar Maoz and myself
was very well recieived. Accoriding to the IOUG statistics, there
were 444 registrants and 192 people attending the sessoion. In the
first part, I spent 30 minutes showing some of new features
of Oracle VM 3.0 and how to build the virtual infrasturcture for
deploying and running RAC with Oracle VM server 3.0 and Oracle VM
Manager 3.0.

In the second half of session, Saar presented Oracle RAC templats
and did a live demo how to build a two node 11gR2 RAC database on
Oracle VMs using RAC VM template in less than one hour.

If you are interested in reviewing the presentation again, IOUG has
posted the live recording of this presentation click here:


My OOW 2011 Conference Presentation Schedules   Leave a comment

I will present or participlate as a panellist of the following OOW sessions:

1. Ensure the High Availability and Stability of Oracle RAC: Storage and Network Side Story  , Session #09385,  10/2/2011, Sunday, 01:30 PM, Moscone West – 2005

2.Launching the IOUG Virtualization SIG: 360 Degrees of Virtualization for Oracle DBA… , session #28900, IOUG Virtualization panel,  10/2, Sunday, 04:00 PM, Moscone West – 2009

3. Consolidate Oracle E-Business Suite Databas in Oracle Database 11g Release 2 Grid: Case Study,  session#08945, 10/4/2011, Tuesday, 10:15 AM, Intercontinental – Intercontinental Ballroom A

4.  Configuring and Managing a Private Cloud with Oracle Enterprise Manager , Oracle OpenWorld 2011 session#06980 ,  10/4/2011, Tuesday, 05:30 PM,   Moscone South – 309, San Franscio

5.   Upgrading Oracle Enterprise Manager, Using Best Practices , Oracle OpenWorld 2011 session#0733, 10/6/2011, Thursday, 01:30 PM, Intercontinental – Intercontinental Ballroom A 

For details, please refer to the Oracle OpenWorld 2011 Content Catalog:

A Summary of My Experiences with the 2011 Oracle Technology Network Latin America Tour   Leave a comment

From July 5th to July 23rd, 2011, the 2011 Oracle Technology Network (OTN)Latin America Tour covered multiple countries ranging from Central America to South America.  The tour’s purpose was to give a series of presentations on various areas of Oracle Technology.  Led by Tom Kyte, the vice president of Oracle Corporation, the OTN tour speaker team consisted of world leading experts on Oracle Technology from Oracle Corporation as well as from the industry technology community.  It was a great honor to be invited to join this speaker team  to travel  and speak with  some of the  industry’s legendary speakers:   Graham Wood, Debra Lilley, Hans Forbrich , Francisco Munoz Alvarez, Ronald Bradford, Kuassis Mensah, Arup Nand and the great speakers from the local Oracle user group of each country.

The 2011 OTN Latin America Tour Speaker Team

On this OTN Latin America tour, I gave the following technology presentations at three South American conference sites: Sao Paulo, Brazil;  Montevideo, Uruguay and Santiago, Chile:

  1. Virtualized Oracle 11g/R2 RAC Database on Oracle VM: Methods/Tips
  2. Oracle 11gR2 Clusterware: Architecture and Best Practices of Configuration and Troubleshooting

Through these two presentations,  I  discussed  the Oracle RAC and Oracle VM technology with the Oracle user communities of these three countries, and also introduced the engineering work we do at the Dell Oracle solutions engineering lab on Oracle databases, and  Oracle VM and Cloud infrastructure. Additionally, I explained how the people in the  user communities in these quickly growing economic regions can take advantage of these solutions to meet their business needs.

At first thanks OTN for the sponsorship of the tour. And I want to expecially  thanks the event organizer Francisco Munoz Alvarez  for his admirable efforts,  and thanks  the local user group leaders and team members who hard work  made this great opportunity possible. It was delightful to see that the people in the Oracle communities in these three countries were very eager to explore  the new Oracle technology.  In two of my sessions in Sao Paulo, the audience filled the entire conference rooms. Brazil user group leader Eduardo Hahn and his team did an excellent job organizing this conference.  I was also amazed by the excellent work and great hospitality of the wonderful Uruguay user group  leaders Nelson  Calero and  Edelweiss  Kammermann and their team. The conference in Chile was  held in a great facility provided by a local private university. The conference’s audience was very attentive to the presentation content and they were very active in the QA  sessions. Somtime the QA and discussions were even extended to after  the sessions. Some of people  brought up the related questions from their current systems to discuss.

The highlights also include the hospitality of the great friends and wonderful culture experiences and the incredible sightseeing in these countries.  These also made this tour really memorable.  

Really want to thank everyone for this wonderful memory and hope I can join the tour again next year!

The following sideshows are the memory of the tour.

This slideshow requires JavaScript.

Oracle Technology Network South America Tour- Sao Paulo   2 comments

Being inivted by Oracle Technology Network (OTN),  on July 15th, 2011, I joined the last part of  OTN South America Tour to travel to Sao Paulo Brazil;  Montevideo Uruguay; and Santiago, Chile.  I will give two presentations at each conference.  On July  16th, I gave two presentations in Sao Paulo for the Brazil  Oracle User group  at GUOB) Tech Day 2011:

1) Virtualized Oracle 11g/R2 RAC Database on Oracle VM: Methods/Tips

2)Oracle 11gR2 Clusterware: Architecture and Best Practices of Configuration and Troubleshooting.

The followings are some photos from the conference and my presentation sessions:

This slideshow requires JavaScript.

How to Store Voting Disk Files in ASM for 11g R2 Clusterware High Availability   2 comments

11gR2 clusterware voting disk files can be stored in ASM through the ASM diskgroup.  To ensure the high availability of the clusterware, it is highly recommended to store multiple voting disk files. When storing the voting disk files in ASM, the redundancy setting of the ASM diskgroup determines the number of voting disk files. The following settings  are recommended for planning  the proper configuration of ASM diskgroup that is used to store the voting disk files.

  • External Redundancy: The ASM diskgroup only needs one failure group without mirroring and it only stores one voting disk file. It is recommended that the disk have  external redundancy RAID configuration to provide the storage high availability.  
  • Normal Redundancy:  The ASM diskgroup requires three failure groups and it will provide three voting disks files.
  • High Redundancy: The ASM diskgroup requires five failure groups and it has five voting disk files.

Following the recommended settings above, you can configure the 11g R2 clusterware by storing the voting disk files in ASM:

1.  Based on the external storage redundancy and number of voting disks that you plan  to have , select the appropriate redundancy setting for your ASM diskgroup. If there is no external redundancy for the storage disks or you would like to have additional voting disk files, it is recommended to select normal or high redundancy as the setting of choice for the ASM diskgroup.  As an example , we configure the high redundancy setting for the ASM diskgroup. The ASM diskgroup has five ASM failure groups each of which is on one of the following ASM disks:  ORCL:OCR1,  ORCL: OCR2, ORCL:OCR3,  ORCL: OCR4, ORCL:OCR5

     2.   During 11g R2 Oracle Grid Infrastructure installation,  select “Automatic Storage Management (ASM) In the storage selection step  as shown below:

3. Specify the ASM diskgroup name and select the proper redundancy level and the corresponding ASM disks. As   shown in the example below, select the high redundancy and the five ASM disk: ORCL:OCR1,  ORCL: OCR2, ORCL:OCR3,  ORCL: OCR4, ORCL:OCR5

4. After the Grid Infrastructure installation completes, login to the ASM instance to check the ASM diskgroup redundancy setting and list the voting disk files using the command of ‘crsctl query css votedisk’.

My Upcoming Presentation on IOUG –RAC Webinar Series   Leave a comment

I will speak at IOUG RAC Webinar Series on May 11th, 2011. The presentation aims to provide DBAs some practical understanding and best practices of system configuration such as network and storage that are very critical to the stability of Oracle clusterware and RAC. It discusses hardware/OS configuration, public and private interconnect network and shared storage configuration, and shares some experiences/tips for troubleshooting clusterware issues such as node eviction and how some useful diagnostic tools help for the root cause analysis. This presentation also covers some clusterware administration methods as well as the new clusterware features. The following are the details of this IOUG Webinar:

Title: Oracle11g R2 Clusterware: Architecture and Best Practices of Configuration and Troubleshooting
May 11, 2011 from 11:00am-12:00pm CDT
Register Today!  


  • Oracle 11g R2 Clusterware Architecture
  • System Hardware for Oracle Clusterware/RAC
  • Network configuration for Oracle Clusterware/RAC
  • Storage Configuration for Oracle Clusterware/RAC
  • Managing Oracle Clusterware
  • Clusterware Troubleshooting
  • QA

My Collaborate 11 Presentations:   Leave a comment

The Collaborate 11 conference will be held in Orlando, Florida on April 10-14, 2011, At this conference, I will be giving the following three presentions:

1. Title: Oracle E-Business Suite: Migration to Oracle VM & template based deployment:  

  •    Conference: The Oracle Applications Users Group (OAUG) Forum
  •    Time:  Monday, April 11 at 2:30pm-3:30pm.  
  •  Abstract:Oracle VM provides the server virtualization that not only enables high availability and scalability, also simplifies and standardizes the deployment for Oracle E-Business Suite.  To leverage Oracle VM, the existing Oracle E-Business systems on physical servers need to be migrated the VMs and a new development needs to start on the VMs.  Attend this session to learn some best practices for such an migration and  also to learn how to create and use the VM templates of customers’  own project specific Oracle E-Business systems for on-going project. The session will also examine how to leverage the benefits of Oracle VM such as high availability and scalability and server partitioning for Oracle E-Business suite R12.1 infrastructure

    2. Title:  Automated Provisioning Oracle 11g R2 RAC using Oracle Enterprise Manager 11g  Provisioning Pack

  •  Confernece: The Independent Oracle User Group (IOUG) Forum
  • Time:  Tuesday, April 12 at 11:45am – 12:15pm
  •   Abstract : Oracle Enterprise Manager 11g provides an end-to-end solution for automated provisioning and lifecycle management of the entire system stack.  This session covers how Oracle Enterprise Manager Provisioning pack can save the time and cost for IT organizations by automatically  provisioning Oracle Real Applications Cluster (RAC).  Attend this session to learn how configure the latest Oracle enterprise manager version 11gr1 and how to enable its provisioning pack including the provisioning deployment procedures and the software library ,and  how to automate some time consuming and error prone  tasks such as provisioning Oracle 11g R2 RAC database,  extending RAC database by adding an additional node and how to save the gold image of the 11g R2 RAC based on the existing RAC environment.

3. Ensure the RAC High Availability: Storage and Network Side Story

  •    Conference: The independent Oracle User Group (IOUG) forum, High Availability Bootcamp
  •     Time: Wednesday, April 13 at 10:30am – 11:30am
  • Abstract: While Oracle RAC technology provides the high level of availability and the great scalability for the database , the stability of the central piece of RAC technology: Oracle clusterware largely depends on its underneath system infrastructure: network and shared storage. Come to this session to learn some architecture of RAC and clusterware in 11g R1 and 11g R2 and the best practices of configuring the network and shared storage to ensure the stability and high availability of the Oracle clusterware and RAC. The session will also cover the troubleshooting tips of some clusterware stability issues such as node eviction which is frequently related to the network and the share storage.

I also will be attending the following panels as the moderator or a panelist:

1. IOUG High Availability Panel:    Time: Wednesday April 13,   11:45am-12:15pm

2. Oracle RAC SIG panels: 

  •     RAC SIG BOG Panel: Monday April 11,  9:15am-10:15am
  •      RAC customer Panel: Teusday April 12, 9: 15am-10:15am
  •      RAC Expert Panel, Wednesday, April 13, 8:00am-9:00am