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

Presenting at the First Oracle Technology Network (OTN) MENA Conference Tour   Leave a comment


I will give an Oracle technology presentation at the first OTN MENA (Middle East & North Africa) tour May 27, 2014. This presentation will be given online which can be attended remotely anywhere in the world. The following is detailed information about this presentation:

Title: Oracle 12c RAC Flex Architecture and support for RAC 12c Multitenant Architecture
Speaker: Kai Yu
Time: May 27th 2:35pm – 3:25pm Tunis time, which is 8:35-m-9:35 am US central time.
Web link to attend the presentation remotely:
Oracle 12c RAC Flex Architecture and support for RAC 12c Multitenant Architecture
High Availability and Scalability become increasing important for IT infrastructure as application and database consolidation has become a key initiative in the data center. The Latest Oracle 12c RAC provide the right solution to achieve these goals with Oracle12c RAC and the multitenant architecture. Come to this session to learn these new features from the author of the Oracle 12c New feature chapter of the Apress book Expert Oracle RAC 12c .
This session will provide the technical details on these new features such as Flex Clusters and Flex ASM and how to manage them to achieve the business benefits. This session also examines how Oracle RAC supports Oracle multitenant architecture and how these two important technologies work together to enable the highly available, scalable and cost-effective database infrastructure.

• Learn the Oracle RAC 12c: Flex Clusters and flex ASM their benefits and how to manage them
• Learn Oracle 12c RAC support for Oracle multitenant architecture
• Learn how to leverage these new features to establish the foundation for a database
cloud environment.

This presentation is a part of the OTN MENA Oracle technology conference tour, which covers five major Middle East and North Africa cities in two continents: Bizerte, Beia, Riyah, Jeddah, and Dubai. The conference tour brings a star-studded cast, consisting of some of the world’s best Oracle ACEs, ACE Directors and Rock Star Speakers to the region.

To find the entire OTN MENA conference tour presentation schedule and topics, please visit the OTN MENA tour website at

My presentation sessions and panel sessions at Collaborate 14   Leave a comment

The industry most important Oracle technology conference Collaborate 14 conference will be held in Las Vegas from April 7 to April 11th. At this conference, I will be the primary speaker of two technical sessions. In addition, I will be invited to participate several technology panels such as Oracle RAC panel by IOUG RAC SIG and Cloud panels by IOUG Cloud Computing SIG as a panelist or co-speaker. These sessions cover some important technical topics such as Oracle 12c RAC new features, High Availability, Cloud and Virtualization :
Primary Presentation Sessions:
1. Delivering Self-Service Cloud Application Services Based Using Enterprise Manager 12c, session # 393 , April 4/8, 5:30pm-6:30pm, Level 3, Lido 3101B
2. Ensure HA in Database Cloud with Oracle Database 12c: What to Do and How to Do It, session #398 , 4/9, 2:00pm-3:00pm,. Level 3, Lido 3101B
Co-presenting or Expert Panel sessions that I will participate:
1. Planning your Oracle Cloud Computing Roadmap – Database, Middleware, Applications, session #849, 4/8, 10:15 AM-11:15Am, Level 3, Lido 3101B (speakers: Basheer Khan, Charles Kim, Kai Yu
2. Open discussion: Best ways to learn Oracle RAC 12c, Session # 512, 4/8, 06:30 PM – 07:15 PM, Level 3, Toscana 3701, Ludovico Caldara, Yury Velikanov, Kai Yu
3. Cloud SIG: Cloud SIG: Understanding Cloud and DBaaS Strategies, Best Practices and Skill Sets , session #713 , 4/10, 11:00AM-12:00PM, Level 3, Lido 3101B, George Trujillo, Jr. Kai Yu
Charles Kim, Ron Batra
4. You Bet your Data Center, Architect Your Infrastructure from Scratch, Session #507, 4/10, 3:00 PM-5:00PM, Level 3, Lido 3015, speakers: Gary Gordhamer, Kirby McCord, Kai Yu Tariq Farooq
5. Who? What? Why? Oracle on Oracle’s Public Cloud – 360 Degrees, session #444, 04/11, 11:00 AM-12:00pm, Level 3, Lido 3101B( speaker: Tariq Farooq, Kai Yu, Charles Kim, George Trujillo, Jr.)

Posted April 6, 2014 by kyuoracleblog in Uncategorized


Get every new post delivered to your Inbox.

Join 61 other followers