Effective Consolidation of Oracle Databases on Linux on IBM System z Steffen Thoss System z Virtualization and Linux PDT lead, IBM [email protected]

Discussion Topics

2

•

The IBM & Oracle relationship

•

System z virtualization

•

Business case for Oracle consolidation

•

High-availability and Disaster Recovery

•

Deploy to the best fit technology

Linux on IBM System z in 3Q2013 Installed Linux MIPS at 49% CAGR* •

•

•

•

•

25.8% of Total installed MIPS run Linux as of 3Q13

Installed Capacity Over Time

Installed IFL MIPS increased 44% from 3Q12 to 3Q13 38% of System z Customers have IFL’s installed as of 3Q13 81 of the top 100 System z Customers are running Linux on the mainframe as of 3Q13 ** 58% of new FIE/FIC System z Accounts run Linux (FY102Q13) * Based on YE 2003 to 3Q2013 **Top 100 is based on total installed MIPS

3

The IBM and Oracle Relationship

The IBM & Oracle Relationship

5

IBM and Oracle Business Relationship •

•

•

•

•

6

Oracle Software Stack is certified and supported on certified distributions of Linux running natively in LPARs or as a guest operating system in z/VM virtual machines deployed on the System z platform. (My Oracle Support reference Doc ID: 417770.1). Products certified for the System z platform qualify for the same level of support as any other certified Oracle platform. There is a dedicated Oracle team @ Oracle specially trained to support customers running Oracle with Linux on System z servers. Oracle support policy for security patches for Linux on System z servers: ‒ Security patches also known as “CPU patches” are now included in the quarterly PSU (Patch Set Updates) for all platforms. Products ported to Linux on System z servers will be supported according to the Oracle Lifetime Support Policy.

IBM and Oracle Business Relationship (cont'd) •

7

IBM and Oracle Business Relationship: ‒ The IBM and Oracle Web site hosted by IBM at: http://www.ibm.com/solutions/oracle ‒

The IBM Partner Relationship Web site hosted by Oracle at: http://solutions.oracle.com/partners/ibm

‒

Frequently asked questions from IBM and Oracle customers about Linux on IBM System z http://www.ibm.com/support/techdocs

Oracle DB Certifications on Linux on System z • •

•

•

•

8

Oracle has been delivering database solutions on Linux on System z Servers since 2002 On March 30th, 2011 delivered Oracle 11g Release 2 (11.2.0.2) Database for Linux on IBM System z Servers. New features such as Real Application Testing and support for huge pages, make this an interesting Linux on System z option.

E-Business Suite on Oracle Database 11g Release 2 is supported as a mixed mode architecture (formerly " split tier architecture"). Database can run on Linux on z. EBS code runs on a different platform ( AIX, Linux on x86, etc.) Hyperion Finance EPM is supported on Linux on System z in a split tier architecture.

Oracle Applications for System z Servers IBM Data Server on DB2 z/OS and or Linux*

Oracle DB Server on Linux

* Note: Multi-Platform “Split Tier” Configuration – Oracle applications accessing Database,, only the Database runs on System z Servers unless otherwise noted

9

Oracle Technology Solutions for System z Servers

Oracle DB Server on z/OS

Oracle Fusion Middleware on z/OS

10

Oracle DB Server on Linux

Oracle Fusion Middleware on Linux

Oracle Industry Applications for System z Servers IBM Data Server on DB2 z/OS and or Linux*

Oracle DB Server on Linux

* Note: Multi-Platform “Split Tier” Configuration – Oracle applications accessing Database,, only the Database runs on System z Servers unless otherwise noted

11

Oracle Cross Industry Applications for System z Servers IBM Data Server on DB2 z/OS and or Linux*

Oracle DB Server on Linux

* Note: Multi-Platform “Split Tier” Configuration – Oracle applications accessing Database,, only the Database runs on System z Servers unless otherwise noted

12

Oracle Analytic Solutions for System z Servers IBM Data Server on DB2 z/OS and or Linux*

Oracle DB Server on Linux

* Note: Multi-Platform “Split Tier” Configuration – Only the Database runs on System z Servers unless otherwise noted

13

Oracle and Linux on System z IBM & Oracle working together Redbooks:

Performance Papers: •

Oracle Database on Linux on System z - Disk I/O Connectivity Study

•

Analyzing BI Oracle Workloads

•

Oracle Real Application Clusters on Linux on IBM System z: Set up and network performance tuning 14

System z Virtualization

Why System z for Oracle

16

•

High Availability Requirements

•

Open Standards and Linux

•

Disaster Recovery Requirements

•

Customer Data on Mainframe

•

Increased Performance Requirements

•

Economics of Linux (IFL) Specialty Engines

•

TCO versus Total Cost of Acquisition

•

‘Green’ Value from Mainframe

•

zEnterprise servers can virtualize everything with up to 100% utilization rates

•

zEnterprise is the only Heterogeneous platform in the industry

•

System z has the highest security rating or classification for any commercial server

System z – Extreme Virtualisation Build-in and Shared Everything Architecture System z • Provisioning of virtual servers in seconds • High granularity of resource sharing (5 years)

• Backup • Upgrade • diagnostic •…

LGR = Live Guest Relocation 33

z/VM 6.2 LGR improves it

Oracle High Availability with System z Server provided HA

Oracle Operating system HA

RAC Data Guard Flashback CRS Grid Control

Linux

• Linux Clustering

z/VM

• Mature Hypervisor • Hardware assist • z/VM SSI/LGR

Hardware provided HA

System z

34

• • • • •

• • • • •

Spare CPUs N+1 power supplies Chip sparring in memory Concurrent maintenance 50 years MTBF (system fail.)

High Availability Step 1 Active/Passive is Cold Fail-over Solution Cold Fail-Over Infrastructure

Third Party Applications

Oracle Applications

Oracle Applications

Oracle Middleware

Oracle Middleware

Oracle Database

Oracle Database

Linux-HA / Oracle Grid Infrastructure

LPAR 1

35

• Cold Failover with downtime • No extra CPU resources required • Linux-HA for any product and/or Oracle Clusterware for Oracle products or RACOne Node

LPAR 2 IBM zEnterprise

35

z/VM hypervisor

z/VM hypervisor

Third Party Applications

Protect all components • Third Party Applications • Oracle Applications • Oracle Middleware • Oracle Database

If active servers goes down, database and application will be automatically restarted on standby servers.

High Availability Step 2 Active/Active Increases Applications / DB Availability Active/active mode with Real Application Cluster for High Availability

Oracle Applications

Cluster Implementation

z/VM hypervisor

Oracle Database Real Application Cluster Oracle Grid Infrastructure Test

LPAR 1

Dev

z/VM hypervisor

Oracle Middleware

Cluster Implementation

 Provide High Availability – No downtime on node failure – Rolling Upgrade Patching – Increase Workload treatment by adding nodes with no downtime  Oracle Real Application Cluster (RAC) is flexible architecture – Workload balancing across the nodes (partitions) of the servers – Easy maintenance as 1 node can be stopped without Application disruption

LPAR 2

If one server goes down, database will be still available, no disruptions. 36

High Availability Step 3 Combine IBM System z, Active/Active Oracle RAC + DR DR Site

Production Site

Production Cluster 1 DB Instance 1 Clusterware

DB Instance 2 Clusterware

Standby DB Prod1

Production Cluster 2 DB Instance 1 Clusterware

DB Instance 2 Clusterware

Standby DB Prod2

IBM zEnterprise

Oracle RAC Cluster Automated workload balancing 30 15

15

22.5

15 7.5

7.5

7.5

0

0

0

Do not host only RAC(s) DB in the server … 37

Reduce downtime and delay the fail-over process • Easy maintenance as cluster nodes can be stopped with minimum disruption But does not include disk storage • Storage and Network HA need to be included • Could be more flexible infrastructure for provisioning, maintenance and failover operations • Free resources are reserved in DR server (capacity on demand) to get the additional workload in case of a node failure/maintenance

High Availability / Disaster Recovery The Global Picture Production Site

DR Site

Test / Dev Cluster DB Test Instance 1

DB Test Instance 1

Linux-HA

Production Cluster 1 DB Instance 1 Clusterware

DB Instance 2 Clusterware

Production Cluster 2 DB Instance 1 Clusterware

Another single DB

Standby DB Prod1

Data Guard

DB Instance 2 Clusterware

Storage services (PPRC/Metro Mirror)

Standby DB Prod2

• Test and Development are different workloads profiles than production • Mix production/DR and test environment to optimize resources • Define test and development workloads as less priority without impact on activities • Less hardware resources • Simplified and Flexible IT infrastructure • Less administration and maintenance Oracle Data Guard Requires a minimum downtime of the DB • Linux-HA can be combined with storage replication solution. • CPU and Memory resources for the passive server are not wasted, they are reserved and can be automatically activated with Capacity on Demand

Optimize overall infrastructure with consolidation of other workloads (i.e. Development, Test, …) and Capacity on Demand 38

Deploying RAC for High Availability RAC – Real Application Cluster •

•

•

Active/Passive configuration ‒

One node processes work

‒

The other node waits for the first node to fail

‒

No extra CPU resources !

Active/Active configuration ‒

All nodes process work

‒

If any node fails the cluster is re-mastered.

Besides availability, RAC can be used for workload distribution ‒

•

39

All work does not have to go through all nodes

Deploy ‒

In the same LPAR for test/dev applications

‒

Across LPARs for LPAR maintenance or software failures (most common implementation)

‒

Across CECs when taking entire systems down is a “common” occurrence

Deploy to the Best Fit Technology

Oracle Database Migration Services IBM Migration Factory (MF) How does it work? Review your current database environment in a planning session with the MF team. And we: • •

•

• •

•

• •

41

tell you how long it will take and how much it would cost perform automated data collection to establish the metrics for the databases to be migrated work with you to establish testing requirements and a cutover strategy prepare a detailed project plan manage and perform the migration of the required databases according to the plan to help ensure that risk, schedule and cost are correctly managed confirm that the migrated databases meet your testing requirements support you during cutover into production provide basic skills transfer for an established number of your personnel on the migration tasks performed during these services

GET YOUR KEY QUESTIONS ANSWERED • “Can it be done?” • “How is it done?” • “What will it cost?” • “How long will it take?” • “What are the risks?”

Deploy Oracle Software to the “Best Fit” Technology IBM DB2®

Apps & DBs

z/OS

Linux

Oracle DB & Fusion Middleware

Linux z/VM

System z PR/SM

™

Cert. Oracle Solutions AIX on POWER7® Blade Virtualization

z HW Resources

zEnterprise

POWER® Blades

Oracle software deployments (incl. consolidations) with Linux on zEnterprise provides an excellent price performance. • From an Oracle licensing perspective 1 IFL = 1core • Less operational efforts • High levels of security and availability

Business Connexion – South Africa

Sparda Datenverarbeitung eG – Germany

 ICT services to the financial sector, government, … and more  Approximately 50 virtual Linux servers; flexible environment for hosted services; high performance for Oracle databases  Enabled competitive pricing for client services

 IT provider for approximately 4.2 million customers  Runs a number of very large Oracle databases, where the virtual Linux server requires 30 GB memory and ~350 GB storage  Experienced >99% availability, which proves the Linux reputation

42

Client Case Studies Linux on System z with Oracle

43

When Consolidating Oracle Database Servers •

Understand your requirements (and cost implications) ‒

High Availability (how much money is at stake if your system is down x minutes/hours?)

‒

Disaster Recovery (what is your RTO by application/database?)

➔

Select architecture choices according to requirements

•

Low utilization servers and mix of different peak times are best candidates ‒

•

Databases with high I/O stress will benefit from System z architecture

•

Tune migrated database servers to the virtualized environment

•

•

44

Selected databases with sustained high CPU utilization may not be good candidates

‒

Right size servers (memory, number of vCPUs, direct I/O)

‒

System z may behave differently compared to x86

Monitor your system behavior ‒

Typically performance behavior is not static

‒

Test before and after changes are applied

Consider Capacity on Demand (CoD) for peak load times

Customer Examples – More Details

Dundee City Council Delivers Value Through New Technologies Creating a cost-effective IT architecture with SUSE Linux Enterprise Server on IBM System z and IBM XIV Storage System technologies Business need: Like all UK local authorities, Dundee City Council needs to handle increasing demand for IT and eGovernment services, while also reducing costs in line with central government targets. When the lease on its server and storage hardware needed to be renewed, the Council saw an opportunity to enhance its capabilities and increase value for money.

Solution: Dundee worked with IBM to upgrade its mainframe environment with two powerful IBM System z10® servers, and introduced the IBM XIV® Storage System to replace a mixed storage environment. The new infrastructure runs a range of Linux applications and Oracle databases – supporting key systems such as social services 24x7.

Benefits: • Improves performance by more than 50 percent, providing capacity for growth without increasing IT costs. • Enables very rapid provisioning of virtualised server and storage resources, enabling the IT team to respond more quickly to end users’ needs. • Provides excellent availability and disaster recovery capabilities: in the event of a disaster at the main site, all systems can be restored at another location within 20 minutes. • Reduces Oracle licensing costs, as numerous virtual Linux servers can run on each IFL processor. 46

"Running Linux on the System z platform is a cost-efficient approach, especially for software like Oracle, which is licensed on a perprocessor basis. We can run 60 virtual machines on just four System z processors – whereas an equivalent x86-based architecture might require several processors for each server! So the savings can be considerable ." - Tim Simpson, IT Support Manager, Dundee City Council

Sparda Datenverarbeitung eG chooses IBM zEnterprise with SLES for System z “Over the years, the mainframe transformed from traditional workloads, quite simple, to a universal platform for new workloads as well. And we see a lot of new applications that are coming to this platform. Especially for Linux, it's perfect. The zEnterprise platform is perfect for consolidating Linux workloads because of the high I/O bandwidth, business continuity with capacity backup features.”

“Oracle has been consolidated on this platform we are using right now only Oracle on the z196 platform,” Bernd Bohne, Sparda-Datenverarbeitung e.G., Manager, Central Systems Watch and listen to • Bernd Bohne, Sparda-Datenverarbeitung e.G., Manager, Central Systems • Marie Wieck, IBM, General Manager, Application Integration Middleware • Steve Mills, IBM, Senior Vice President & Group Executive, Software & Systems http://www.youtube.com/watch?v=c7Z19IB5AmE 47

Sparda Datenverarbeitung eG SDV runs a number of very large databases within the virtualized Linux environments … The company also relies on SUSE Linux Enterprise Server to support online banking services for the Sparda Banking Group's 4.2 million customers. Working with IBM, SDV deployed an IBM z196 at each of its two data centers, activating six Integrated Facility for Linux (IFL) engines on each box.

“Our online banking services process approximately 1,200 online transactions per second, so we simply cannot afford them to fail. SUSE Linux Enterprise Server, which is involved in a significant part of this workload, makes us confident that this will not happen. Since deploying SUSE Linux Enterprise Server on the IBM z196 we have experienced over 99 percent availability. This proves that Linux's reputation for stability and reliability is well and truly deserved. We imagine the solution will play an integral role in SDV's infrastructure for some time to come.” - Bernd Bohne, Department Head, Central Systems Technology, Sparda-Datenverarbeitung eG

48

Business Connexion The company was running BMC Remedy IT Service Management Suite on Solaris, and determined that the cost of licensing the underlying Oracle database across numerous processors would make it difficult to offer solutions to clients at a competitive price.

Business Connexion deployed SUSE Linux Enterprise Server for System z* to run a new monitoring solution for clients. The ability to run multiple virtual servers side-byside on a single mainframe processor ensures low software costs for the solution, enabling Business Connexion to offer a powerful solution at a highly competitive price. Business Connexion currently has approximately 50 virtual machines across the two mainframes—a mixture of database servers, application servers and proxy servers for several different hosted clients. Results:

– Created a flexible environment for hosted services – Delivered high performance for Oracle databases – Enabled competitive pricing for client services “With SUSE Linux Enterprise Server for System z, we get excellent performance and bullet-proof reliability—plus it’s easy and cost-effective to manage.” - Frans Labuschagne, Senior Manager for Open Systems Support Services, Business Connexion 49

Idaho Power Company Moved to SUSE Linux Enterprise Server on IBM System z to Improve Performance and Reduce Costs Working with SUSE Consulting, the Idaho Power IT staff consolidated 30 servers to its mainframe environment using a hosting z/VM operating system for a substantial reduction in server costs. This consolidation has also significantly reduced the company's Oracle licensing costs.

“The power and performance of our SUSE Linux Enterprise environment would have required 3-4 times the amount of money to replicate in other computing environments.” — Ron Keogh, IT Project Manager for Idaho Power Company

 The IT staff can add a virtual Linux server in a matter of hours. Such consolidation has dramatically reduced both hardware and software licensing costs, providing an immediate return on investment.  Idaho Power now has a stable and reliable infrastructure that gives users access to resources four times faster than before. The company has also increased system performance to respond more quickly to customer issues and power outages. 50

Canada Dept. of National Defence From mainframe serving to hybrid enterprise hosting Business challenge: Here was the challenge presented to John Palmer by his director, Winston Sorfleet: “I want you to find new ways to use and grow the [new mainframe] technology.” In a large organization with a variety of platfoms, competing IT agendas, and a history of diffuse control, this is easier said than done.

Solution: The Canada Department of National Defence (DND) path to enterprise hosting with the z196 began with consolidation within the mainframe group itself. Palmer brought all three existing mainframes under centralized organizational management. This entailed the consolidation of all mainframe-related tasks, including:  Hardware / Software / Storage support  Contracting for Software / Hardware / Maintenance  Business Recovery contract management  Role of BR Manager transferred as well  Transfer of all mainframe-related funding At DND Palmer certainly encountered resistance. He overcame the resistance by setting up a proof of concept (POC) around Oracle running with SUSE Linux Enterprise Server for System z. Based on the results of the POC, Palmer could build a compelling business case emphasizing the dramatic licensing cost savings. With the strong support of management, the mainframe group prevailed.

Benefits:  You continue to manage/administer your applications as before—the mainframe is only managing the virtualized hosting platform they are running on.  Your AIX®, Linux, Power, and x-based skills continue to be valuable—those operating systems and platforms remain viable and active in the enterprise as do the applications running on them. Thus, your skills continue to be in demand.  You get rid of platform headaches—the System z team will manage the platforms while you get to do the rewarding work with the applications and users without platform worries. 51

State of Oklahoma Dept. of Human Services Making a Difference for the Business and Consolidating Servers “We were so close to the end of our lifecycle on HP-UX, and the hardware was getting very expensive to support,” says Sunni Majors, director of Enterprise Technical Services. “By moving Oracle to the Linux System z platform, we were able to restructure costs for CPUs and move away from licensing by user. This gave us a better return on our investment, since we experienced significant savings in our hardware and software licensing costs by consolidating resources onto a single platform.” OKDHS IT also was pleasantly surprised at the ease of the server and application migration to Linux on System z, although it remains vigilant when it comes to asset management and TCO throughout its IT architecture. www.mainframezone.com/interviews/state-of-oklahoma-department-of-human-services-making-a-difference-for-the-

52

The Government of Québec Saves Money and Resources by Consolidating on an IBM System z "Oracle billing is based on how many processors it's running on, and with the new needs, we were requiring between 40 or 50 licenses," notes Karen-Ann Plourde. Realizing that there was the potential for massive cost savings, the organization began searching for a solution that would help it consolidate its many Oracle database instances on fewer processors. As part of this process, it looked at such platforms as UNIX, Intel and virtualization on midrange Linux boxes. None of them, however, gave it the savings it was seeking. There's consolidation and then there's consolidation. What's the difference? Well, how about putting 200 Oracle databases as opposed to, say, one or two or even six databases onto one server.

“Disaster recovery is better, our environment is very robust and the performance, security and resource sharing with our Oracle databases is very good and certainly much better than we had had before.” — Karen-Ann Plourde, project manager with Direction Générale des Technologies de l'Information et des Communications (DGTIC)

It's no longer a matter of one or two or three LPARs on a machine, but such innovative combinations of technology as Linux married to the z/VM platform. There appears to be no limit as to how much one can consolidate on a single virtualized machine. www.ibmsystemsmag.com/mainframe/casestudies/miscellaneous/no_limits 53

Consolidate. Reduce Complexity. Save on costs and efforts. Learn more:

CAS1457 SICOOB, the second largest Linux on z implementation in the world CAS1509 Building a Business Case for System z Linux TT1395 How to Build an HA environment with Linux on IBM System z FUT1314 SUSE Linux Enterprise Server for System z - Roadmap

Thank you.

54

55

Corporate Headquarters

+49 911 740 53 0 (Worldwide)

Join us on:

Maxfeldstrasse 5 90409 Nuremberg Germany

www.suse.com

www.opensuse.org

Unpublished Work of SUSE. All Rights Reserved. This work is an unpublished work and contains confidential, proprietary and trade secret information of SUSE. Access to this work is restricted to SUSE employees who have a need to know to perform tasks within the scope of their assignments. No part of this work may be practiced, performed, copied, distributed, revised, modified, translated, abridged, condensed, expanded, collected, or adapted without the prior written consent of SUSE. Any use or exploitation of this work without authorization could subject the perpetrator to criminal and civil liability.

General Disclaimer This document is not to be construed as a promise by any participating company to develop, deliver, or market a product. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. SUSE makes no representations or warranties with respect to the contents of this document, and specifically disclaims any express or implied warranties of merchantability or fitness for any particular purpose. The development, release, and timing of features or functionality described for SUSE products remains at the sole discretion of SUSE. Further, SUSE reserves the right to revise this document and to make changes to its content, at any time, without obligation to notify any person or entity of such revisions or changes. All SUSE marks referenced in this presentation are trademarks or registered trademarks of Novell, Inc. in the United States and other countries. All third-party trademarks are the property of their respective owners.