1 / 52

Randal Sagrillo Larry McIntosh

Plug into the Cloud Modernize Your IBM AIX Database Environment. Randal Sagrillo Larry McIntosh. Agenda. 1. The Drive to Modernize Migration Planning Overview Database Re- Platforming – Let’s Modernize Plug into the Cloud For More Information. 2. 3. 4. 5. Oracle and IBM.

giuseppe-bishop
Download Presentation

Randal Sagrillo Larry McIntosh

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Plug into the Cloud Modernize Your IBM AIX Database Environment Randal Sagrillo Larry McIntosh

  2. Agenda 1 The Drive to Modernize Migration Planning Overview Database Re-Platforming – Let’s Modernize Plug into the Cloud For More Information 2 3 4 5 Oracle Confidential – Internal/Restricted/Highly Restricted

  3. Oracle and IBM Industry Leaders with Different Approaches • 50-60% of revenue from services • 5-6% of revenue into R&D • Selling complex IT services • Shrinking hardware investments profile Provides Core Technologies and products to enable enterprises to have continuous real time view of customers Services Driven Business model • Engineering Driven Business Model • Focused on innovation with In-Memory and Software on Silicon • ~12% of revenue into R&D • Removing IT complexity by integrating products and providing Cloud Services • Growing hardware investment profile

  4. Hardware Investment Profile Oracle Invests IBM Divests Discontinues resale of NetApp N-Series Sold networking business to Cisco* Sold HDD business to Hitachi Sold PC business to Lenovo Sold printing business to Ricoh FAB?? Can’t PAY Globalfoundries to take it. NOW what? Sold POS business to Toshiba X86Servers 2000 2002 2004 2006 2008 2010 2012 2014 What do you do when IBM sells off the products you rely on? *later acquired networking specifically for BladeCenter

  5. Execution: The Road to Performance Leadership ACQUIRE FOCUS COMPETE ACCELERATE OPTIMIZE POWER7+ Due: MIA • Software-in-silicon • Database & Java Accelerators SPARC T5/M6 POWER7+ POWER7 AIX 7.1 SPARC T4 Solaris 11 Solaris 11.1 SPARC T3 SPARC T-Series 2010 2011 2012 2013 FUTURE 300% 2010 to 2013 Performance Gain ~10%

  6. Save by Replacing Legacy Power Systems Example: Replace an IBM Environment 5 Year TCO Request a Custom TCO Analysis from Your Account Executive Upgrade and Save1 $8M • Save $4.8 million over 5 years • 5 to 1 Consolidation • 2.1x lower hardware costs • 7x reduction floor space • 3.5x lower power and cooling costs $6M 2.6x Savings $4M $2M 1Analysis based on replacing a farm of IBM P570 (P6+) servers and IBM storage with Oracle SPARC T5-4 servers and Oracle Storage

  7. Four High Level Migration Steps Planning Steps to Migrate to The Real-Time Enterprise Architectural Readiness Application Support Considerations Step1 Step2 Step3 Step4 Operational and Administrative Mapping DatabaseReplatforming

  8. Architectural Readiness Assessment Identify Shared Services – Common Frameworks That May impact Migration High Availability Data Protection • Assessment scope - Systems planned for migration. • Assessment impact - Amount of accommodation or change off: • High Availability Architecture • Disaster Recovery Architecture • Data Protection Architecture • System Management Architecture Migration Disaster Recovery Systems Management

  9. Assess Architecture Impacts “Where You Are” Has More Impact Than “Where You Are Going” • Storage Centric and/or • Modern Third Party • Less OS dependant • Supported by Third Party for both Solaris and AIX • Architecture UpdatesNeeded • Highly OS and/or version Dependent • Custom code or Many different vendors for H/A, DR, etc. • Oracle Maximum Availability Architecture (MAA) • OS independent • Well integrated with Oracle Technology • Tested and proven results Moderate Impact Large Impact Minimal Impact Single Third Party Oracle MAA Increasing Effort and Impact

  10. Operation Impacts of Migration Impacts are Pervasive but Mechanical • Significantly simpler than one might think because bothAIX and Oracle Solaris are: • RISC UNIX • System V based • 64 bit • Big-Endian • And simpler still when Oracle Database, Oracle Middleware and Oracle Applications: • All are tested and integrated in depth with Oracle Solaris

  11. Administrative Impacts of Migration Training and Tools Available for AIX Fluent Administrators • Get Started- 30 Minute Migration Fundamentals at Oracle Learning Library • http://oracle.com/oll/migrate2sparc • Get Informed- IBM AIX to Oracle Solaris Technology Mapping Guide • http://www.oracle.com/technetwork/server-storage/solaris11/documentation/aix- solaris-mapping-guide-1896780.pdf • Get Certified- For Experienced UNIX/Linux Administrators • http://www.oracle.com/technetwork/server-storage/solaris11/training/index.html • Get Happy- If you liked AIX, you will probably like Oracle Solaris better

  12. Application Support Considerations Binary Compatibility Plus Large ISV Support Make This Simple • Check if you Application is supported on Oracle Solaris 11 here: • http://www.oracle.com/technetwork/server-storage/solaris11/applications-1551831.html • Solaris Binary Application Guarantee • If your applications runs on Oracle Solaris 2.6 or later, it will run on later versions! Guaranteed • And as always: if only Oracle software technology and Oracle Applications are being migrated, it is even simpler and easier.

  13. Database Replatforming This is About Choices and Trade Offs, Not Mitigation Oracle GoldenGate Oracle Active Data Guard More Resource/Prep Oracle Data Pump Oracle Recovery Manager Transportable Tablespaces Oracle Streams Replication Create Table As Select More/Larger Tables, Rapid to Real-time Data Change Rates

  14. Database Replatforming – Let’s Modernize

  15. Cross Platform System Migration Environment Oracle Database Export from IBM Power 740 Import to Oracle SPARC T5-2 Power 740 IBM AIX 7.1 Ethernet Network Migrated Oracle Database Oracle Database Oracle SPARC T5-2 Oracle Solaris 11.1 • IBM Power 740 • AIX 7.1 • Oracle 11gR2 • Grid ASM • Oracle Database Server Node Oracle Database Domain • Oracle SPARC T5-2 • Oracle Solaris 11.1 • Oracle 11gR2 • Grid ASM • Oracle Database Migrated Oracle Database FC SAN Storage

  16. Cross Platform System Migration Environment Oracle Database Export and Import Capability on OVM for SPARC a.k.aLDoms Power 740 IBM AIX 7.1 Ethernet Network Migrated Oracle Database Oracle Database Swingbench Order Entry Application Oracle SPARC T5-4 Oracle Solaris 11.1 • IBM Power 740 • AIX 7.1 • Oracle 11gR2 • Grid ASM • Oracle Database LDom1 LDom2 Server Node Oracle Database Domain • Oracle SPARC T5-4 • Oracle Solaris 11.1 • Oracle VM Server for SPARC (LDom) • Oracle 11gR2 • Grid ASM • Oracle Database Migrated Oracle Database FC SAN Storage

  17. Oracle Grid and Oracle Database 11gR2 Installed and Configured on Both AIX and Oracle Solaris Oracle Grid and Oracle Database installed upon • SPARC T5 Systems • Oracle Solaris 11.1 • Luns created/discovered WWNs mapped - ASM • IBM Power 740 • AIX 7.1 • Luns created/discovered WWNs mapped- ASM

  18. Automatic Storage Management Disk Groups ASM Disk Groups prior to creating 100G+ ODB on AIX Power 740 • IBM Power 740 • AIX 7.1 • ASM Instance • DATA • 176GB Free

  19. DBCA on IBM AIX Power 740 odbonaix Oracle Database Created • IBM Power 740 • AIX 7.1 • DBCA • odbonaix • DB Created

  20. Oracle Database Listener Control utility odbonaix status after dbca completed On IBM AIX Power 740 • IBM Power 740 • AIX 7.1 • Listener Control utility • odbonaix • DB Running

  21. Swingbench Order Entry Application Oracle Database Load Generator • For Oracle database • (10g,11g,12c) • Used by many • Including IBM Open Systems Labs • IBM URL • Provides Application Interface • Load/Access/Update • Swingbench URL

  22. Swingbench Order Entry Application Order Entry Wizard Database Load Request Sizing of 100G+ for odbonaix on AIX Power 740 via oewizard

  23. Automatic Storage Management ASM Disk Groups after creating 100G+ Oracle Database on AIX • IBM Power 740 • AIX 7.1 • ASM Instance • DATA • 74GB Free

  24. Swingbench Order Entry Application Oracle Database Access/Update on IBM AIX Power 740 • IBM Power 740 • AIX 7.1 • Swingbench • Order Entry • odbonaix • 1000 user access • Oracle Database odbonaix • Ready for Migration

  25. DBCA on Oracle Solaris on SPARC T5-2 odbonaix Oracle Database Created – preparation for Impdp • Oracle SPARC T5-2 • Oracle Solaris 11.1 • DBCA • odbonaix • DB Created

  26. Oracle Database Listener Control utility odbonaix status after dbca completed on Oracle Solaris on SPARC T5-2 • Oracle SPARC T5-2 • Oracle Solaris 11.1 • Listener Control utility • odbonaix • DB Running

  27. Now let’s Migrate or better yet Upgrade and then plug into the Cloud!

  28. Prepare and Export Ethernet Network Power 740 IBM AIX 7.1 Oracle Database Oracle Database Migrated Oracle Database FC FC SAN Storage AIX$ expdp system/oracle1@odbonaix full=Y directory='dpump_dir' dumpfile=par_odbonaix%U.bmp parallel=4 logfile=par_expdp-odbonaix.log

  29. Prepare and Import Ethernet Network Oracle SPARC T5-2 Oracle Solaris 11.1 Migrated Oracle Database Migrated Oracle Database FC SAN Storage • Solaris$ impdp system/oracle1@odbonaix full=Y directory='dpump_dir' dumpfile=par_odbonaix%U.bmp parallel=4 logfile=par_impdp-odbonaix-lem.log

  30. Migration Key Timings For 100+ GB Swingbench Order Entry Database • Export and Import a fraction of time to create benchmark • Minutes to Migrate 100+ GB database • Proven results as shown in this example.

  31. Verify Data Migrated Checked on both IBM AIX Power 740 and Oracle Solaris on SPARC T5-2 Ethernet Network FC

  32. Swingbench Order Entry Application Verify Oracle Database Access/Update on Oracle Solaris on SPARC T5-2 • Oracle SPARC T5-2 • Oracle Solaris 11.1 • Swingbench • Order Entry • odbonaix • 1000 user access verification • Oracle Database odbonaix • Migrated via impdp • Oracle Optimized Solutions Database

  33. Oracle Optimized Solution for Oracle Database Oracle Optimized Solution for Oracle Database Database DATABASE Optimized and Integrated with Best of Breed Products Fully Tested and Certified to simplify deployments and to reduce risk Operating Systems SOLARIS Built-in Virtualization Technologies Virtual Machines ENTERPRISE MANAGER OracleSolaris Zones Oracle VMfor SPARC PhysicalDomains Oracle Enterprise Manager Ops Center 12c Servers SPARC T-Series SPARC M6-32 Storage Oracle NAS Storage SAN Storage Oracle on Oracle

  34. Simplified Migration Summarized Where You Are Has More Impact Than Where You Are Going • Four Simple Steps • More your migration is Oracle content, the quicker it will be. • You can “Do It Yourself” or get help with expert services • Oracle Migration Factory to reduce migration duration and risk • Proven results as shown in this example. • Reduced Risk with proven practices and tools – • Oracle Databases migrated in minutes! • Oracle Databases can be upgraded through this approach too! • Providing new features of Multi-tenancy, In-Memory, Software on Silicon • Cloud Services with DBaaS enabling quality of service on Oracle SuperCluster

  35. Supports Cross Platform System Upgrade to Database 12c Oracle Database Export and Import Capability onto OVM for SPARC with Oracle Database 12c Power 740 IBM AIX 7.1 Ethernet Network Migrated Oracle Database Swingbench Order Entry Application Oracle Database Oracle SPARC T5-4 Oracle Solaris 11.2 • IBM Power 740 • AIX 7.1 • Oracle 11gR2 • Grid ASM • Oracle Database Ldom 3 Ldom 2 LDom1 Server Node Domain Migrated and Upgraded Oracle Database 12c • Oracle SPARC T5-4 • Oracle Solaris 11.2 • Oracle VM Server for SPARC (LDoms) • Oracle 11gR2/12c • Grid ASM • Oracle Database Oracle Database FC SAN Storage Database 12c Multitenant

  36. Enabling Multitenant Database Consolidation Oracle Database 12c Native and Container Databases • Native - Non Multitenant 12c Databases & • Multitenant Container Pluggable Databases • Unplug/Plug • Virtualizes Databases • Multiple Media Types • QoS • Clone Databases • Flexible & Simplifies Development & Test Oracle Optimized Solution for Oracle Database virtualizes Databases on systems network and storage Oracle on Oracle Provides Outstanding Architecture for Mutitenant Database

  37. Oracle Optimized Solution Database Cloud on SPARC SuperCluster Cloud Ready Database Services via Engineered System • Migrate AIX Oracle Database and plug into the Cloud • Provides a rapid, Self-Service deployment model • Consolidates databases in a high-capacity, high-performance system • Centralizes and simplifies lifecycle management and maintenance • Provides service delivery profiles • Enables resource flexibility and provides predicable performance Oracle Enterprise Manager 12c Cloud Control

  38. Migrate AIX Oracle Database to SuperCluster Process supports Cross Platform Migration/Upgrading for Cloud DBaaS Multi-tenant Engineered System SolarisZone SolarisZone T4-4 Node 1 T4-4 Node 1 Oracle Solaris 10 Oracle Solaris 10 Solaris Zone Solaris Zone Solaris Zone Solaris Zone Solaris Zone Solaris Zone GP Domain GP Domain Zones Zones Zones Zones Zones Zones Oracle Solaris 11 Oracle Solaris 11 • Solaris 11 and SPARC SuperCluster - Built for Cloud Database Services • Optimized for Oracle Database • OSM works with Oracle AMM for SGA dynamic resizing without reboot • Zones support for Exadata stack on SPARC SuperCluster • Zero Overhead zones virtualization • Secure Multi-Tenant Isolation • High-performance 40 Gigabit Infiniband Networking • Resolves Customer Issues and needs DB Domain DB Domain Oracle DB SGA ZFS STORAGE APPLIANCE EXADATASTORAGE EXADATASTORAGE EXADATASTORAGE InfiniBand Network Database 12c Multitenant

  39. Transforming the Data Center From Best in Class to Engineered Systems Best in Class Products Engineered Systems Oracle Optimized Solutions

  40. Learn More About Oracle Optimized Solutions Enable the Real-Time Enterprise http://oracle.com/optimizedsolutions Access information on Modernizing your IBM Environment Review The Cloud Ready Consolidation Solution for Oracle Databases

  41. For More Information • White Paper: Simplifying Your Transition From AIX To Solaris: • https://go.oracle.com/LP=3092?elqCampaignId=6285&src1=ad:pas:go:dg:sola&src2=wwmk14054228mpp006&SC=sckw=WWMK14054228MPP006 • For information on Modernizing IBM AIX/Power to Oracle Solaris/SPARC: • http://www.oracle.com/technetwork/server-storage/hardware-solutions/ibm-aix-migration-2124022.html • For information on Oracle Optimized Solution for Enterprise Database Cloud: • http://www.oracle.com/us/solutions/oos/edb-cloud/overview/index.html • For information on Cloud Ready Consolidation onto the Oracle Optimized Solution for Oracle Database: • http://www.oracle.com/us/solutions/oos/database/overview/index.html

  42. Systems and Database Sessions of Interest Moscone South and Intercontinental Hotel

  43. Systems and Database Demonstrations of Interest Moscone South

  44. Oracle Confidential – Internal/Restricted/Highly Restricted

  45. Backup Slides

  46. Oracle Solaris and SPARC VirtualizationBetter Resource Utilization for a More Efficient Datacenter Oracle Solaris Zones Oracle VM Server for SPARC Physical Domains Domain A Domain A Web DB App Web Oracle Solaris Zone Oracle SolarisZone Oracle Solaris Zone Oracle Solaris Zone App OLTP DB OLTP DB Domain B App App App Domain C Domain B DW DB Web Web Web M6-32 T-Series, M6-32 Oracle Solaris

  47. Layered Virtualization Technologies T-Series Solaris 11 Zone Solaris 11 Zone Solaris 11 Kernel Zone Solaris 11 Kernel Zone Solaris 10 Zone Solaris 10 Zone Oracle Solaris 11 Oracle Solaris 11 Oracle VM Server for SPARC SPARC

  48. Most Extensive Virtualization Infrastructure Virtualization Can Be Layered Solaris 11 Zone Solaris 11 Zone Solaris 10 Zone Solaris 11 Kernel Zone Solaris 11 Kernel Zone Solaris 11 Kernel Zone Oracle Solaris 11 Oracle Solaris 11 Oracle Solaris 11 Oracle Solaris 11 Oracle VM Server for SPARC Oracle VM Server for SPARC Physical Domain Physical Domain M6-32

  49. Advanced Virtualization Can Mix these Complimentary Technologies

More Related