1 / 52

Technology Update for SAP Applications Running on Oracle Database

Technology Update for SAP Applications Running on Oracle Database. Gerhard Kuppler Vice President - Corporate SAP Account Lam Kuen Sang Master Principal Consultant Oracle DB & Infrastructure for SAP. Safe Harbor Statement.

eitan
Download Presentation

Technology Update for SAP Applications Running on Oracle Database

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. Technology Update for SAP Applications Running on Oracle Database Gerhard KupplerVice President - Corporate SAP Account Lam Kuen Sang Master Principal Consultant Oracle DB & Infrastructure for SAP

  2. Safe Harbor Statement The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

  3. Program Agenda • Oracle & SAP Relationship and Exadata Update • Oracle 10g @ SAP • Oracle 11g @ SAP • Virtualization Update • Operating System Update • DBA Tools

  4. Oracle Development for SAP Located at SAP HQ in Walldorf, Germany • Long-established working relationship and partnership • Enables technology transfer between Oracle and SAP • Optimization of SAP on Oracle technology • Implement and test new Oracle products on SAP • Worldwide customer & pilot support • Walldorf, Palo Alto, Tokyo • SAP is Oracle’s largest reseller

  5. SAP & Oracle: 20+ Years Continuous Innovation Over 40,000 Joint Customers Database Market share for SAP Others Oracle • SAP and Oracle engage in joint engineering, integration, version alignment, patching and support • SAP is the largest Oracle database reseller More Oracle DB 10g features: ▪ Index Key Compression▪ Advanced Security (Encryption)▪ MOPatch ▪ Database Vault▪ Partitioning Engine for SAP ERP 2015 2012 2011 2010 SAP empraces Java/J2EE 2009 2008 Reseller& SupportAgreementsextended 2007 2006 SAP Competency Center Walldorf 2005 Oracle, SAPsign Reseller& SupportAgreements 2003 Reseller& SupportAgreementsextended 2001 Oracle DB 11g Rel.2▪ Compression▪ Online Patching▪ Advanced Encryption▪ Real ApplicationTesting▪ Direct NFS▪ Snapshot Stby. Database▪ Interval Partitioning, Subpartitioning ▪ Oracle Cloud File System 1999 1998 1992 Oracle DB 10g▪ Database▪ Table/Index Partitioning for SAP ERP (Service)▪ RAC 1988 Sun's first SD-benchmark world record Oracle DB 9i▪Automatic Memory Management▪ Table Com- pression (Batch)▪ Online Table Reorganization▪ Real Application Clusters (RAC) First SAPR/3 release(on Oracle DB) Oracle Exadata Database Machine for SAP Netweaver SPARC SuperCluster Optimisded for SAP SAP Netweaver for Solaris 10 (x86) First SAPBW release(on Oracle DB) Start of SAPR/3 development(on Oracle DB)

  6. SAP Customers Rely on Oracle

  7. Oracle Exadata Database Machine Proven Database and Infrastructure Platform for SAP Customers BestPerformance& Scalability BestDeploymentFlexibility BestAvailability& Reliability BestSupport forVery Large DBs BestDatabaseSecurity BestManageability& Self-Management

  8. Oracle Exadata Database Machine Transaction Processing, Data Warehousing, Consolidation • Fastest Data Warehouse & OLTP • Best cost/performance Data Warehouse & OLTP • Optimized hardware per Rack • Scales from ⅛ Rack to 16 full Racks • Software innovations

  9. Oracle Exadata Database Machine IT Simplicity at a Lower Cost Before Now

  10. Pre-built and Optimized Out-of-the-Box 100% Custom Configuration Test & debug failure modes Measure, diagnose, tune and reconfigure Performance Achievement Performance Achievement Multi-vendor finger pointing Assemble dozens of components Time (Months) Time (Days)

  11. Standardized and Simple to Deploy • All Database Machines are the same • Delivered ready-to-run • Tested • Highly supportable • No unique configuration issues • Identical to configuration used by Oracle Engineering • Runs existing OLTP and DW applications • Full 30 years of Oracle DB capabilities • Certified by SAP • Leverages Oracle ecosystem • Skills, knowledge base, people and partners Ready- to-Run Deploy in Days, Not Months

  12. X3-2 16-core Servers • X3-8 80-core Servers Exadata Evolution • Sparc SuperCluster • 3TB Disks State-of-the-Art, Scale-out Hardware • Storage Expansion Rack • X2-8 CPU Refresh • 2TB DRAM per node • Write-back Flash cache • X2-2 Servers • X2-8 64-core Servers • V2 Servers • 40 GbInfiniBand • PCI Flash Cards • Enterprise Manager 12c Database to Disk Management • Exadata V1 Introduced • Solaris x86 • Reverse Offload • Smart Flash Logging Unique Software Integration • Hardware DB Encryption • Automatic Service Request • Data Mining Offload • Smart Flash Cache • Storage Index • Columnar Compression • Smart Scan • InfiniBand Scaleout 2008 2009 2010 2011 2012

  13. Hardware Generational Advances V1 V2 X2 X3 2008 2009 2010 2012 3X Storage (TB) 504 504 336 168 4X 22.4 0 5.3 Flash (TB) 5.3 2X CPU (Cores) 128 96 64 64 8X Memory (GB) 576 1152 2048 256 Connectivity (Gb/s) 400 184 50X 24 24 8 8 400 184

  14. Oracle Exadata Database Machine One Architecture For… • SAP ERP 6.0, SAP BW 7.x etc. • Database Consolidation of • SAP and non-SAP • Avoids infrastructure silos

  15. How You Can Benefit from Exadata (I) ??? • Faster Reporting • Reduce time needed for Month-end, Year-end Reporting • Faster Closing/Batch jobs • Able to close accounts/books on time and be ready for new financial quarter/year • Lesser time needed to finish up long running batch jobs • Faster Response Time • Users can have more useful time instead of staring at hourglass • Faster System Administration tasks • System Administration Jobs run a lot faster

  16. How You Can Benefit from Exadata (II) ??? • Reliability of your Database Server • RAC enables Active-Active Clustering so no failover time needed • Ease of Storage Management • ASM manages all the disks and storage spaces • Ease of Deployment • Fully tested Engineered Configuration • Happy Users • The more “home grown” reports the more SAP customers can benefit from Smart Scan

  17. Oracle Exadata Database Machine Extreme Performance. Extreme Value. • Lower data center costs • 10x faster out-of-the-box • Store up to 10xmore data • Real time decision making • Time-to-market for new products and services • Mitigate deployment risk

  18. Oracle 10g @ SAP

  19. SAP on Oracle 10gSupported Releases Patch Sets <= 10.2.0.4 No longer supported! Grace Period 10.2.0.4 ended 31 July, 2011 You need to upgrade to 10.2.0.5 to be eligible for Extended Support Patch Set 10.2.0.5 Required for Extended Support on all OS platforms 10.2.0.5 available March 2011 February 2013 SAP Bundle Patch is most recent and contains PSU 12 for 10.2.0.5 (10.2.0.5.12)

  20. SAP on Oracle 10gExtended Support Support Fees Non-extra charged support for Oracle 10.2 expired on 31 July, 2011 Now Extended Support at charge for Oracle 10.2 Except: All platforms where Oracle 11g is not available, i.e. Windows IA64, Linux IA64, Linux on Power For these, Oracle 10.2 Extended Support is free Pricing similar to Oracle 9.2 Extended Support Availability Extended Support is available for patch set 10.2.0.5 only until 31 July, 2013 both charged and free Optional extension: Restricted Extended Support Detailed Info See SAP Note 1110995

  21. SAP on Oracle 10gRestricted Extended Support Availability New! August 2013 through July 2015 Except: Itanium platforms until December 2015: Windows IA64, Linux IA64, HP-UX IA64 Terms and Conditions ‘Severity 1’ fixes only No more Critical Patch Updates (CPUs) ‘Restricted ES’ contract required Pricing for SAP ASFU customers under negotiation See SAP Note 1110995

  22. SAP on Oracle 10gSoftware Policy SAP Bundle Patches Starting 1 December, 2011 the following Oracle patch policy is effective: A valid Oracle 10g Extended Support contract is required for downloading Applying any related Oracle 10g patch software from SAP Market Place (SMP): SAP Bundle Patches (SBPs) Patch Set Updates (PSUs) Critical Patch Updates (CPUs) Caution! SBPs etc. for Oracle 10g are visible on SAP Marketplace for all customers. However: Downloading or applying this software is prohibited without a valid Oracle 10g Extended Support contract! Detailed Info: SAP Hot News Note 1654734

  23. Oracle 11g @ SAP

  24. SAP on Oracle 11gCertification Certification Oracle Database 11.2 Release 2 (11.2) only SAP products based on 640_EX2 kernel and later only Restricted to products which are in SAP Extended Maintenance at least until end of 2010 Certification available on all OS platforms Except: Windows IA64, Linux IA64, Linux on Power Detailed Info: See SAP Note 1398634 Oracle 11.2 Instant Client SAP-certified since February 2011 Don’t forget: Update the client from 10.2 to 11.2 to get out of Oracle 10.2 Extended Support obligation!

  25. SAP on Oracle 11gOracle 11.2 Patch Set/PSU Schedule for SAP Patch Set 11.2.0.1 Oracle 11.2 Base Release Released in March 2010 No more individual CPUs and PSUs (July 2011 was last) 10 November, 2011 SBP was last Patch Set 11.2.0.2 1st Patch Set for Oracle 11.2 Released 10 November, 2010 General Availability since mid January 2011 Windows available since 10 May, 2011 September 2012 SAP Bundle Patch contains PSU 7 for 11.2.0.2 (11.2.0.2.7) Last SAP Bundle Patch planned for January 2013 Patch Set 11.2.0.3 2nd Patch Set for Oracle 11.2 Released 12 December, 2011 NEW!HP-UX PA-RISC available since June 2012 Windows available since 14 February, 2012 March 2013 SAP Bundle Patch contains PSU 5 for 11.2.0.3 (11.2.0.3.5) New SAP projects should start on 11.2.0.3 or higher

  26. SAP on Oracle 11gNotes and Documentation (1/2) Entry Notes 1398634 Oracle Database 11g: Integration in SAP Environment 1434131 Release of Oracle 11.2 for older SAP Releases 1431800 Oracle 11.2.0: Central Technical Note 1431799 Oracle 11.2.0: Current Patch Set Regularly Updated on 10th of every month 1631931 Oracle 11.2.0: Patches/Patch Collections for 11.2.0.3 1503709Oracle 11.2.0: Patches/Patch Collections for 11.2.0.2 1431798 Oracle 11.2.0: Database Parameter Settings New Oracle 11.2 Features 1436352 Oracle 11g Advanced Compressionfor SAP Systems 1426979 Oracle 11g: SecureFiles – The New Way to Store LOB Data 1416773 Oracle Direct NFS 1550133 Oracle Automatic Storage Management(ASM)

  27. SAP on Oracle 11gNotes and Documentation (2/2) Installation and Upgrade 1431797 Oracle 11.2.0: Troubleshooting the Database Upgrade 1431796 Oracle 11.2.0: Troubleshooting the Software Installation 1431794 Oracle 11.2.0: Instant Client 1431793 Oracle 11.2.0: Upgrade Scripts Upgrade Guides Oracle 11.2 Database Upgrade http://service.sap.com/instguides  Database Upgrades  Oracle Tools relevant for Oracle 11.2 1430669 BR*Tools Support for Oracle 11g 1027012MOPatch – Install Multiple Oracle Patches in One Run

  28. Oracle 11g – New for SAP AppsOracle Feature Availability - Storage (1/3) Advanced Compression OLTP compression SecureFile compression RMAN Backup compression Data Guard Network compression Data Pump Export compression License for Advanced Compression Option (ACO) required SAP ASFU license includes ACO Index Compression Supported by SAP (since version 10g) No additional license required

  29. Oracle 11g – New for SAP AppsOracle Feature Availability - Storage (2/3) ACO on a customer databases 1) incl. other space optimizations 2) fully reorganized 3) for compressed database

  30. Oracle 11g – News for SAP AppsOracle Feature Availability - Storage (3/3) • Implement SecureFiles Compression • Very important for SAP applications like CRM or XI/PI that store large (uncompressed) amounts of data • Start with Index Compression • Improves R/3 performance the most as all database access in R/3 environments is index-based, especially index range scans • Up to 20% disc space reduction for complete database 1 2 3 4 • RMAN Backup Compression • Additional disk space savings (even if database tables and indexes are already compressed) • Implement OLTP Table Compression • Very good disk space reduction • Same query performance benefit in R/3 environments

  31. Oracle 11g – New for SAP AppsOracle Feature Availability - Encryption Tablespace encryption SecureFile encryption RMAN Backup encryption EXPDP encryption Data Guard Secure Redo Transport Any encryption feature requires Advanced Security Option (ASO) license ASO license is included in SAP ASFU license

  32. Oracle 11g – New for SAP AppsOracle RAC 11.2 and SAPCTL Available on all Unix/Linux and Windows platforms All SAP kernels 640_EX2 and up Option to put OCR and voting disks on ASM (new RAC 11.2 installations only) Upgrades from RAC 10.2 must still use shared file systems for OCR and voting disks Clusterware 11.2 New Clusterware configuration! Same supported technology stacks as hitherto stay in place See ‘SAP on RAC 11.2’ whitepaper and SAP note 527843 for details sapctl 6 and 7 Available (SAP Note 1496827) To manage and control SAP critical resources through Oracle Clusterware ASCS, SCS and ERS; Message Server; Web Dispatcher SAPCTL is bundled with RAC and has to run on the database nodes on the following platforms Linux x86_64 (including Exadata and ODA); Solaris x86_64 (including Exadata); Solaris SPARC (including SPARC SuperCluster); and IBM AIX RAC 11.2 for SAP Whitepaper on SDN – updated March 2011 –

  33. Oracle 11g Oracle ASM for SAP Apps OS Platforms ASM/ACFS available on all platforms Unix/Linux since beginning of February 2011 Windows from end of September 2011 Oracle Oracle 11.2.0.2, or higher Oracle Grid 11.2.0.2, or higher SAP kernel 6.40_EX2 or higher based SAP releases Single Instance and RAC Support ACFS required for RAC installations with ASM (not available on HP-UX) BR*ToolsASM Support is complete Available as of BR*Tools 7.20 Patch 18 See SAP Note 1627541 Documentation Oracle ASM whitepapers on SDN SAP Note 1550133

  34. Oracle Engineered SystemsExadata and Exalogic Oracle Exadata X2 & X3 Support for X2-2, X2-8, X3-2 and X3-8 Oracle Exadata License required x86-64 Oracle Linux or Solaris 11 Oracle 11.2.0.2 or later required Supported for the following SAP products: NW 7.0 or higher Business Objects 4.1 For details see SAP note 1590515. White Paper available on SCN. Oracle Exalogic X2 In combination with Exadata! x86-64 hardware Oracle Linux Oracle 11.2.0.2 or later on Exadata Supported for NW 7.0 or higher based SAP products, Unicode For details see SAP note 1617188

  35. Oracle Engineered Systems SPARC SUPERCLUSTER Oracle SPARC SuperCluster Supported for SAP since end of April, 2012 T4-4 SPARC hardware Solaris 11 Oracle 11.2.0.3 or later Supported for the following SAP products NW 7.0 or higher based SAP solutions Business Objects 4.1 Supported for NW 6.40 or higher based SAP products running on ABAP or Java stack Only 640_EX2 and 720_EXT For details see SAP note 1693680

  36. Oracle Engineered Systems Oracle Database Appliance (ODA) Oracle Database Appliance (ODA) Supported for SAP since end of December, 2012 ODA version 2.4 + ODA OAK Patch 2.4.1 Oracle Linux Oracle 11.2.0.3.4 Supported for the following SAP products NW 7.0 or higher based SAP solutions Business Objects 4.1 For details see SAP note 1785353 White Paper available on SCN

  37. Virtualization Update

  38. Virtualization UpdateOracle VM Oracle VM on x86 Supported for SAP since February, 2013 Minimum OVM Version 3.2.1 Guest OS support: Oracle Linux 5 and 6 SLES 11 (minimum SP2) Solaris 10 and 11 Windows support planned No Red Hat suppport For details see SAP note 1808268 Supported for all SAP Softtware certified for any Guest OS Check PAM for details on OS Availability of SAP products Oracle Database support: Single Instance 10.2.0.5 11.1 (not for NW, but for BO or non-NW products of SAP) 11.2 Support for all Linux guests (except RHEL) Real Application Clusters (RAC) Minimum 11.2.0.3 Supported for Oracle Linux guests only

  39. Operating System Update

  40. Operating System - UpdateSolaris 11 Certified for SAP products based on SAP NetWeaver 2004s and 7.X SPARC x86-64 See SAP note 1669684 for details

  41. Operating System - UpdateOracle Linux Certified for SAP products based on SAP NetWeaver x86-64 Unicode only (both SAP application and database servers) See SAP note 1565179

  42. Operating System - UpdateRed Hat Linux Certified for SAP products based on SAP NetWeaver 2004s and 7.X x86-64

  43. DBA Tools

  44. SAP InstallOracle ASM and more NEW!ASM support integrated in: Software Provisioning Manager 1.0 SP0 Software Logistics Tool Set SP6 for all SAP product versions 7.3X released August, 2012 Software Provisioning Manager 1.0 SP1 Software Logistics Tool Set SP6 for all SAP product versions 7.0X and 7.3X Available since December 2012 Available on SAP Service Marketplace Installing on ASM (See SAP note 1738053) New installation options “Single Instance on ASM” “RAC on ASM” New operating system user and groups OS user oracle OS groups oinstall, asmdba, asmoper, asmadmin Support for ASM on Exadata Setup differs: No +ARCH ASM disk group See SAP note 1619343

  45. Oracle for SAP SecurityABAP Secure Store Background: OPS$ connect vulnerable to attack For recommendations on how to secure OPS$ mechanism against potential attack see SAP Note 157499 ABAP Secure Store strengths database security Database password encrypted in file system Makes OPS$/SAPUSER connect obsolete Allows remote_os_authent=false Available for all 7.X kernel-based SAP versions Optional but recommended for Oracle 10 and 11, mandatory for upcoming Oracle 12c SAP Kernel 7.20 Patch 100 required Available throughout 7.X via 7.20 downwards-compatible kernel (DCK) since Q4/2011 SAP Notes 1623922 Connect to Oracle Database 1622837 New Connect Method of AS ABAP to Oracle via SSFS 157499 OPS$ Connect and Security Aspects

  46. Oracle Secure Store for SAP Security Secure Store NEW! Changing the Database Password brconnect–fchpass now handles both OPS$ Connect (SAPUSER table) Secure Connect ( Secure Store/SSFS) mechanism and changes the password in the proper location. Supports bothABAP and Java Secure Store Expert option –s|–secstore To force or skip changes in a specific SSFS -s|-secstoreabap|abapshd| java|javashd| brtools|none BR*Tools Secure Store combination with ABAP SSFS: Eliminates the need for OPS$ user! Own BR*Tools Secure Store on database server Access through BRT$ADM database user in BR*Tools SSFS instead of OPS$ user Use -u|-user// option with BR*Tools Available with BR*Tools 7.20 Patch 27 See SAP Note 1764043

  47. BR*Tools for SAP Summary Documentation SAP Notes on BR*Tools 1430669 BR*Tools Support for Oracle 11g 1431296 LOB Conversion and Table Compression with BRSPACE 7.20 1428529 Corrections in BR*Tools Version 7.20 1598594 Configuration of BR*Tools for SAP Installations on User ‘oracle’ 1627541 BR*Tools Support for Oracle ASM 1764043 Support for Secure Storage in BR*Tools

  48. SAP on Oracle SAP Community Network Content Page http://scn.sap.com/community/oracle Forum http://scn.sap.com/community/oracle/content

  49. SAP on OracleTwitter and Facebook Twitter http://twitter.com/#!/SAPonOracle Facebook http://www.facebook.com/SAPonOracle

  50. Summary • Oracle Database for SAP • Advanced Compression Option • Better performance, less disk usage • Secure Store • Tighter security • Exadata and Exalogic • X3-2, X3-8 available for all SAP Apps • Oracle VM, Oracle Linux and Oracle Solaris fully supported • Oracle and SAP support your investment • SAPInst, BR*Tools • Joint engineering

More Related