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: https://www1.gotomeeting.com/register/911549736
For details, refer to IOUG webinar link: http://www.ioug.org/p/ca/vi/sid=384
Join the IOUG Cloud Computing SIG on http://www.ioug.org/p/cm/ld/fid=148&gid=60
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 : http://en.community.dell.com/dell-blogs/dell4enterprise/b/dell4enterprise/archive/2014/09/29/dell-integrated-systems-for-oracle-business-analytics

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: https://www1.gotomeeting.com/register/439651800
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 http://otnmenatour.org/

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

My Experience at DOAG and BGOUG Conferences   1 comment

2013-Konferenz-Banner_Speaker-180x150_hochIn November 2013, I took a trip to Europe to present at two great Eurpoean Oracle user group conferences : DOAG (Germany Oracle User group conference) and BGOUG (Bulgaria Oracle User Group) Autumn conference. Although it was my first time to attend them, I had a great time at  these two conferences. At the conferences,  I got chances to my knowledge in these two great Oracle commuities and also learned a lot  and had a great time networking with colleagues and friends.

DOAG 2013 was held in the Germany historical city Numberg. It was one of the largest Oracle conferences in Europe, attended by more than 200o Oracle professions from  Germany as well as other  Eurpoean countries. Most speakers were also from  Europe  or USA. Many of speakers were Oracle ACE Directors or Oracle ACE and well known experts on their areas. Oracle Corporation also sent a good number of product managers and technical experts to present the latest changes of the technology. One of the sessions that I attended was the Oracle In-Memory columnar Option session presented by the Oracle In-Memory columnar  Option product manager. This presentation gave more detailed information about this latest Oracle 12c new feature than the similar one that was gaiven at Oracle OpenWorld 2013. The session contained the presentation as well as a detailed live demo.

At the DOAG conference, I gave two presentations. The presentation PDF  files can be downloaded through the following hyperlinks:

1. Ensure HA in Database Cloud with Oracle Database 12c:What to do and how to do it:    11/19/2013: 11:00-11:45 am , The Nuremberg

2. Achieving Availability and Scalability with Oracle 12c Flex Clusters ,  11/20/2013 : 1:0-1:45pm,The Nuremberg ConventionCenter (NCC), Nuernberg,  Germany.  

After DOAG conference, I traveled to Plovidiv, a famous historical city in Bulgaria to attend BGOUG (Bulgaria Oracle User Group) conference. There are  two Oracle conferences held in Bulgaria annually: the Spring conference in May , and the Autumn conference in November. The autumn onference attracted several hundred Oracle professions from all over Bulgaria. The  majority of speakers were from Bulgaria as well as other other Eurpoean countries plus  few from US and  non-Eurpoean countries. The two presentations I gave had the same titles as the one that I presented at DOAG with some minor changes on the contents:
 1.  Ensure HA in Database Cloud with Oracle Database 12c:What to do and how to do it: 11/21/2013: 6:00-7:00pm,  Novotel hotel, Plovdiv,Bulgaria2
 2 . Achieving Availability and Scalability with Oracle 12c Flex Clusters/Flex ASM,11/21/2013: 4:45—5:45pm,  Novotel hotel, Plovdiv,Bulgaria

Get every new post delivered to your Inbox.

Join 62 other followers