SAP on Oracle Database 12c
Download
Report
Transcript SAP on Oracle Database 12c
SAP on Oracle
Development Update
March 2016
Dr. Christian Graf
Development Manager
DB Platforms Oracle & Informix
OS Platform Solaris
SAP SE
Disclaimer
The information in this presentation is confidential and proprietary to SAP and may not be disclosed without the permission of SAP. This presentation is not subject to your
license agreement or any other service or subscription agreement with SAP. SAP has no obligation to pursue any course of business outlined in this document or any
related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation and SAP's strategy and possible future
developments, products and/or platforms directions and functionality are all subject to change and may be changed by SAP at any time for any reason without notice. The
information on this document is not a commitment, promise or legal obligation to deliver any material, code or functionality. This document is provided without a warranty of
any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. This
document is for informational purposes and may not be incorporated into a contract. SAP assumes no responsibility for errors or omissions in this document, and shall have
no liability for damages of any kind including without limitation direct, special, indirect, or consequential damages that may result from the use of this document. This
limitation shall not apply in cases of intent or gross negligence. All forward-looking statements are subject to various risks and uncertainties that could cause actual results
to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates, and they
should not be relied upon in making purchasing decisions.
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
2
Agenda
SAP on Oracle Database 11g
SAP on Oracle Database 12c
Oracle Database In-Memory
Oracle Advanced Data Optimization
Engineered Systems Update
Miscellaneous
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
3
SAP on Oracle Database 11g
SAP on Oracle Database 11g
Extended Support
Oracle Database 11g entered Extended Support on February 1, 2015.
Period of waived Oracle 11g ES fees extended to 2+ years
No extra charges until May 31, 2017
Automatic participation
Supported releases: 11.2.0.4
Caution: Oracle 11.2.0.3 left Oracle support end of August 2015
11g Extended Support ends December 31, 2020
Future note 2205728 to provide order information
For details see
SAP Note 2098258
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
5
SAP on Oracle Database 11g
Release in Extended Support
Patch Set 11.2.0.4
3rd and Final Patch Set for Oracle 11.2
Released February 14, 2014
General Availability since February 2014
Windows Cluster available since May 2014
February 2016 SBP is most recent and contains
PSU 160119 for 11.2.0.4 (11.2.0.4.160119)1)
See SAP Note 1431799 for support dates
1) Cmp. SAP Note 2275604 for the recent changes in Oracle patch numbering
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
6
SAP on Oracle Database 12c
SAP on Oracle Database 12c
Certification
Oracle Database 12c Release 1 (12.1)
Certified for Business Suite based on SAP NetWeaver starting March 31, 2015
Including:
Oracle RDBMS 12c
Oracle Grid Infrastructure 12c1)
Oracle Real Application Clusters (RAC) 12c
Requirements
Minimum Oracle version is 12.1.0.2 with initial SAP Bundle Patch (12.1.0.2.2)
SAP Kernel 7.21_EXT or higher
For details see
SAP Notes 2133079 and 1914631
1) Support for both RDBMS 11.2.0.4 and 12.1.0.2, see SAP Note 1677978
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
8
SAP on Oracle Database 12c
Supported Release
Patch Set 12.1.0.2
1st and Final Patch Set for Oracle 12.1
Released March 31, 2015
All OS platforms available from start
February 2016 SBP is most recent and contains
PSU 160119 for 12.1.0.2 (12.1.0.2.160119)1)
See SAP Note 1915313 for support dates
1) Cmp. SAP Note 2275604 for the recent changes in Oracle patch numbering
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
9
SAP on Oracle Database 12c
Products Support
The following SAP products are certified with Oracle Database 12.1:1)
See the SAP Product Availability Matrix (PAM) for product versions released with Oracle 12c
SAP NetWeaver 7.0, 7.1, 7.3, 7.40, 7.50
SAP BW 7.0/7.0X, 7.1X, 7.20, 7.3X, 7.40, 7.50
SAP ERP 6.0
SAP CRM 7.0
SAP SCM 7.0
SAP SRM 7.0
Banking Services from SAP 6.0, 7.0, 8.0, 9.0
SAP Solution Manager 7.1, 7.2
SAP NW CE 7.1, 7.20
SAP NW PI 7.1
SAP LVM 2.1 and higher
SAP MDM 7.1 SP15
1) including all corresponding EhPs
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
10
SAP on Oracle Database 12c
Features
Features supported as of certification
The following features are available with initial certification:
Advanced Index Compression1)
Automatic prefix computation
Higher compression rate, ease of use
Client-Server Network Compression1)
Less network load between application servers and database instance(s)
ACO Table Compression: Support for > 255 columns
ACFS Support on Exadata
for SAP shared file system support (/sapmnt, etc.)
1) requires Advanced Compression Option
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
11
SAP on Oracle Database 12c
Features
Features supported as of certification (continued)
The following features are available with initial certification:
RAC: HA-NFS support with ACFS
Complete SAP HA solution for shared file system
RMAN: Cross platform backup and restore1)
Easier heterogeneous platform migration
Storage Snapshot Optimization
No more begin/end backup for certain snapshot technologies
Active Data Guard Far Sync2)
High performance zero data loss across large distance WAN
Online Move Partition, Move a Datafile Online
1) Source and destination platform endianness needs to be the same 2) requires Active Data Guard Option
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
12
BR*Tools 7.40
Support for Oracle 12c
BR*Tools 7.40 Patch 14
Move Data File Online
Online MOVE PARTITION
Support for Advanced Index Compression
Compression of tables with > 255 columns
Reorganization of tables with long names
Oracle Wallet in ASM
For details see
SAP Note 2087004
BR*Tools 7.40 Patch 17
Oracle Database In-Memory
BR*Tools 7.40 Patch 19
Oracle ILM/ADO
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
13
SAP on Oracle Database 12c
Notes & Documentation
Entry Notes
Oracle 12.1 Features
2133079 Oracle Database 12c: Integration in SAP Environment
2138262 Oracle Database 12c Advanced Compression for
SAP Systems
1914631 Central Technical Note for Oracle Database 12c
Release 1 (12.1)
1915313 Current Patch Set for Oracle Database 12c
Release 1 (12.1)
Regularly Updated
on 10th of every month
2178980 Using Oracle Database In-Memory with SAP NetWeaver
based Products
2254866 Using Oracle Database 12c Advanced Data Optimization
with SAP NetWeaver
Tools
2087004 BR*Tools Support for Oracle 12c
1915316 Database: Patches for Oracle 12.1.0.2
1888485 Database Parameters for Oracle 12.1.0.2
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
14
SAP on Oracle Database 12c
Notes & Documentation
Installation and Upgrade
1915302 Database Software 12.1.0.2 Installation on Windows
1915301 Database Software 12.1.0.2 Installation on Unix
1915299 Troubleshooting Software Installation for 12.1.0.2
White Papers
Real Application Clusters (RAC)
Upgrade of SAP NetWeaver Installation to Oracle Grid
Infrastructure 12.1.0.2 with Oracle Real Application
Clusters 12c Release 1
Providing High Availability for SAP Resources with Oracle
Clusterware 11g Release 2 and Clusterware 12c Release 1
Upgrade Guides
Oracle 12.1 Database Upgrade
http://service.sap.com/instguides
Database Upgrades
Oracle
Exadata
Using SAP NetWeaver with Oracle Database 12c on
Oracle Exadata
In-Memory
Using SAP NetWeaver with Oracle Database In-Memory
Advanced Data Optimization
Using SAP NetWeaver with Oracle Database 12c Automatic
Data Optimization and Information Lifecycle Management
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
15
SAP on Oracle 12c
Oracle Database In-Memory
Oracle Database In-Memory
Certification
Oracle Database In-Memory
Certified for SAP since June 30, 2015
Requirements
Oracle Database 12c Release 12.1.0.21) or higher
Including RAC 12c and Engineered Systems
SAP NetWeaver 7.X with kernel 7.21_EXT or higher
SAP DDIC < 7.40 SP12 has limited IM support
SAP Products Support
Business Suite based on SAP NetWeaver
ERP, CRM, SRM, SCM, BW, PI, …
Industry solutions
Check SAP Product Availability Matrix (PAM)
for full list
For details see
SAP Note 2178980
Oracle In-Memory white paper on SCN
1) with June 2015 SAP Bundle Patch (Unix) or Database Bundle Patch 12.1.0.2.6
(Windows)
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
17
Oracle Database In-Memory
Approaches
APPROACH 1
APPROACH 2
Using the Database In-Memory Advisor
Object candidates for In-Memory are known
Situation
Situation
Tables/partitions recommended/suitable for
In-Memory are yet unknown
Action
Run IM Advisor for recommendations
Adjusted to SAP specifications
Relies on 2–3 days of Automatic Workload
Repository (AWR) and/or SQL –Tuning Set data
See Oracle In-Memory white paper on SCN for
detailed procedure
Reports with long running queries processing large
amounts of data have already been identified
Action
Put these tables/partitions in IM column store
Use SAP_IM_ADV package1) for column store
sizing
See Oracle In-Memory white paper on SCN for
detailed procedure
1) included in SAP Bundle Patch
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
18
Oracle Database In-Memory
Conventions
Index Design
Changes to SAP standard1) index design are
not allowed:
No dropping
No setting invisible or unusable
Individual Columns
All columns of SAP standard tables must be
loaded into In-Memory column store
No loading of individual columns
No exclusion of individual columns
Database Buffer Cache
Reducing buffer cache size in favor of IM
column store is not allowed
Always use additional memory for IM
SAP BW Aggregates
Dropping all aggregates from existing BW
system is not recommended
Aggregates are designed for providing good
throughput in concurrent user environments
1) Custom indices in customer namespace are not affected, changes are allowed
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
19
Oracle Database In-Memory
Licenses
Oracle Database In-Memory
requires the following licenses:
Oracle Full Use customers require licenses for
Oracle Database In-Memory Option
if Database In-Memory has been deployed
Oracle Database In-Memory Advisor
requires the following licenses:
Oracle Full Use customers require licenses for
Oracle Tuning Pack
Oracle Diagnostics Pack
if Database In-Memory has been deployed
SAP ASFU customers purchase “Oracle In-Memory
License Package”
See SAP price list for details
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
These packs are included in SAP ASFU license
Customer
20
SAP on Oracle 12c
Advanced Data Optimization
Oracle Advanced Data Optimization
Certification
Oracle Database 12c Advanced Data Optimization
NEW! Certified for SAP since December 31, 20151)
Purpose
Compress data depending on access frequency:
Classify data into cold, warm, hot
Heat Map
Compress data per heat map-based policy
Allows for very flexible, dynamic data compression
Requirements
Oracle Database 12c Release 12.1.0.22) or higher
Oracle Hybrid Columnar Compression (HCC):
only in combination with ADO
limited to row level locking
SAP NetWeaver 7.40 SP12 | 7.50 SP2 or higher
For details see
SAP Note 2254866
Oracle ILM/ADO white paper on SCN
1) Unix/Linux only. Windows planned for Q1CY2016
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
2) with November 2015 SAP Bundle Patch (Unix)
Customer
22
Oracle Advanced Data Optimization
Licenses
Oracle Database 12c Advanced Data Optimization
requires the following licenses:
Oracle Full Use customers require license for
Oracle Advanced Compression Option (ACO)
if Advanced Data Optimization has been deployed
Oracle ACO is included in SAP ASFU license
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
23
Engineered Systems Update
Engineered Systems Update
Exadata | Exalogic & Co.
Oracle Exadata Database Machine X2 – X5
Support for X2-2|8, X3-2|8, X4-2|8 and X5-2|8
Exadata license required
See SAP Note 1590515
Oracle Exadata white paper on SCN
Oracle Exalogic X2 – X5
Support for X2-2, X3-2, X4-2 and X5-2
Virtual Exalogic (using Oracle VM)
except for X5-2. Planned for 2016
Only in combination with Exadata
See SAP Note 1617188
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Oracle SPARC SuperCluster
Supported for SAP since 2012
See SAP Note 1693680
Oracle Database Appliance
Support for V1, X3-2 and X4-2
X5-2 planned for Q2CY2016
See SAP Note 1760737
Oracle ODA white paper on SCN
Customer
25
Engineered Systems Update
Private Cloud Appliance
Oracle Private Cloud Appliance X3 – X5
Engineered system designed for virtualization
Supported for SAP since September 2014
Starting from Oracle PCA Version 1.1.3
Based on Oracle VM
SAP Products Support
All SAP products and database versions certified
for supported guest OS
Check SAP Product Availability Matrix (PAM)
Guest Operating Systems Support
Oracle Linux 5, 6 and 7
UEK only
Oracle Solaris 10 and 11
For details see
SAP Note 2052912
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
26
Miscellaneous
BR*Tools 7.40
Enhancements in BRBACKUP and BRRECOVER
BRBACKUP
Consistent Online Backup of Standby Database
Backup of Standby Database for a Primary Oracle RAC Database
Creation of Copy of ASM Databases
Creation of a Single Instance Database from a RAC Database
For details see
SAP Note 1844380
BRRECOVER
Reconfiguration of Online Redo Log Files during a Recovery
For details see
SAP Note 2086966
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
28
SAP on Oracle
SAP Community Network
Content Page
http://scn.sap.com/community/oracle
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Forum
http://scn.sap.com/community/oracle/content
Customer
29
SAP on Oracle
Twitter
Follow us on Twitter®
https://twitter.com/SAPonOracle
Get instant notification about…
SAP Hot News
Product Certifications
Best Practices
and a lot more…
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Customer
30
Thank You!