Archive for January 2011

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
   
Advertisements

11g R2 clusterware and ASM, which one gets up first and which one depends on other?   1 comment

In Oracle 10g RAC and 11gR1 RAC,  Oracle clusterware and ASM are installed in the different Oracle homes, and the Clusterware has to be  up before ASM instance can be started because ASM instance uses the clusterware to access the shared storage.  Oracle 11g R2 introduced the  grid infrastructure home which combines Oracle clusterware and ASM.  The OCR and votingdisk of 11g R2 clusterware can be stored in ASM.  So it seems that ASM needs the clusterware up first to access the shared storage  and the clusterware needs ASM up first before it can access its key data structure: OCR and votingdisk.  So really clusterware and ASM, which one needs to be up first, and which one has to wait for other? This seemed to be the chicken or the ego problem.

 Oracle’s solution to this problem is to combines  the clusterware and ASM  into a single Grid Infrastructure home and  comes up a  procedure with  a complex  start up sequence which  mixes  the different components of clusterware and ASM  instance in order.  Oracle Metalink note 11gR2 Clusterware and Grid Home – What You Need to Know [ID 1053147.1] gave the following  startup sequence:

Although the clusterware startup command  $GI_HOME/bin/crsctl start crs follows this sequence to bring both clusterware and ASM online, but this command really doesn’t echo back each milestone of the startup process and we really can’t see how the startup was done.  A workaround is to look at the some of outputs  of root.sh command during the initial Grid infrastructure installation process as follow:

CRS-4123: Oracle High Availability Services has been started.

ohasd is starting

CRS-2672: Attempting to start ‘ora.gipcd’ on ‘owirac1’

CRS-2672: Attempting to start ‘ora.mdnsd’ on ‘owirac1’

CRS-2676: Start of ‘ora.mdnsd’ on ‘owirac1’ succeeded

CRS-2672: Attempting to start ‘ora.gipcd’ on ‘owirac1’

CRS-2676: Start of ‘ora.gipcd’ on ‘owirac1’ succeeded

CRS-2672: Attempting to start ‘ora.gpnpd’ on ‘owirac1’

CRS-2676: Start of ‘ora.gpnpd’ on ‘owirac1’ succeeded

CRS-2672: Attempting to start ‘ora.cssdmonitor’ on ‘owirac1’

CRS-2676: Start of ‘ora.cssdmonitor’ on ‘owirac1’ succeeded

CRS-2672: Attempting to start ‘ora.cssd’ on ‘owirac1’

CRS-2672: Attempting to start ‘ora.diskmon’ on ‘owirac1’

CRS-2676: Start of ‘ora.diskmon’ on ‘owirac1’ succeeded

CRS-2676: Start of ‘ora.cssd’ on ‘owirac1’ succeeded

CRS-2672: Attempting to start ‘ora.ctssd’ on ‘owirac1’

CRS-2676: Start of ‘ora.ctssd’ on ‘owirac1’ succeeded

CRS-2672: Attempting to start ‘ora.asm’ on ‘owirac1’

CRS-2676: Start of ‘ora.asm’ on ‘owirac1’ succeeded

CRS-2672: Attempting to start ‘ora.crsd’ on ‘owirac1’

CRS-2676: Start of ‘ora.crsd’ on ‘owirac1’ succeeded

CRS-2672: Attempting to start ‘ora.evmd’ on ‘owirac1’

CRS-2676: Start of ‘ora.evmd’ on ‘owirac1’ succeeded

CRS-2672: Attempting to start ‘ora.asm’ on ‘owirac1’

CRS-2676: Start of ‘ora.asm’ on ‘owirac1’ succeeded

CRS-2672: Attempting to start ‘ora.OCRVOTDSK.dg’ on ‘owirac1’

CRS-2676: Start of ‘ora.OCRVOTDSK.dg’ on ‘owirac1’ succeeded

CRS-2672: Attempting to start ‘ora.registry.acfs’ on ‘owirac1’

CRS-2676: Start of ‘ora.registry.acfs’ on ‘owirac1’ succeeded

This  sequence shows  the   ASM instance startup  is just one step in middle of  the entire sequence : Some of  CRS components such as CSSD, CTSS get started before ASM, while other components such as CRSD,  EVEMD, ACFS are up after the ASM starts.  This sequence can be also confirmed by the  timestamps and log messages in  clusterware log files  (alter<hostname>.log, cssd.log and crsd.log)  and ASM instance log like  alert_+ASM1.log . Here are the sequences of messages and their timestamps: during the startup of 11g R2 clusterware and ASM instance:

OLR service started  : 2011-01-17 14:33:13.678

Starting CSS daemon 2011-01-17 14:33:18.684:

Fetching asmlib disk :ORCL:OCR1 : 2011-01-17 14:33:24.825

Read ASM header off dev:ORCL:OCR3:224:256

Opened hdl:0x1d485110 for dev:ORCL:OCR1: 2011-01-17 14:33:24.829

Successful discovery for disk ORCL:OCR1 : 2011-01-17 14:33:24.837

Successful discovery of 5 disks: 2011-01-17 14:33:24.838

CSSD voting file is online: ORCL:OCR1:  2011-01-17 14:33:50.047

CSSD Reconfiguration complete: 2011-01-17 14:34:07.729

The Cluster Time Synchronization Service started:  2011-01-17 14:34:12.333

Note: ** CSSD and CTSSD got up before ASM .  Votingdisks were discovered  by reading the header of the ASM disks (OCRL:OCR1) of  the votingdisk diskgroup without using ASM instance **

Starting ASM: Jan 17 14:34:13 2011 

CRS Daemon Starting 2011-01-17 14:34:30.329:  

Checking the OCR device : 2011-01-17 14:34:30.331

Initializing OCR 2011-01-17 14:34:30.337

diskgroup OCRVOTDSK was mounted : Jan 17 14:34:30 2011

OCRVOTDSK was mounted : Mon Jan 17 14:34:30 2011

The OCR service started : 2011-01-17 14:34:30.835

Verified ocr1-5: 2011-01-17 14:33:50.128

Cluster Time Synchronization Service started:  2011-01-17 14:34:12.333

The OCR service started : 2011-01-17 14:34:30.835 

CRSD started: 2011-01-17 14:34:31.902

Note: CRS server started  after ASM is up and the diskgroup for OCR and votingdisks are mounted

From this sequence of the log message and timestamp, we get some understanding about the sequence of clusterware and ASM instance:

1)      CSSD and CTSSD are up before ASM

2)      Votingdisks used by CSSD are discovered by reading the header of the disks, not throught ASM

3)      Startup of CRS service has to wait until ASM instance is up and the diskgroup for OCR and votingdisk is mounted.

Oracle Openworld 2010 Beijing 2010 Experience.   2 comments

In 2010, for the first time, Oracle hosted three Oracle conferences in three continents:
Oracle Openworld 2010 San Franscio 2010 in Sept 19-23, Oracle Openworld 2010 Latina Americas 2010 in Sao Paulo in Dec 7-9th, Oracle OpenWorld Beijing 2010, Dec 13-16th.

After attending and speaking at Oracle Openworld in San Franscio, I was invited by Oracle Technology Network (OTN) and the  Oracle ACE program to give two technical presentations at Oracle OpenWorld Beijing 2010 conference:

  1) Case study: Implementing the Oracle Grid Computing for Multiple ERP Applications

  2) Oracle11g R2 Clusterware and RAC: Architecture , Configuration, Troubleshooting and Case study

My presentations were a part of Oracle Technology Network Loung , which combined the presentations of other ten top Oracle technologists (Oracle ACEs and Oracle ACE Directors)in the China Oracle community.  The entire OTN lounge presentation schedule is listed here.   This was my first time to meet and have joint efforts with these great Oracle talents in China. I really enjoyed working and networking with  them.

Uploaded some photos taken during the conference:

Conference location: China National Convention Center in Beijing

OOW Beijing confernece site: China National Convention Center

Welcome Keynote  by Steve Au Yeung | Executive Vice President, Asia Pacific, Oracle

Meet Oracle Technologists in China Oracle community

UKOUG Technology and E-Business Suite Conference Experience   Leave a comment

On Novemeber 29-December 1st 2010, I was invited to attend UKOUG Technology and E-Business Suite Conference    and give a technical presentation at the conference.   UKOUG (UK Oracle User Group) is one of the  largest Oracle  user groups in Europe.  UKOUG has been offerring its members conferences for over 20 years. This conference event was dedicated for the Oracle Technology & E-Business communities.  The conference was held in International Convention Centre (ICC), Birmingham, UK.

My technical presentation title  was ” Oracle E-Business Suite: migration to Oracle VM Template Based Deployment”.  As we know,  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.  The technical presenation examined some best practices for such an migration and  also explored the method  to create and use the VM templates of customers’  own project specific Oracle E-Business systems for on-going project. On the end  of the presentation, I also covered 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.

My Recent Article Published in IOUG SELECT Journal   Leave a comment

My recent Oracle RAC Automated provisioning article”Automated Deployment of Oracle RAC using Enterprise Manager Provisioning Pack ” was published in IOUG SELECT Journal 2010 4th Quarter issue.  This article explored one of features provided by Oracle Enterprise Manager for the software lifecycle management: Autmated provisioning of software systems.  This feature  simplifies the Oracle RAC database deployment process by automating most  tasks of provisioing process. It  significantly improves the efficiency and accuracy and reduce the cost and technical challenges of massive Oracle RAC database deployments.  The pdf of the article can be found here:  Automated Deployment of Oracle RAC using Enterprise Manager Provisioning Pack