Summary
Symptom
Oracle Database 11g Release 2 (11.2) in SAP environments
Start here if you already use or plan to use Oracle Release 11.2.0.X with SAP.
This note is the central note for technical information about Oracle Release 11.2 in SAP environments. It guides you to the corresponding notes from SAP and Oracle about software installation and patching, database upgrades, database parameter settings, instant client compatibility, and so on.
NEWS
2012-07-31
2012-06-06
2011-12-13
2011-09-28
2011-03-15
2011-02-02
2011-01-14
2010-11-10
Oracle Database 11g R2 (11.2)
Orace Database Release 11.2.0.1
Orace Database Release 11.2.0.2
Orace Database Release 11.2.0.3
Reason and Prerequisites
This note is relevant for you if one or more of the following scenarios applies to you:
In My Oracle Support note 988222.1 you find time critical information and highlights related to Oracle Release 11.2.
My Oracle Support note 1189783.1 informs you about important changes to Oracle Database Patch Sets starting with 11.2.0.2.
Oracle Database Documentation Library - Installing and Upgrading
For direct access to New Features Guide, Readme, Universal Installer and OPatch User's Guide, Upgrade Guide and platform specific Installation Guides follow the link:
http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=
Solution
Table of Contents
1. Integration of Oracle Release 11.2 in SAP Environments
2. Checking Prequisites
3. Installing the Software
4. Upgrading the Database
5. Database Configuration
6. Upgrading SAP BR*Tools
7. New Database Features in 11.2
8. New Database Security Features in 11.2
9. Additional Information
1. Integration of Oracle Release 11.2 in SAP Environments
SAP note 1398634 covers the integration schedule for Oracle release 11.2 as well as requirements for SAP releases, SAP Patch Levels, and so on.
2. Checking Prequisites
Before you run your SAP system with Oracle database release 11.2 ensure that the following prerequisites are met.
2.1 Checking the Oracle Instant Client software
Before you upgrade your database to release 11.2, check which versions of the Oracle instant client are compatible with this release and recommended to use.
For Unix/Linux platforms refer to note 1431794.
For Windows platforms refer to note 998004.
2.2 Checking the SAP Kernel
For SAP Systems using the 711 kernel the dbsl (dboraslib.so) must be at least patch level 81 and above. See SAP note 1456323.
3. Installing the Oracle Database Software
For information about Oracle database software installation check the following SAP notes:
New with Oracle Database Release 11.2.0.3
For installations on the following operating systems Oracle Database Release 11.2.0.3 is the minimum required database version:
New with Oracle Database Release 11.2.0.2
SAP Database Upgrade Guides for Oracle Database 11g Release 2
"Upgrade to Oracle Database 11g Release 2 (11.2): UNIX ".
"Upgrade to Oracle Database 11g Release 2 (11.2): Windows ".
To download the current version of the Oracle 11g Upgrade Guide for UNIX /Linux platforms see SAP note 1454627.
Database Upgrade Scripts
SAP-specific database upgrade sripts are provided to automate pre-upgrade and post-upgrade tasks. For detailed information about these scripts, see SAP note 1431793.
Known Database Upgrade Issues
SAP note 1431797 describes solutions and workarounds for known database upgrade issues.
Management of Audit Files
If you observe a higher number of audit files after the database upgrade to 11.2 compared to before, see SAP note 1551504.
5. Database Configuration
Database Parameters
SAP note 1431798 describes parameter settings with Oracle Release 11.2.
Database Maintenance Tasks
SAP note 974781 describes how to configure database internal maintenance jobs (autotasks).
6. Upgrading SAP BR*Tools
SAP note 1430669 describes support of SAP BR*Tools for Oracle Release 11.2.
7. New Database Features in 11.2
SAP note 1583303: Deferred Segment Creation
SAP note 1550133: Oracle Automatic Storage Management (ASM)
SAP Note 1426979: SecureFiles - The new way to store LOB data
SAP Note 1426980: The Real Application Testing Option
SAP Note 1436352: Oracle Advanced Compression for SAP Systems
SAP Note 1416773: Oracle Direct NFS
SAP Note 1431751: Automatic Diagnostics Repository (ADR and ADRCI)
SAP note 974876: Transparent Data Encryption (TDE)
SAP note 1644762: Oracle BigFile Tablespaces
8. New Database Security Features in 11.2
Transparent Data Encryption (TDE)
TDE Tablespace Encryption (TSE) can be used to encrypt tablespaces to protect sensitive SAP application data in data files from unauthorized access. See SAP note 974876.
Database Vault
To protect sensitive SAP application data from unauthorized access through SQL, the database can be configured with Oracle Database Vault. See SAP note 1355140.
SAP specific Database User Profile SAPUPROF
For details see SAP note 1519872.
For password complexity verification function see SAP note 1522952.
9. Additional Information
SAP Application Upgrades
SAP note 1447796: Backward Release of ORACLE 11.2 - Upgrade Information
Oracle Real Application Clusters (RAC)
SAP note 527843: Oracle RAC support in the SAP environment
Use of Raw Devices
New Installations of Oracle 11.2 databases on raw devices is not recommended anymore as Oracle install tools OUI and DBCA do not support raw devices anymore. Oracle plans to desupport raw devices completely with the next version following 11.2.
For further reference see My Oracle Support note 754305.1.
Oracle RAC One Node
The database option "Oracle RAC One Node" is not certified for SAP (see SAP note 105047).
Use of Export/Import Utilites 'exp'/'imp'/'expdp'/'impdp'
The classical utilities 'exp' and 'imp' should not be used any more with 11.2. See SAP note 1712612.
Oracle Database 11g Release 2 (11.2) in SAP environments
Start here if you already use or plan to use Oracle Release 11.2.0.X with SAP.
This note is the central note for technical information about Oracle Release 11.2 in SAP environments. It guides you to the corresponding notes from SAP and Oracle about software installation and patching, database upgrades, database parameter settings, instant client compatibility, and so on.
NEWS
2012-07-31
- Minimum required database release for Solaris 11, Red Hat Enterprise Linux 6 (RHEL 6) and Oracle Linux 6 (OL 6) added
2012-06-06
- Support for Parallel Oracle Homes for minimal downtime patching (see SAP note 1696869)
2011-12-13
- Oracle Database Release 11.2.0.3 released for Unix and Linux platforms.
- Support of Bigfile tablespaces
2011-09-28
- Added SAP note 1597736 about Grid Infrastructure Patches
- added SAP note 1583303 about 'Deferred Segment Creation'
2011-03-15
- SAP note 1551504 describes the real cause for increased amount of audit files and how to cope with it.
2011-02-02
- Oracle Automatic Storage Management (ASM) and ASM Cluster File System (ACFS) have been released for SAP (see SAP note 1550133).
2011-01-14
- Oracle Database Release 11.2.0.2 is released for Unix and Linux platforms. See SAP note 1431799.
Starting 11.2.0.2 patch sets are full installation packages. See SAP note 1524205 for information about the installation procedure.
2010-11-10
- Security: new SAPUPROF database user profile
See SAP note 1519872
Oracle Database 11g R2 (11.2)
Orace Database Release 11.2.0.1
Orace Database Release 11.2.0.2
Orace Database Release 11.2.0.3
Reason and Prerequisites
This note is relevant for you if one or more of the following scenarios applies to you:
- You plan to install Oracle Release 11.2 in an SAP environment.
- You plan to upgrade your database to Oracle Release 11.2.0.X.
- You already run SAP with Oracle Database Release 11.2 and you want to check for news and updates (patches, parameter recommendations, ...)
In My Oracle Support note 988222.1 you find time critical information and highlights related to Oracle Release 11.2.
My Oracle Support note 1189783.1 informs you about important changes to Oracle Database Patch Sets starting with 11.2.0.2.
Oracle Database Documentation Library - Installing and Upgrading
For direct access to New Features Guide, Readme, Universal Installer and OPatch User's Guide, Upgrade Guide and platform specific Installation Guides follow the link:
http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=
Solution
Table of Contents
1. Integration of Oracle Release 11.2 in SAP Environments
2. Checking Prequisites
3. Installing the Software
4. Upgrading the Database
5. Database Configuration
6. Upgrading SAP BR*Tools
7. New Database Features in 11.2
8. New Database Security Features in 11.2
9. Additional Information
1. Integration of Oracle Release 11.2 in SAP Environments
SAP note 1398634 covers the integration schedule for Oracle release 11.2 as well as requirements for SAP releases, SAP Patch Levels, and so on.
2. Checking Prequisites
Before you run your SAP system with Oracle database release 11.2 ensure that the following prerequisites are met.
2.1 Checking the Oracle Instant Client software
Before you upgrade your database to release 11.2, check which versions of the Oracle instant client are compatible with this release and recommended to use.
For Unix/Linux platforms refer to note 1431794.
For Windows platforms refer to note 998004.
2.2 Checking the SAP Kernel
For SAP Systems using the 711 kernel the dbsl (dboraslib.so) must be at least patch level 81 and above. See SAP note 1456323.
3. Installing the Oracle Database Software
For information about Oracle database software installation check the following SAP notes:
- SAP note 1696869 - Support for Parallel Oracle homes
- SAP note 1431799 - Current Patch Set
- SAP note 1631931 - Patches / Patch collections for 11.2.0.3
- SAP note 1503709 - Patches / Patch collections for 11.2.0.2
- SAP note 1431795 - Patches / Patch collections for 11.2.0.1
- SAP note 1597736 - Patches / Patch Collections for Grid Infrastructure 11.2.0.2
- SAP note 1431796 - Troubleshooting the Software Installation
- SAP Note 1027012 - MOPatch - Install Multiple Oracle Patches in One Run
- SAP Note 839182 - Installing patches using OPatch
New with Oracle Database Release 11.2.0.3
For installations on the following operating systems Oracle Database Release 11.2.0.3 is the minimum required database version:
- Red Hat Enterprise Linux 6 (RHEL 6)
See SAP note 1496410.
- Oracle Linux 6 (OL 6)
See SAP note 1635808.
- Solaris 11
See SAP notes 1669684 and 1643799.
New with Oracle Database Release 11.2.0.2
- SAP note 1524205 - Database Software Installation
- SAP note 1525025 - Database Software Deinstallation
- SAP note 1521371 - Setting of ORACLE_BASE in SAP environments
SAP Database Upgrade Guides for Oracle Database 11g Release 2
"
"
To download the current version of the Oracle 11g Upgrade Guide for UNIX /Linux platforms see SAP note 1454627.
Database Upgrade Scripts
SAP-specific database upgrade sripts are provided to automate pre-upgrade and post-upgrade tasks. For detailed information about these scripts, see SAP note 1431793.
Known Database Upgrade Issues
SAP note 1431797 describes solutions and workarounds for known database upgrade issues.
Management of Audit Files
If you observe a higher number of audit files after the database upgrade to 11.2 compared to before, see SAP note 1551504.
5. Database Configuration
Database Parameters
SAP note 1431798 describes parameter settings with Oracle Release 11.2.
Database Maintenance Tasks
SAP note 974781 describes how to configure database internal maintenance jobs (autotasks).
6. Upgrading SAP BR*Tools
SAP note 1430669 describes support of SAP BR*Tools for Oracle Release 11.2.
7. New Database Features in 11.2
SAP note 1583303: Deferred Segment Creation
SAP note 1550133: Oracle Automatic Storage Management (ASM)
SAP Note 1426979: SecureFiles - The new way to store LOB data
SAP Note 1426980: The Real Application Testing Option
SAP Note 1436352: Oracle Advanced Compression for SAP Systems
SAP Note 1416773: Oracle Direct NFS
SAP Note 1431751: Automatic Diagnostics Repository (ADR and ADRCI)
SAP note 974876: Transparent Data Encryption (TDE)
SAP note 1644762: Oracle BigFile Tablespaces
8. New Database Security Features in 11.2
Transparent Data Encryption (TDE)
TDE Tablespace Encryption (TSE) can be used to encrypt tablespaces to protect sensitive SAP application data in data files from unauthorized access. See SAP note 974876.
Database Vault
To protect sensitive SAP application data from unauthorized access through SQL, the database can be configured with Oracle Database Vault. See SAP note 1355140.
SAP specific Database User Profile SAPUPROF
For details see SAP note 1519872.
For password complexity verification function see SAP note 1522952.
9. Additional Information
SAP Application Upgrades
SAP note 1447796: Backward Release of ORACLE 11.2 - Upgrade Information
Oracle Real Application Clusters (RAC)
SAP note 527843: Oracle RAC support in the SAP environment
Use of Raw Devices
New Installations of Oracle 11.2 databases on raw devices is not recommended anymore as Oracle install tools OUI and DBCA do not support raw devices anymore. Oracle plans to desupport raw devices completely with the next version following 11.2.
For further reference see My Oracle Support note 754305.1.
Oracle RAC One Node
The database option "Oracle RAC One Node" is not certified for SAP (see SAP note 105047).
Use of Export/Import Utilites 'exp'/'imp'/'expdp'/'impdp'
The classical utilities 'exp' and 'imp' should not be used any more with 11.2. See SAP note 1712612.
Header Data
| Release Status: | Released for Customer |
| Released on: | 31.07.2012 15:12:52 |
| Master Language: | English |
| Priority: | Recommendations/additional info |
| Category: | Consulting |
| Primary Component: | BC-DB-ORA Oracle |
Affected Releases
Release-Independent
Related Notes
No comments:
Post a Comment