Best Practices for SAP on Oracle
Oracle Installation and Upgrade
SAP Installation on Oracle
In the Installation central page you can find several comprehensive technical documents organized by area and release. Master, Installation, Upgrade Configuration and System Copy Guides are available. Note that whenever an SAP Installation takes place there are several pre-requirements that should be performed, so SAP recommendation is to proceed exactly according to the required guide to avoid any issue. The guides can be downloaded from the link:
Remark: You should look for the Oracle related guide for the specific SAP Product you are about to install.
Oracle Upgrade Specific
For a detailed and complete description about the upgrade procedure, you should refer to the following specific SAP upgrade documentation.
Upgrade to Oracle Database 10g Release 2 (10.2): UNIX
Upgrade to Oracle Database 10g Release 2 (10.2): Windows
Upgrade to Oracle Database 11g Release 2 (11.2): UNIX
Upgrade to Oracle Database 11g Release 2 (11.2): Windows
Upgrade to Oracle Database 12c Release 1 (12.1): UNIX
Upgrade to Oracle Database 12c Release 1 (12.1): Windows
Unix/Linux Platforms: SAP Bundle Patches for Oracle Databases
The 2 latest SAP Bundle patches are available on SWDC. At least one SBP must be installed to ensure that the database is working properly. In general, it is recommended to install the latest SBP.
Installing a SAP Bundle Patch
Use MOPatch (SAP Note 1027012) to install the SAP Bundle Patch as described in the SBP README. In particular note, the patch-specific installation instructions. It’s not supported to use OPatch directly to install an SBP or parts of it, except where explicitly stated.
Windows Platforms: Database Patches for Oracle Databases
In general, the 2 latest Bundle patches for Windows platforms are available on SWDC. At least one Bundle patch must be installed to ensure that the database is working properly. In general, it is recommended to install the latest Bundle Patch and all additional generic patches to ensure that the database is working properly. Generic database patches can be applied to 32-bit and 64-bit Oracle homes and must be installed in addition to the Bundle patch.
Installing Bundle Patch and Generic Patches on Windows
Follow the instructions of the bundle patch README to install the bundle patch with OPatch. Follow the instructions of the corresponding patch READMEs to install the generic patch(es) with OPatch. Please also read SAP Note 509314 for more information on how to locate and download Oracle patches.
SAP on Oracle Preventing data loss due to corruptions
Consider reading following SCN post concerning this topic.
Preventing data loss due to block corruption (Best Practices)
SAP on Oracle Development Update
Check the development update for what’s up and coming for SAP on the Oracle database – platform news, Oracle 12.1 & 11.2, RAC, ASM, Oracle Linux, BR*Tools and so on.
SAP on Oracle Key Topics
Find resources for administering your Oracle database with an SAP system, refer to following topics:
Oracle Automatic Storage Management (ASM)
Real Application Clusters (RAC)
How-To: Data Management for Technical Tables
Data Management Guide for SAP Business Suite
Further SAP on Oracle content
To stay tuned with all SAP on Oracle related community, refer to following links:
Join SAP’s Free Feature Trial Program Ask an Expert Peer Today
Ask an Expert Peer, SAP’s new support channel option, is now live as a limited feature trial for select products*. This new channel allows you to get answers, one-on-one, from an industry peer expert outside of SAP. Join SAP’s free feature trial Ask an Expert Peer today! Read the FAQ to learn more.
*SAP Adaptive Server Enterprise, SAP IQ, SAP Replication Server, SAP Adaptive Server Enterprise, and SAP Netweaver Databases: SAP NetWeaver Databases – Oracle Database; SAP ASE, ERP enablement.
Do you have any comments or suggestions? Please post them below.
Nice. Can you also add the following? (so I have a "central" pointer to send customers 😉 )
under key topics the ASM area and Engineered Systems
not sure where, but a pointer to the SAP Note 2388483 - How-To: Data Management for Technical Tables and the Data Management Guide for SAP Business Suite
Finaly, a link to the Oracle documentation (http://docs.oracle.com/en/database/)
Done! Thanks for your remarks.
Jeisson - Nice work on creating a central repository (links) for almost all "SAP on Oracle" topics 🙂
Please update the links as this blog is still checked. The links goes to the older SAP support sites which are not working anymore