Archive for the ‘Oracle 11g R2 RAC’ Category

Oracle OpenWorld 2013 Call for Papers Just Open Today!   Leave a comment

Oracle just announced the  Oracle OpenWorld 2013 call for papers  today!

The call for papers will last about one month and close at Friday, April 12, 11:59 p.m. PDT.  For those of us who want to share their experences and technology inovation at this biggest information technology event in the world, we need to come up some topics and submit to the conference commitee by the April 12th deadline. Since 2006 Oracle OpenWorld when I gave  my very first presentation at this event, I have been very fortune to speak at the conference 16 times. I look forward to having another year to continue my contributions to the conference. 

I listed all  of my previous Oracle OpenWorld presentation for reference.  Here I want to thank the people who also contributed to these presentations including my co-speakers of some sessions, and the conference commitee who gave me the opportunity to present and the audiences who participated and supported me during the presentations.

16.  Oracle on Oracle VM: Expert Panel,  Oracle OpenWorld 2012

 15:  High-Availability Infrastructure of the Database Cloud: Architecture and Best Practices, Oracle OpenWorld 2012

14:  Simplify App Deployment in the Cloud with Virtual Assemblies and Oracle Enterprise Manager 12c, Oracle OpenWorld 2012

 13. Configuring and Managing a Private Cloud with Oracle Enterprise Manager ,Oracle OpenWorld 2011

 12.  Upgrading Oracle Enterprise Manager, Using Best Practices , Oracle OpenWorld 2011

11. Consolidate Oracle E-Business Suite Databases in Oracle Database 11g Release 2 Grid: Case Study, Oracle OpenWorld 2011

10. Ensure the High Availability and Stability of Oracle RAC: Storage and Network Side Story ,Oracle OpenWorld2011

9. Oracle11g R2 Clusterware and RAC: Architecture , Configuration, Troubleshooting and Case study, Oracle OpenWorld Beijing 2010,

8. Oracle RAC on Oracle VM Automated Provisioning with Enterprise Manager 11g , Oracle OpenWorld 2010 

7.  Monitoring and Diagnosing Oracle RAC Performance with Oracle Enterprise Manager. Oracle OpenWorld 2010,

6. Oracle E-Business Suite on Oracle RAC and Oracle VM: Architecture and Implementation, Oracle OpenWorld 2009

5. Building an Oracle Grid with Oracle VM on Dell Blade Servers and EqualLogic iSCSI storage, Oracle OpenWorld 2009

4. Provisioning Oracle RAC in a Virtualized Environment, Using Oracle Enterprise Manager, Oracle OpenWorld 2009

3. Case Study: Implementing the Oracle Grid Computing on Dell Hardware for Multiple  ERP Applications, Oracle OpenWorld 2008

2. Automatic Oracle RAC Deployment and Implementing MegaGrid using Oracle EM Provisioning Pack, Oracle OpenWorld 2007

 1. Implementing Oracle Applications 11i on 10g RAC and ASM, Oracle OpenWorld 2006

My Experiences with Oracle Cloud and Oracle VM technology   9 comments

It was a great honor for me to recieve the  industry prestigeous award “2012 Oracle Excellence Award: Technologist of the Year for Cloud Architect  ”  from Oracle Mazgine. Although I received this award at Oracle OpenWorld 2012 in San Francisco in early Octorber 2012, the award was officially announced on the  Oracle Magzine’s January/Feburary 2013 issue . im08t0-awards-tech-yu-1875816 - Copy

My original backgroud was Oracle DBA and Oracle Applications DBA. My experiences was mainly  on managing large Oracle RAC databases and Oracle E-Business applications suite running on complex muitple nodes environment such an Oracle Grid.  In late 2008, as a part of addtional responsibilites of  my job, I  started  working on Oracle virtualization technology  specifically   Oracle VM  for X86-64 platform .  Since then Oracle VM has become of one of my favour technologies. Natually I started looking at the best practices of running and deployment Oracle RAC databas, Oracle E-Business  suite applications on the Oracle VM enviroment.  The Oracle OpenWorld 2009 confernece allowed me to give three presentation sessions about  my work on Oracle VM technology:

And the contents of these presentations were also published in three whitepapers:

In 2010, Oracle Introduced the Oracle E-Business Oracle VM template. I was working on  a  project  for which I needed  to  deploy Oracle E-Business Applications on Oracle VM environment . However I noticed that the Oracle EBS VM template downloaded from Oracle was a general template for the Oracle EBS vision instance. For the project, I needed to find out a way to virtualize the exisiting  production Oracle E-Business suite system that currently ran on the physical environment . That is the backround that I came up the solution to  migrate the Oracle EBS suite t to a virtual environment. As a result of the project, I put toegther a whitepaper about this solution:

and also presented this solution at several Oracle conferences:

I also worked on provisioning database and applications using Oracle Enterprise Manager’s Software library and provisioning procedures  It can be considerred the early version of Oracle Cloud application provioning methods. Built in with Oracle Enterprise Grid control 10g, this  method can  quickly provision multiple node Oracle 10g RAC . Some of the early projects were presented at Oracle OpenWorld and Collaborate conferences:

As a  part of Oracle Enetrprise Manager 12c cloud beta efforts, I worked with Oracle EM12c product engineers and product managers on a Dell | Oracle joint Oracle cloud project. This project aimed to architect and implement a privare cloud solution based on Oracle VM and managed by Oracle Enterprise Manager 12c.  By importing Oracle VM templates into the Oracle Enterprise Manager 12c’s software library, on this project we were able to  implement  the self service provisioning of applications  in the Oracle cloud environment using Oracle VM templates. The result of this project was presented at Oracle OpenWorld 2011, right after Oracle officially announced Oracle Enetrprise Manager 12c, total cloud control solution. 

In 2012, as Oracle released new version of Oracle VM 3.0, we upgraded this cloud  to Oracle VM 3.1.1 and implemented the self provisioning multiple tier applications   using Oracle virtual assembilies. the newer version of Oracle cloud was presentated at Oracle Openworld 2012:

Another area I have worked on is the Oracle database cloud based on Oracle RAC technology with or without Oracle VM:

These are some of presentations that  I have given on this area:

2012 Kai Yu’s Oracle Activities Summary   4 comments

Today is the last day of year 2012 and maybe  be the best time to summarize my Oracle related activities in the year.

In 2012, I  have  focused on the following technologies:

  1. Optimizing Oracle database performance using Solid State Drive, specifically the PCIe Flash SSD.
  2. Oracle RAC on Oracle Linux 6.x and Red Hat Linux 6.x
  3. Oracle VM 3.11 and Oracle VM Manager 3.1.1
  4. Oracle Enterprise Manager 12c
  5. Oracle Infrastructure Cloud
  6. Oracle Virtual Assemblies and Oracle Virtual Assembly Builder.

As the result of the research and study on these areas, I wrote these five technical whitepapers:

1.  Optimizing OLTP Oracle Database Performance using Dell Express Flash PCIe SSDs, Dell TechCenter Blogs, July 31st, 2012

2. Virtualizing Oracle E-Business Suite  through  Oracle OVM , Modified version of the Original conference whitepaper Oracle E-Business Suite: migration to Oracle VM Template Based Deployment.

3.  Configuring and Managing a Private Cloud with Oracle Enterprise Manager 12c,  IOUG Collaborate 12 Conference whitepaper, April ,  2012.

4. Virtualizing Oracle 11g/R2 RAC Database on Oracle VM 3.0: Methods/Tips, IOUG Collaborate 12 Conference whitepaper, April ,  2012.

5. Virtualizing Oracle 11g/R2 RAC Database on Oracle VM 2.2: Methods and Tips, published in IOUG SELECT Journal Q, 2012 issue.

And I also gave 16 technical presentations on several  technical conferences  including Collaborate 12 (C#12), Oracle OpenWorld 2012(OOW12), Oracle Technology Network Architect Day keynote , EMEA OUG Harmony 2012 , OAUG Connection Point®–Oracle E-Business Suite Release 12.1 and Fusuon applications in Austin, , OTN Expert+ Conference @NUCES/FAST, 2012 East Coast Oracle Users Group  Conference (ECO#12) , IOUG Virtualization SIG – Online Symposium

  1.  Enterprise Manager 12c Cloud Control: New Features and the Best Practices for Installation, Configuration and Upgrade of Enterprise Manager 12c, C#12,
  2. Virtualizing Oracle 11g/R2 RAC Database on Oracle VM 3.0: Methods/Tips, C#12,
  3.  Alternative options to enhance the High Availability, session #840 (HA bootcamp), C#12,
  4. Configuring and Managing a Private Cloud with Oracle Enterprise Manager 12c, C#12
  5. High Availability Infrasturcture for Cloud Computing,  OTN ArchDay Keynote
  6. Oracle 11g R2 Clusterware: Architecture, Configuration, Troubleshooting,  EMEA#12, Finland, 
  7.  Oracle E-Business Suite: Migration to Oracle VM & template based deployment,   EMEA#12, Finland, .
  8.  Oracle E-Business Suite: Migration to Oracle VM & template based deployment,  EMEA#12,  Latvia. 
  9. Configuring and Managing a Private Cloud with Enterprise Manager 12c , IOUG Webinar
  10.  Oracle on Oracle VM: Expert Panel,  OOW12
  11. High-Availability Infrastructure of the Database Cloud: Architecture and Best Practices, OOW12
  12. Simplify App Deployment in the Cloud with Virtual Assemblies and Oracle Enterprise Manager 12c, OOW12
  13. Oracle VM &  Cloud Computing 360 Degrees,  OTN Expert+ Conference @NUCES/FAST
  14. Virtualizing Oracle E-Business Suite through Oracle VM,  ECO#12
  15. Simplifying Application Deployment in Cloud Using Virtual Assemblies and EM 12c, IOUG vSIG
  16. Oracle on Oracle VM – Expert Panel, IOUG vSIG

In last few months of the year, my focus has been on the new Apress Oracle book “ Expert Oracle RAC” which I co-author with three  industry well-known RAC experts and Oracle ACE directors: Syed Jaffar Hussain, Riyaj Shamsudeen  and Tariq Farooq . I have been working on  the contents including RAC architecture overview, Storage and ASM, Clusterware, Network,   Application Design Issues , Challenges in a Complex RAC Environment.

At Oracle OpenWorld 2012, I was granted the industry prestigious award: 2012 Oracle Excellence Award : Technologist of the Yeafor Cloud Architect by Oracle Magazine.   This award will be officially announced  on Oracle Magazine ‘s January/Feb 2013 issue.

My Speaking Topics at Oracle OpenWorld 2012   2 comments

Oracle OpenWorld 2012 is just around the corner.  This is my 7th consecutive year of speaking at this world largest  IT event.  This year my presentations are related to high availability, database cloud, Oracle virtualization and deploying Oracle virtual assemblies in a self service cloud environment.  The followings are my speaking sessions:

  1. 1. UGF7700 – Oracle on Oracle VM: Expert Panel,  Sunday Sept 30, 12:30pm-2:00pm, Moscone West- 2012.

On this panel  I will share some experience of configuring  an Oracle VM virtual infrastructure and  an infrastructure cloud based on commodity hardware with Oracle VM3.1.1 and Oracle Enterprise Manager 12.1.

2.  CON3875 – High-Availability Infrastructure of the Database Cloud: Architecture and Best Practices, Monday Oct 1, 3:15pm-4:15pm,  Moscone West- 3020

This session will start with the architecture design and then discuss various techniques and options for achieving high availability including  Oracle Clusterware/Oracle Real Application Clusters (Oracle RAC), Oracle Data Guard, and Oracle Maximum Availability Architecture. Then it will explore the configuration best practices for ensuring fault tolerance of the entire stack of the infrastructure. It will also cover the methods for reducing downtime during events such as system upgrades and migration and how to do  troubleshooting during system outages.

3. CON5206 – Simplify App Deployment in the Cloud with Virtual Assemblies and Oracle Enterprise Manager 12c, Wednesday, Oct3, 5:00pm-6:00pm Moscone south- 307

In this session I will share some experience from my Infrastructure cloud project that I have been working in  last few months. I  will start with how to create an Oracle virtualization assembly with Oracle Virtual Assembly Builder 11g Release 1  in the following process:

Then I will discuss the configuration of a self-service cloud  based on  Oracle EM12c and Oracle VM 3.1.1 and how to simplify  application deployment with Oracle virtual assemblies  in the self-service cloud  in the process shown below:

My Technical Pesentations at EMEA OUG Harmony Conference   1 comment

On May 30-June 1st, I was invited to present  at 3rd EMEA OUG Harmony conference. The conference was held on two locations:  at Aulanko, Hameenlinna , Finland on May 30-May31 and Riga , Lativa on June 1st. My presentations at Finland conference were 1) Oracle11g R2 Clusterware: Architecture and Best Practices of Configuration and Troubleshooting; 2) Oracle E-Business Suite: Migration to Oracle VM Template Based Deployment, while my presentation at Lativa conference site was Oracle E-Business Suite: Migration to Oracle VM Template Based Deployment. 

The session “Oracle11g R2 Clusterware: Architecture and Best Practices of Configuration and Troubleshooting” aimed to provide DBAs some practical understanding and best practices of 11g R2 RAC infrastructure that are crucial to the stability and scalability of the RAC database. In this session I started with some technical discussions on the architecture of 11g R2 Clusterware and ASM; then focused on the shared storage and ASM best practices for OCR/voting disks, ACFS and RAC database files. I  spend some time on configuration of SCAN IP, GNS service and the private interconnect. At the end, I  covered some tips and the diagnostic tools for troubleshooting clusterware issues such as node eviction . Presentation slides can be downloaded from here:

The session “Oracle E-Business Suite: Migration to Oracle VM & template based deployment ” discussed the a newly developed method to migrate an existing Oracle E-Business system on physical servers to a virtual environment 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 discussed 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. The methods mentioned in this presentation won the 2011 OAUG innovator of the year award.The presentation slides can be downloaded here  for Finland conference and here for Lativa conference.

A great highlight of attending  OUG EMEA Harmony 2012 conferencde  was to meet the legendary relational database researcher and author Chris J Date. I took the photo below while Chirs J Date was giving his keynote presentation “Missing Information”:

Interview with Andrew Younger in IOUG about Collaborate 12 IOUG High Availability Boot Camp   1 comment

I was tasked by IOUG to organize the IOUG High Availability Boot Camp at Collaborate 12 conference. Today (March 19, 2012), I had an interview with Andrew Younger in IOUG  to talk about the contents/topics on the High Availability boot camp. Here are the QAs of the interview:

Andrew: For whom are your sessions designed? (Who will get the most value out of them?)

Kai: As one of the IOUG educational Boot Camps at Collaborate 12 conference, the High Availability or HA boot camp runs on Monday and Tuesday. Why do we need two days, because High Availability is very critical for today’s IT system, and it has been also very challenge to design a cost effective HA solution and implement it properly to meet the high availability requirement of SLA.  When we prepare for this boot camp, we have this goal in mind that we want to provide a good coverage of related technology and tips and tricks for the DBAs and architects or DBA managers who are looking for the advices and best practices for the high availability solutions of their Oracle database environments.

Andrew: What is the main focus of your sessions – do they address a specific problem or introduce an innovation?

Kai : In this two day boot camp, we total have 11 sessions presented by Oracle ACE/ACE directors, as well as other industry well known speakers who are recognized for their expertise on their areas.  Through their presentations, the speakers are going to share their tips and tricks and lessons learned on their chosen topics. 

These 11 sessions including 9 one hour sessions and 2 x 30 minute sessions, cover several Oracle HA related topics  such as Data Guard, backup and recovery, RAC, RAC one Node, Oracle VM and GoldenGate,  as well as the case studies of how to use these technology to achieve high availability in real world.  Each of session will be presented independently. Attendees can choose any of them based on their interest. They also can go the IOUG website’s collaborate 12 boot camps tab and click the High Availability tab  to see the list of the sessions and the  schedules, titles and speakers:

 Andrew: What are the main points of learning that attendees will take with them back to their own work?

Kai: As a reviewer, I had a privilege to preview all the presentations contents and found a lot contents were based on  real world practical experiences. The attendees can really leverage these course contents for a comprehensive learning experience. Without going too detail of each session, I would like to highlight some of the topics from this Boot Camp.

Session #544 by Syamal Bandyopadhyay will explore an overview of the various High Availability solutions and the considerations to design a cost effect HA solution for business and how they are used in good size IT department.

We will have two Data guard centric sessions #334 and #649:   Session #334 by  Manoj Machiwal will focus on how to leverage the Active Data Guard feature to utilize the secondary site for reporting purposing. Session #649 by Bonnie Bizzaro  will discuss the best practices of configuring data guard for a RAC database using data guard broker.

Session #184 by Dong  Wang  is about the features and best practices of the latest GoldenGate v11 and some of the common use cases. 

We will have two sessions focusing on backup and recovery. Session #711 by Oracle ACE Yury Velikanov will Shared his experience and lessons learned from his RMAN backup scripts auditing and how to eliminate the errors in your the backup process so that you can ensure the recoverability under stress. Session #492 by Oracle ACE Nelson Ariel Calero will talk about the Important Hidden features in RMAN , tips and tricks  and sample code in command line interface ,Troubleshooting, and debugging techniques, practical examples, optimization techniques.

 We have allocated three sessions to explore the technology to achieve server high availability such as Oracle RAC, RAC one and Oracle VM. Session #548 by Tom Reddy will discuss a 16 node Oracle 11gR2 RAC configuration case study,; session #373 by Leighton Nelson  will discuss some of the RAC diagnostic tool and how to use these utilities for RAC trouble shoot and diagnose problem in RAC system. Session #840 by Oracle ACE director Kai Yu will discuss other cost effective options to achieve server HA such as RAC One Node and Oracle VM

 Finally we have two case studies sessions to discuss how to reduce the planned downtime due to system upgrade and migration. Session 371 will go through a case study of migrating a system from a single Instance to RAC and also to upgrade from to up with minimal downtime using Data Guard. Session #633 by Oracle ACE director Tariq Farooq will get a 360-degrees deep-dive along with tips & tricks, recommendations, best practices, gotchas & lessons learned, on how to do online migration of  a Single-Server Single-Instance Oracle Database to Oracle Real Application Clusters (Oracle RAC) with Oracle Streams and Oracle Data Pump with almost zero downtime.

 In summary, this two days high availability boot camp is designed to cover several major areas related to Oracle database high availability. This can be a great opportunity for speakers and colleagues to share their experience and learn each other. That also can be a great network opportunity and I would expect that more  extensive knowledge sharing will also continue after the boot camp.

IOUG Virtualization Presentation Recording and Questions and Answers   Leave a comment

On Sept 21, 2011, Saar Moaoz from Oracle RAC Pack Team and I co-
presented an IOUG Virtualization online education session:
“Virtualizing Oracle 11g/R2 RAC Database on Oracle VM: Methods/Tips.”
This presentation was based on Oracle VM 3.0 technology, which was
released a few weeks before this presentation. After the presentation,
we have recieved a few questions about Oracle VM and RAC. Both of Saar
and I provided the answers for these questions. IOUG has posted the
QAs and the actual presentation video recording on IOUG IOUG Webinar
Archieve. I copied some of these quesions and answers as follow. For
more details and the actual presentation recording, please visit this link. You also can download the presentation pdf here.

Copy of the some Questions and Answers:

Q: Is there any written tutorials/white papers on how to setup a RAC
on an Oracle VM?
A: To use the RAC OVM Templates, For whitepaper on RAC/OVM: RAC support on Vmware, it is supported, just not certified, see My
Oracle Support Note:

Q: Is it supported to increase the size of System.img file (plenty of
approaches is available in the internet), since it is based on block
device and not LVM, which could eliminate this problem?
A: Yes, the templates are a starting point, you are welcome to tune/
tailor them further to your environments.

Q: Why should in production support template shared disk be on a local
disk? How different node from multiple host can access them?
A: Test deployment allows a special case, where the DB files are on
localdisks, in that case all VMs forming the cluster must run on the
same Dom0/OVS server. For production, shared disks must be used and
accessible from all Dom0/OVS Servers. “lsinventory” output is available
inside the zip file of each template, no need to create a VM, simply
unzip and look at lsinventory output.

Q: Can RAC on VM use ASM instead of OCFS?
A: RAC inside the guests uses ASM, not OCFS2. On Dom0, for the
repository, OVM may use NFS or OCFS2, but this places only the
OS/Oracle VM files, not the database which is in ASM as said before.

Q: Will there be an OVM setup for RAC One Node?
A: The current RAC OVM Templates support RAC ONE NODE. Simply follow
note# 1232802.1. Create a service, then use the convert database
command. Note the troubleshooting section at bottom of that article.

Q: Does the template work when you deploy virtual images on different
physical boxes and club them as nodes in RAC implementation?
A: Yes, the templates work for production (where each VM is on different
Dom0),or for test (where some or all VMs may be on same dom0).

Q: Installation instruction for installing RAC11g2 under OVM3?. pdf files
are for ovm 2.
A: The basic steps are the same. Import the template w/Manager, create
the VMs, attach shared disks, adjust CPU/Memory. The only catch is to
remove the xenbr0/1 on the template and map it to the bridge names in
OVM3. We will have a reference document to highlight only these
differences in some time.

Q: Do I need to install OVM 3.0 before I start applying my VM
templates for RAC database?
A: Yes. You need to install Oracle VM servers and VM manager
and configure the virtual infrastructure before using VM template.

Q: I am not clear how to proceed if I have bare bone server
A: Here is an outline of the steps.
1. Install Oracle VM server,
2. Install Oracle VM manager
3. Configure shared storage and networks on VM servers
4. Download and import the VM templates including RAC VM
5. Create VMs using templates
6. configure the virtual networks and virtual storage on VMs
7. following the step given by Saar to configure RAC on the
VMs. The first part of the presentation covers the virtual
infrastructure configuration (step 1-6) .