My Speaking at this year’s Oracle OpenWorld   Leave a comment


At this year Oracle OpenWorld 2015, I will be presenting a technical session at 12pm of Sunday Oct 25. This session is about how to design and implement a Self-Service Enabled Private Cloud with Oracle EM12c,. The session information are in follow:

Session ID: UGF9927

Session Title: Design and Implement a Self-Service–Enabled Private Cloud: Oracle Enterprise Manager 12c

Date and Time Sunday, Oct 25, 12:00 p.m.

Venue/Room: Moscone South—254

Since the  first time in 2006 when Oracle OpenWorld accepted my paper “Implementing Oracle Applications 11i on 10g RAC and ASM“,  I have presented  or co-presented  total 28 technical sessions/ or panels in 11 Oracle OpenWorld conferences (in 2010, I presented at both Oracle OpenWorld Aisa and Oracle OpenWorld SFO). The presentations cover several  several Oracle technology areas such as Oracle Cloud, Oracle VM, Oracle RAC/Oracle database, Oracle Business Intelligence, Oracle Enterprise Manager, etc. The following are the list of these Oracle OpenWorld presentations.


28: Design & Implement Your Own Self-Service Enabled Private Cloud with Oracle EM12c, Session ID: UGF9927, Oct 25, 12:00 p.m

OOW 2014:

27 :Architect Your Data Center Infrastructure from Scratch, Session #ID: UGF9244, Sunday, Sept 28, 10:00am-10:45am

26: Implement and Manage IaaS and a Self-Service Portal with Oracle Enterprise Manager 12c Session ID: UGF3431: Sunday, Sept 28, 12:00am-12:45am

25: Leveraging New Oracle Database 12c Features to Reduce Storage Costs Session ID: CON5433: Thursday, OCT 9, 9:30am-10:15am, Moscone South – 310


24. Clustering/High Availability with Oracle VM and Oracle Enterprise Manager 12c: 360 Degrees [UGF9803] 2:00 PM

23. Cloud Computing, Oracle VM, and Oracle Enterprise Manager 12c Best Practices: Expert Panel [UGF9756] , Sunday, Sep 22, 2:15 PM – 3:15 PM

22. Oracle VM and Virtualization Best Practices: Expert Panel Discussion [UGF9809]  4:30 PM

21. Best Practices for Deploying Highly Scalable Virtualized Oracle Applications [CON11257] , Speakers: Monday, Sep 23, 4:45 PM – 5:45 PM

20. Configuring Database Cloud with Oracle Database 12c on Dell Blades: Methods/Tips session ID: [CON11220] Monday, Sep 23, 3:15 PM – 4:15 PM

19. Accelerating OLTP Databases with Flash-Based Storage: Case Studies Session ID: [CON11235]  Tuesday, Sep 24, 10:30 AM – 11:30 AM


18. Oracle on Oracle VM: Expert Panel,  Session ID: UGF7700 –,  Sunday Sept 30, 12:30pm-2:00pm,

17:  High-Availability Infrastructure of the Database Cloud: Architecture and Best Practices, Monday Oct 1, 3:15pm-4:15pm,  session #CON3875

16:  Simplify App Deployment in the Cloud with Virtual Assemblies and Oracle Enterprise Manager 12c, Session #CON5206 –


15 Configuring and Managing a Private Cloud with Oracle Enterprise Manager , session#06980, Tuesday, 05:30 PM 

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

13. Consolidate Oracle E-Business Suite Databases in Oracle Database 11g Release 2 Grid: Case Study, session#0845, Tuesday, 10:15 AM

12. Ensure the High Availability and Stability of Oracle RAC: Storage and Network Side Story ,session #09385, Sunday, 01:30 PM

 OOW2010 Beijing:

11.Oracle11g R2 Clusterware and RAC: Architecture , Configuration, Troubleshooting and Case study

10. Case study: Implementing the Oracle Grid Computing for Multiple ERP Applications


  1. Oracle RAC on Oracle VM Automated Provisioning with Enterprise Manager 11g ,  Session ID: S316318.

8. Monitoring and Diagnosing Oracle RAC Performance with Oracle Enterprise Manager, Session ID:S316263


7. Oracle E-Business Suite on Oracle RAC and Oracle VM: Architecture and Implementation

6. Building an Oracle Grid with Oracle VM on Dell Blade Servers and EqualLogic iSCSI storage

5. Provisioning Oracle RAC in a Virtualized Environment, Using Oracle Enterprise Manager


  1. Case Study: Implementing the Oracle Grid Computing on Dell Hardware for Multiple  ERP Applications


3. Implementing Oracle E-Business Suite R12 Through 11i to R12 Upgrade

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


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

Posted October 21, 2015 by kyuoracleblog in Uncategorized

High Performance Oracle Database with the Dell Acceleration Appliances for Databases   Leave a comment

The performance of many business critical applications like Oracle database is often limited by bottlenecks in the infrastructure components—CPU, memory, network, and storage. Although CPU, memory, and network performance has improved dramatically over time, storage performance improvements have lagged due to the limitations of latency and throughput.
The Dell Acceleration Appliances for Databases (DAAD) combines Dell servers with Sandisk’s flash storage technology to significantly improve storage latency and throughput. The appliance provides an adaptable, flexible, highly available, and scalable storage solution to various IT organizations’ database implementation. The Oracle RAC database on the DAAD delivers the highly available and high-performance database solution to business critical applications

Dell Acceleration Appliances for Databases (DAAD) Overview:
The Dell Acceleration Appliances for Databases (DAAD) is a pre-built, pre-integrated appliance designed to accelerate leading database environments such as Oracle Database. This appliance combines Dell PowerEdge R720 Server, Dell networking, and ioMemory cards and ION Accelerator software from Fusion-io to improve database performance.
DAAD Architecture:
High-level appliance architecture:
• The appliance is built on the industry leading Dell PowerEdge R720 server.
• The appliance supports high-speed Fibre channel or iSCSI networking between database servers and the
appliance nodes.
• Each appliance node is equipped with four cards, each of which has 3.0TB of usable, persistent flash storage
in the PCIe slots of the R720 server. These cards are also known as ioMemory cards.
• The ION Accelerator software installed on each appliance node enables management and configuration including
• For High Availability, the ION HA Clustering configuration consists of a pair of two appliance nodes
connected with a private 40GbE point-to-point Interconnection network. The appliances provide
scalability across multiple appliance nodes or multiple pairs of HA Clustered appliances.


Oracle RAC Database Reference architecture based on Dell Acceleration Appliances for Databases

To ensure the high availability of the infrastructure, it is recommended that network and storage IO paths are redundant. The following diagram shows the architecture of Oracle RAC database implementation based on DAAD as the shared storage.

The whitepaper that I co-authored with two other engineers in my team last July describes the reference architecture of an Oracle database and DAAD pairing, and showed the analysis of performance improvement of the Oracle database based on this architecture. The solution described in this whitepaper here is a high-availability-enabled, two-node appliance that uses the Fibre Channel storage protocol. Each appliance node is comprised of a Dell PowerEdge R720 Server, four 3.0TB ioMemory flash cards with the ION Accelerator software installed, and high availability ION clustering enabled. The highly available two-node appliance solution provides 12TB of redundant tier-1 storage capacity with a total of 24TB of raw storage capacity. The storage appliance delivers over 1 million random read IOPS with 0.5 millisecond latency for 4k random read which equates to 27 times the IOPS and 4% of the latency that 96x 15k conventional drives can provide. On HammerDB’ s TPC-C-like performance studies, the four-node Oracle RAC database on the two-node appliance can deliver 960,000 peak New Orders per Minute (NOPM) and over 2.5 million Transaction Per Minute (TPM).

To see my other technical white papers, please refer to the publication table of this Oracle blog:

Posted May 26, 2015 by kyuoracleblog in DAAD, Fusion IO, Oracle RAC, Sandisk

My Upcoming Presentations at Collaborate 15 Conference   Leave a comment

At the upcoming Collaborate 15 conference (April 12-April 16), I will be giving three technical presentations and joining a technical panel as panelist. The presentation schedules and abstracts are listed as follow:

1. Optimize Oracle BI with Oracle 12c in-memory Database option
OAUG presentation, session #10502, Track: Business Analytics
April 13, Monday 12:45 PM – 1:45 PM | Room Jasmine C

Abstract: By adding the in-memory columnar-store feature, the recently released In-Memory Database option is designed to significantly improve query performance for OLAP application. This presentation will explore how to leverage this In-Memory feature on the Oracle OBIEE analytics environment. This presentation will use an financial analytics project as a case study to explore the best practices, lesson learned, performance studies of applying In-Memory database in the business analytic applications.
Session link:

2. Design and implement your own self service Enabled Private cloud with Oracle Em12c

IOUG presentation and virtual session: session #464, Track: Cloud Computing
April 14, Tuesday 2:00-3:00pm| Room: Palm D
Abstract:: Today when IT organizations plan to deploy Oracle database and applications in cloud, they may look at either using Oracle public cloud service or building their own private cloud. For those who would prefer to building and hosting their own private cloud, there are a quite few Oracle technologies that are designed for this purpose. This session will discuss some of these technologies and methodologies that Oracle used to build the Oracle public cloud: Oracle EM12c cloud management, self-service portal and Oracle Virtual Assemble Builder (OVAB). Using a case study as an example, this session will show how to design and build your private cloud with these technologies and to show how to implement the important cloud service: application self-service provisioning which is featured in Oracle public cloud.
Session Link::

3. Zero to 100MPH at the speed of cloud employing Oracle database on public cloud
IOUG presentation and Panel with panelist, session #530, panelists: Charles Kim, Kai Yu,Tariq Farooq
Track: Cloud Computing
April 15, Wednesday 9:15am-10:15am | Room: Reef F

Abstract: The Expert Panelists/Speakers will present a comprehensive overview of the Oracle Database Cloud Service offerings by covering Best Practices, Experiences, Insight, Tips and, a whole lot more about employing/deploying the Oracle Database Server family on Oracle’s Public Cloud.
Session link::

4. Implementing oracle database 12c heat map and automatic database optimization for database storage performance and cost
IOUG presentation and virtual session: session #464, Track: Cloud Computing
April 15, Wednesday 3:15-4:15pm | Room: Palm A

Abstract: While SSD (Solid State drive) based storage significantly improves the database performance by removing the storage IO bottlenecks, the cost of SSDs is still much higher than ones of regular spinning disks. As a cost effective way to leverage SSDs performance, the Storage tiering method stores those active data in high performance SSD storage and store those less or inactive data in low speed conventional spinning storage. While the store tiering methods is usually implemented on the storage level and setup by the storage admin, Oracle 12c Heat Map and Automatic Data Optimization (ADO) together called Information lifecycle Management (ILM) provide a great way for DBAs to automate the storage tiering for database segments on database level . This session will show the steps and method by which DBAs can use to implement these Oracle 12c features to automate the compression of database segments as well as movement of them to another tier storage based on the usage of the data.
Session link:

Upcoming IOUG Cloud Computing SIG Webinar: Oracle Multitenant: The Beating Heart of #DBaaS   1 comment

Title: Oracle Multitenant: The Beating Heart of #DBaaS
Featured Speaker: Debaditya Chatterjee, Product Manager for the Oracle Multitenant
Start time: Dec 09, 2014 01:00 PM America/Eastern
End time: Dec 09, 2014 02:00 PM America/Eastern
The tripod of Oracle database as a service (DBaaS) rests on the strong legs of Oracle Multitenant as the enabling database architecture; Oracle Enterprise Manager for orchestration; and Oracle’s engineered systems, such as Oracle Exadata and Oracle SuperCluster, as the consolidation platforms. This total solution from a single vendor is unmatched. This session explores in detail various key capabilities of the multitenant architecture that deliver on the promise of DBaaS today.

Please sign up this webinar on this registration Link:
For details, refer to IOUG webinar link:
Join the IOUG Cloud Computing SIG on
Kai Yu
Vice President of the IOUG Cloud Computing SIG
Oracle ACE Director

Dell announced its Integrated Solution for Oracle Database at OOW14   Leave a comment

 This is the project that I have been working on in last 6 months:

Dell announced Dell Integrated Solution for Oracle Database at OOW14: fully configured infrastructure for Oracle 12C RAC : 2XR920 servers(40 cores each) + FC based 12TB mirrored/24 TB raw Sandisk all flash storage array + network/OS ready :

Dell Integrated Solution for Oracle Database :

DSC08506      DSC08601

Posted October 5, 2014 by kyuoracleblog in Uncategorized

Why can’t I connect to my pluggable database?   Leave a comment

This afternoon one of my colleagues was having trouble connecting his database. He got the following error when he

tried to connect the application to the database:

ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

He logged to the database server host and found that the database instance was up and he was able to connect to the database instance :

SQL> connect system/password

But when he tried to connect to the application user  in a PDB:

[oracle@inmem2 ~]$ sqlplus  user1/user1pwd@app1_pdb

SQL*Plus: Release Production on Mon Sep 15 16:48:13 2014

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

Here is the troubleshooting part that I did:

check if the PDB is up:

sqlplus  / as sysdba

Connected to:
Oracle Database 12c Enterprise Edition Release – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options


NAME                           OPEN_MODE
—————————— ———-
PDB$SEED                       READ ONLY
APP1_PDB                      MOUNTED

So the APP1_PDB is only mounted not open although the instance is up and the container CDB is open.

So we need to open the PDB:


Pluggable database altered.

check the PDB open status:


NAME                           OPEN_MODE
—————————— ———-
PDB$SEED                       READ ONLY
APP1_PDB                      READ WRITE

Then he was able to login to the PDB:

SQL> connect user1/user1pwd@app1_pdb

For more details about how to manage pluggable database, especially in Oracle RAC environment, check my presentation at Collaborate 14:

Oracle RAC 12c Flex Architecture and RAC support for Multitenant Architecture, May 27, 2014

and even more details on Apress Book “Expert Oracle RAC 12c ” Chapter 4 :New Features in RAC 12c which I co-authored.

My Presentations at Oracle Openworld 2014   Leave a comment

I will be presenting or co-presenting the following sessions at Oracle OpenWorld 2014. This marks my 9th consecutive Oracle Openworld conferences that I have presented. From 2006-2013, I have presented 22 technical sessions or panels at 8 Oracle OpenWorld conferences.

1. Session #ID: UGF9244, Architect Your Data Center Infrastructure from Scratch,  Sunday, Sept 28, 10:00am-10:45am,    – Moscone South – 308

Abstract: The experts in this session are challenged to put together a greenfield design/architecture that could provide the storage, server, and network services for a small to midsize manufacturing company. These experts are then presented with a few business challenges, and the attendees will see how their architecture changes, grows, or contracts to meet these needs. The presentation reveals the difference between vendor hype and the reality of day-to-day usage of these services and discusses how changing trends in technology do or do not fit well into changing business needs. You will leave the session with an understanding of the choices that go into picking a infrastructure service, including storage, backup, servers, and even operating systems.

2. Session ID: UGF3431: Implement and Manage IaaS and a Self-Service Portal with Oracle Enterprise Manager 12c
(IOUG Sunday session), Sunday, Sept 28, 12:00am-12:45am Moscone South – 307 

Abstract: In Infrastructure as a Service (IaaS) cloud model, users can request the infrastructure for applications through the Self Service Portal. This session will focus on how to implement such a Iaas Self-Service with Oracle Enterprise Manager (EM) 12c and Oracle VM. This session will cover the IaaS cloud architecture; creation of VM templates/ assemblies using Virtual Assemble Builder (OVAB), and how to setup the Self-Service deployment mode with Oracle VM templates and virtual assemblies. You will learn the configuration of the entire stack of this infrastructure cloud built on Dell platform and how to use EM12c to manage the entire stack of the cloud architecture including hardware through Oracle EM12c’s Dell Dell OpenManage plug-in.

3. Session ID: CON5433: Leveraging New Oracle Database 12c Features to Reduce Storage Costs
OOW weekday section, Thursday, OCT 9, 9:30am-10:15am, Moscone South – 310 

Abstract: Advances in flash storage are driving ever-increasing performance. And while the price per GB continues to decrease, the absolute cost of top-tier storage offerings is on the rise. One way to combat the high cost of flash storage is to tier data across multiple types of disks to leverage the cost and capacity of conventional spinning disks. This session shows you how to reduce your storage costs without compromising performance, through automatic tiering of your data with two new Oracle Database 12c features: Heat Map and Automatic Data Optimization.

Posted July 18, 2014 by kyuoracleblog in Uncategorized


Get every new post delivered to your Inbox.

Join 70 other followers