Solution : https://service.sap.com/sap/support/notes/1431800 (SAP Service marketplace login required)
Summary :
This SAP note provides extensive guidance on integrating and managing Oracle Database 11g Release 2 (11.2) within SAP environments. It encompasses detailed instructions for software installations, patching, upgrades, and configurations specific to Oracle 11.2. Key updates include support for new Oracle Homes to minimize downtime during patching, the release of Oracle Database 11.2.0.3 for Unix and Linux, and the use of Bigfile tablespaces. Security enhancements such as the SAPUPROF database user profile are noted, alongside essential prerequisites such as compatible Oracle Instant Client versions and kernel requirements for SAP systems.
Key words :
parallel oracle homes sap note 1431799 - current patch set sap note 1631931 - patches / patch collections, 2 sap note 1524205 - database software installation sap note 1525025 - database software deinstallation sap note 1521371 - setting, software installation sap note 1027012 - mopatch - install multiple oracle patches, export/import utilites 'exp'/'imp'/'expdp'/'impdp', database configuration database parameterssap note 1431798 describes parameter settings, sap specific database user profile sapuproffor details, upgrading sap br tools sap note 1430669 describes support, database upgrade scriptssap-specific database upgrade sripts, database vaultto protect sensitive sap application data, database upgrade issuessap note 1431797 describes solutions
Related Notes :
1712612 | Oracle 11g: Usage of exp with 11.2 / 11g |
1696869 | Strategy for Patching of Oracle Homes with Minimal Downtime |
1696570 | Oracle SPARC SuperCluster: Patches for 11.2.0.3 |
1693680 | Running SAP Software on Oracle SPARC SuperCluster |
1656659 | GI 11.2.0: Patches / Patch Collections for 11.2.0.3 |
1656654 | Exadata 11.2.0: Patches for 11.2.0.3 |
1644762 | Oracle bigfile tablespaces |
1643799 | Support for Solaris 11 |
1635808 | Oracle Linux 6.x SAP Installation and Upgrade |
1631931 | Oracle 11.2.0: Patches / Patch collections for 11.2.0.3 |
1597736 | GI 11.2.0: Patches / Patch Collections for 11.2.0.2 |
1591389 | Exadata 11.2.0: Patches for 11.2.0.2 |
1590515 | SAP Software and Oracle Exadata |
1583303 | Deferred Segment Creation |
1571062 | Changing the Timezone for an Oracle RAC Database |
1551504 | Cleaning up Oracle audit files |
1550133 | Oracle Automatic Storage Management (ASM) |
1521371 | Oracle 11.2.0: Setting of ORACLE_BASE in SAP environments |
1519872 | SAP Database User Profile SAPUPROF |
1503709 | Oracle 11.2.0: Patches / Patch collections for 11.2.0.2 |
1496410 | Red Hat Enterprise Linux 6.x: Installation and Upgrade |
1478351 | Oracle 11g Support on UNIX: 6.40-Based SAP Systems |
1478350 | Oracle 11g Support on UNIX: 7.0/7.01/7.02-Based SAP Systems |
1478060 | Oracle 11g Support on Windows: SAP NW 7. |
1478059 | Oracle 11g Support on Windows: 6.40-Based SAP Systems |
1456323 | Program termination when accessing LOB columns |
1454627 | Additional Info / Corrections to Oracle 11g Upgrade Guide |
1436352 | Oracle Database 11g Advanced Compression for SAP Systems |
1431799 | Oracle 11.2.0: Current Patch Set |
1431798 | Oracle 11.2.0: Database Parameter Settings |
1431797 | Oracle 11.2.0: Troubleshooting the Database Upgrade |
1431796 | Oracle 11.2.0: Troubleshooting the Software Installation |
1431795 | Oracle 11.2.0: Patches/Patchcollections for 11.2.0.1 |
1431794 | Oracle 11.2.0: Instant Client |
1431793 | Oracle 11.2.0: Upgrade Scripts |
1431751 | Quick Reference for ADRCI and ADR |
1430669 | BR*Tools support for Oracle 11g |
1426980 | Oracle 11g: The Real Application Testing Option |
1426979 | Oracle 11g: SecureFiles - The new way to store LOB data |
1416773 | Oracle Direct NFS |
1398634 | Oracle database 11g: Integration in SAP environment |
1027012 | MOPatch - Install Multiple Oracle Patches in One Run |
974876 | Oracle Transparent Data Encryption (TDE) |
974781 | Oracle internal maintenance jobs |
839182 | Installing patches using OPatch |
527843 | Oracle RAC support in the SAP environment |