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
HA.
• 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.

DAAD1

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

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:
https://kyuoracleblog.wordpress.com/publications/

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: http://coll15.mapyourshow.com/6_0/sessions/session-details.cfm?ScheduleID=2129

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:: http://coll15.mapyourshow.com/6_0/sessions/session-details.cfm?ScheduleID=3530

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:: http://coll15.mapyourshow.com/6_0/sessions/session-details.cfm?ScheduleID=3531

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: http://coll15.mapyourshow.com/6_0/sessions/session-details.cfm?ScheduleID=3555

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
Abstract:
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:

ERROR:
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
Connected.

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

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

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

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

ERROR:
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 12.1.0.2.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> select NAME, OPEN_MODE FROM V$PDBS;

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:

SQL> alter PLUGGABLE  DATABASE APP1_PDB open;

Pluggable database altered.

check the PDB open status:

SQL> select NAME, OPEN_MODE FROM V$PDBS;

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

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

https://kyuoracleblog.files.wordpress.com/2014/05/achieving-availability-and-scalability-with-oracle-12c-flex-clusters-and-flex-asm.pdf

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

mena

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
Abstract:
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.

Objectives:
• 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/

Follow

Get every new post delivered to your Inbox.

Join 66 other followers