Archive for the ‘Oracle 11gR2’ Category

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.

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

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.

My Interview with VirtaThon Internet Radio   Leave a comment

On June 20, 2011, I was interviwed by Mr. Tariq Farooq, the host of VirThron Internet Radio of BrainSurface . The interview was broastcasted live and recorded at the following link:

The followings are the text of the interview. (Any views or opinions presented in this interview are solely those of the author and do not necessarily represent those of my employer or other companies  or the interview host)

Oracle ACE Director Kai Yu’s Interview with VirtaThon Internet Radio on Wednesday, June 22, 2011

Host: Tell us about your early/college/academic life.

Kai: I got my Bachelors degree and Masters degree of Computer Science in China and also receievd my second Masters degree of CS in US.  My interest has always been  on database related fields.

Host:How you got involved/started with Oracle.

Kai: In the early days of my career, I did some application development work with C++ and Oracle Call Interface(OCI). Around 1995, I started working on PL/SQL and Oracle database management, and moved to a full time DBA role. In 1997, I started working on some advanced Oracle database features such as Oracle Parallel servers on Digital Alpha cluster, then moved to Oracle on Sun during the time around 1999. In 2002, I started focusing on Oracle on x86/Linux platforms.

Host: Tell us about your evangelist activities as an Oracle ACE Director and what it takes to become one.

Kai: My evangelist activities include presenting at Oracle conferences in US and worldwide and publishing Oracle whitepapers and involving Oracle community activities such as user groups and sharing my experience by maintaining my Oracle blog. Definitely these activities really help my Oracle career as I learned so much from the community. And when Oracle evaluates an Oracle ACE director application, they really look at what the evangelist activities this individual has done in the past and what he/she continually commit to do for the community going forward.

Host: Tell us about your experiences being an author/blogger/speaker.

Kai: I started presenting at Oracle OpenWorld(OOW) 2006 and continued every year and completed  total 9 OOW presentations so far  and have 4 accepted for OOW2011. And I also did 11 presentation at the Collaborate, a few other international presentations in UKOUG Tech and EBS conference,  Scotland OUG conference and OOW Asia conference.  It is great to be a part of the Virtathon virtual conference speaker team. Writing Oracle whitepapers is another area. So far I authored  17 whitepapers. One of my presentation/whitepaper won the 2011 OAUG Innovator of year award. The topic was about how to virtualize Oracle E-Business Suite on Oracle VM.   I also actively maintain my Oracle blog. Next month I will join in OTN Latin America Conference tour to Brazil, Uruguay and Chile. On the conference tour, I will give two presentations in each country: 1) Configuring Oracle RAC on Oracle VM, 2)Oracle  11g R2 RAC best practices. And we are planning to have an Asia and Pacific tour after Oracle OpenWorld conference in October.

Host: Tell us about your company and your role there.

Kai: I work in Dell Oracle Solutions engineering lab as a senior engineer and architect. We have a very strong engineering team that tasks to architect and validate various Oracle solutions on Dell platform. We provide customers the best practices and the validated Oracle solutons with the entire technology stack including servers, storage, network, Oracle software. We publish our  results and whitepapers online. is where our team is located.  My company really values my work by granting me two company-wide awards from  company executives in 2008 and 2011 respectively. Before joining this team in 2006, I had been in  the Global Database Management team at Dell for more than six years. My focus areas have been Oracle RAC, Database, Oracle VM, Enterprise Manager, Oracle E-Business suite Technology stack.

Host: What is your favorite Oracle 11gR2 Feature?

Kai: The two of my favorite Oracle 11g R2 features are: Edition Based Redefinition and Database flash cache.   Edition Based Redefinition allows you to upgrade the database components of an application while it is in use., This can  minimize or eliminate the database downtime.  With this feature, to upgrade an application , you make a copy the database objects of the application,  then  you make the change changes while application continues to run the unchanged components. After ensuring the change is connect, you make changes  available to all users. 

Database flash cache or called smart cache adds the another layer to the traditional Oracle database two layers storage: database buffer cache and the disk storage.  Flash cache feature provides a transparent extension of the database buffer cache using solid state device (SSD).  If you see the disk IO performance bottom neck in your database, such as a recommendation of increasing  size of the buffer cache, db file sequential read in a top wait event in AWR report, adding flash cache using SSD as the middle layer of storage can significantly reduce the physical disk IO and reduce database query response time.

It is easy to configure: add SSD storage as a device into the database server (single node or RAC node), and configure two init.ora parameter: db_flash_cache_file  point to the device name of the SSD storage, db_flash_cache_size indicates the size of the SSD device. With this configuration, this SSD flash cache will acts as a Level 2 cache to the (Level 1) SGA.

 We can use this feature generic X86 platform without Exadata with SSD storage such as Fusion-IO card  Our team had produce a very good study using the fusion IO card on x86 64 platform. You can visit our website to download the whitepaper.

Host: What would you anticipate/foresee/want in the next generation of Oracle Database Server family of products?

Kai: Today I can see the database technology is also moving with the rest of IT industry. I would expect two areas that the  database server  needs to add more work on: how the database provides a better platform (database as service) for the cloud infrasturecture. This may be related to the workload management, general database management and  how the database works on a virtualized environment. The second area is how the  database works with tiered storages. As we know due to the huge gap between CPU speed and the storage performance, most database performance bottlenecks are on the storage side. SSD technology or the tiered storage is a solution to solve this problem. Oracle Database should leverage the SSD technology or tiered storages to improve its performance.

Host: If you could change/improve one part of Oracle Database Server, what would it be?

Kai: Two areas I just mentioned certainly can improve the database server. Of course there are many other areas too,.

Host: What are your favorite tips/tricks/recommendations that you would want to share with the audience as far as Oracle Best Practices are concerned?

Kai: One of areas that I can provide is how to configure the network and shared storage on Oracle VM virtual machine to run Oracle RAC. To configure the private network for the RAC installation, Oracle recommends to bound two network interfaces together. In Oracle VM environment, guest VMs (dom U) don’t have the physical network interface, instead they have to rely on the network interfaces on the VM server (Dom 0). The way to configure this is to bound the two private network interfaces in the VM server first, for example bond eth2 and eth3 to form a bond1 logical network interface , then create a Xen bridge based on bond1. Then we can build the virtual network interface eth1 in the guest VM using the Xen bridge. We can do the same for the public network bonding. I have the details on my OOW presentation.  Go to my Oracle blog to find the related whitepaper and the conference presentation. 

Host: What advice do you have for our audience to stay in demand and ahead of the curve?

Kai: Today as the technology has progressed in such a fast pace, it is not easy to stay in demand and ahead of the curve. We have to put ourselves in learning mode all the time. It is not a very good idea to stay in your comfortable zone for too long. I have seen some companies or DBAs staying  the same system configuration for many years, not so good for the business and very bad for our technical career. The best learning opportunity is to implement the new features in your system. Other advice is to attend the industry conferences regular to get the updates on the technology, read other people blogs/OTN forms and use google  to search for answers. VirtaThon virtual conference is one of the great examples that enable your remote learning.

Host: Please tell us about VirtaThon and your role there?

VirtaThon is a virtual conference facility for Oracle, Java & MySQL communities. From here you can attend, participate & learn cutting edge knowledge from recognized domain experts from all over the world. When this idea was first implemented by our pioneer and leader Mr. Tariq Farooq, I was so amazed.  This virtual conference facility really helps us to learn new knowledge in a most convenient way. I was so fortunately to be invited to join the speaker team as well as the conference advisor committee , a sort of geeks team behind of the VirtaThon virtual conference facility.