SAP Basis Tech Supports

Symptom
This note describes which Oracle patches on UNIX and which patch collection on Windows for Oracle 10.2.0.4 have been released for an SAP system and must be installed.
You can download the patches or the patch collection from SAP Service Marketplace at: http://service.sap.com/oracle-download -> Oracle 10.2.0.4
This note will be updated once a month. Beyond that, changes will only be made in exceptional cases for critical Oracle patches.
The next updates for this note are scheduled for the following dates:
10. June 2009
10. July 2009
10. August 2009
Other terms

Oracle 10.2.0.4
Reason and Prerequisites
You must apply the patches on UNIX or the patch collection on Windowsafteryou apply the patch set. For more information, see Note 839187.
To apply the current patches or the patch collection, you must follow the instructions contained in the attached README file.
Solution
The following lists the released patches to be installed for UNIX/Linux and the released patch collection to be installed for Windows. At the end, there is a directory of abbreviations used in this note.
Contents:
1. Patches for UNIX and Linux platforms
2. Patch collections for Windows platforms
3. Used abbreviations and explanations

**************************************************************
1. Patches for UNIX and Linux platforms
**************************************************************
This section contains the following specifications:
List of patches that are currently released for SAP and must be installedChange history
List of patches that are released for SAP and must be installed
————————————————————–
Apply all of the patches, optimizer merge patches, and generic patches, which are listed in the following, as described in the relevant README file.
We recommend that you use MOPatch to apply these patches (see Note 1027012). You can also use OPatch (see Note 839182).
When you use MOPatch to apply patches on UNIX/Linux, the system merges the individual patch README files into one README file.
The patches and optimizer merge patches are available at http://service.sap.com/oracle-download -> Oracle 10.2.0.4 -> Database RDBMS in the relevant platform-specific directories. The generic patches are available in the directory “Generic”.

Patches

38. Patch 6331062 Base Bug(s): 6331062
37. Patch 7263842 Base Bug(s): 7263842(*SSN 1320544)
36. Patch 7190270 Base Bug(s): 7190270(*SSN 1320544)
35. Patch 6512811 Base Bug(s): 6512811
34.Patch 7697802 Base Bug(s): 7697802
33.Patch 7523475 Base Bug(s): 7523475
32.Patch 7172531 Base Bug(s): 7172531
31.Patch 7513673 Base Bug(s): 7513673(*SSN 1020937)
30.Patch 6379441 Base Bug(s): 6379441(*SSN 1292525)
29.Patch 6313035 Base Bug(s): 6313035
28. Patch 7573151 Base Bug(s): 7573151(*SSN 1136810 (*HOT)
27. Patch 5561212 Base Bug(s): 5561212(*SSN 1289691)
26. Patch 6775231 Base Bug(s): 6775231
25. Patch 7253620 Base Bug(s): 7253620(*PRT)
24. Patch 6452766 Base Bug(s): 6452766
23. Patch 8299199 Base Bug(s): 7515828 8210889 6795880 6404447
(*SSN 1273790) (*MRG)
22.Patch 7300608 Base Bug(s): 6506617,6714608
(*SSN 1244076) (*MRG) (*HOT)
21. Patch 7149863 Base Bug(s): 7022905,5623467
(*SSN 1226794) (*MRG)
20. Patch 8315012 Base Bug(s): 6962622,5704108,5890312,5934363,
6760697,5970301,7046187,6844739,
6635214,7162648,5386204,7287289,
7575925
(*SSN 1226712) (*MRG)
19. Patch 7027551 Base Bug(s): 7027551
18. Patch 6972843 Base Bug(s): 6972843
17. Patch 6954829 Base Bug(s): 6954829
16. Patch 6944036 Base Bug(s): 6944036
15. Patch 6826661 Base Bug(s): 6826661(*SSN 1144178)
14. Patch 6768114 Base Bug(s): 6768114(*SSN 830576) (*REA)
13. Patch 6679303 Base Bug(s): 6679303(*SSN 1223716)
12. Patch 6645719 Base Bug(s): 6645719
11. Patch 6324944 Base Bug(s): 6324944
10. Patch 6084232 Base Bug(s): 6084232
9. Patch 6082832 Base Bug(s): 6082832
8. Patch 6051177 Base Bug(s): 6051177
7. Patch 6024730 Base Bug(s): 6024730(*SSN 1137389)
6. Patch 5935935 Base Bug(s): 5935935
5. Patch 5923486 Base Bug(s): 5923486
4. Patch 5895190 Base Bug(s): 5895190(*SSN 1166264)
3. Patch 5880921 Base Bug(s): 5880921
2. Patch 5756769 Base Bug(s): 5756769
1. Patch 5747462 Base Bug(s): 5747462

Optimizer Merge Patch
1. Patch 8467800(*SSN 1165319) (*MRG) (*CBO) (*REA)

Generic Patches
2. Patch 6705635 Base Bug(s): 6705635(*GEN) (*REA)
1. Patch 7252962 Base Bug(s): 7204773 6396242(*GEN)
Patch 7252962 is a generic J2EE patch, which you must also apply on the Windows platforms as an additional patch for the normal Windows patch collection.
Change history
29.05.2009
We removed patch 7434973 because it created incorrect index statistics.
08.05.2009
Optimizer merge patch 8467800 added; replaces optimizer merge patch 8299095
Patch 6471770 removed; now contained in optimizer merge patch 8467800
Patch 7695742 removed; the patch is available in the next Optimizer merger patch 13.
Patch 6331062 added
Patch 7434973 added
Platform release: True64 (64-bit) and Windows IA64

09.04.2009
kks* merge patch 8299199 added; replaces kks* merge patch 7522909
kts* merge patch 8315012 added; replaces kts* merge patch 7287289
Patch 6512811 added
Patch 7190270 added
Patch 7263842 added
Patch 7695742 added
10.03.2009
Optimizer merge patch 8299095 added; replaces optimizer merge patch 8201796
Patch 6471770 added
Patch 7172531 added
Patch 7523475 added
Patch 7697802 added
New version of patch 6679303 provided
10.02.2009
Optimizer merge patch 8201796 added; replaces optimizer merge patch 7592168
Generic patch 6934892 removed; now contained in optimizer merge patch 8201796
Patch 6313035 added
Patch 6379441 added
Patch 7513673 added
Platform release: Linux on Power (64-bit)
12.01.2009
Patch 6775231 added
Patch 5561212 added
Patch 7573151 added
Platform release: Solaris x86-64 (64-bit)
10.12.2008
kks* merge patch 7522909 added (see Note 1273790)
Patch 7191744 removed; now contained in the current kks* merge patch 7522909
Patch 6151380 removed and added to optimizer merge patch
Patch 6452766 added
Patch 7253620 added; this patch is port-specific and is relevant only for the HP-UX Itanium platform.
Optimizer merge patch 7592168 added; replaces optimizer merge patch 7522608
Platform release: Linux Itanium (64-bit)
10.11.2008
Patch 5251842 removed due to a patch conflict (see Note 1232043)
Merge patch 7278117 removed; the patches contained in merge patch 7278117 are now contained in optimizer merge patch 7522608
Optimizer merge patch 7522608 added; replaces optimizer merge patch 7228971
25.09.2008
Patch 7191744 added (see Note 1253162)
10.09.2008
Generic patch 6396242 removed and added to merge patch 7252962
05.09.2008
Patch 6917874 removed and added to merge patch 7278117 (see HotNews Note 1248584)
29.08.2008
kkp* merge patch 7300608 added (see HotNews Note 1244076)
22.08.2008
kkp* merge patch 7300608 added (see Note 1244076)
22.08.2008
Patch 6506617 removed and added to merge patch 7300608
15.08.2008
kts* merge patch 7287289 added; replaces merge patch 7046187
15.08.2008
Patch 5386204 removed and added to merge patch 7287289
21.07.2008
The duplicate patch entry was removed.
17.07.2008
Note 1232043 was added.
15.07.2008
First release of Oracle Release 10.2.0.4 for SAP on Unix/Linux

**************************************************************
2. Patch Collections for Windows
**************************************************************
This section lists the current patch collection released by SAP and its previous version. To use Oracle Release 10.2.0.4 with SAP on Windows platforms, you require at least Oracle patch collection 5. In general, use themost recentpatch collection.
On Windows, you can apply a patch collection and additional generic patches if required.
Apply the patch collection and the generic patches as described in the relevant README file for the patch collection or the generic patch. In the patch collection README file, the term “bundle patch” is used instead of “patch collection”.
You must use OPatch to apply the patch collection and the generic patches (see Note 839182).
The current patch collection and its previous version is available at: http://service.sap.com/oracle-download -> Oracle 10.2.0.4 in the directories specific to Windows. The generic patches are available in the directory “Generic”.
You can use the following query to determine the Oracle patch collection that is currently installed in your system:
SQL> select action, namespace, version, id, comments
from dba_registry_history
where version = ‘10.2.0.4.0′
order by action_time desc;

List of patch collections that are released for SAP and must be installed
————————————————————–
Patch collection for platform MS Windows (32-bit)
10204_Patch18_WIN32.zip (Patch: 8307237)
10204_Patch15_WIN32.zip (Patch: 7715044)

Patch collection for platform MS Windows Itanium (64-bit)
10204_Patch18_WINNT64.zip (Patch: 8333678)

Patch collection for platform MS Windows x86-64 (64-bit)
10204_Patch18_MSWIN-x86-64.zip (Patch: 8307238)
10204_Patch15_MSWIN-x86-64.zip (Patch: 7715057)

Generic Windows – Patches
2. Patch 7592030 Base Bug(s): 7592030(*GEN) (*SSN 1292339)
1. Patch 7252962 Base Bug(s): 7204773 6396242(*GEN)
Patch 7252962 is a generic J2EE patch that you must also apply on Windows platforms in addition to the Windows patch collection.
Change history
—————–
08.05.2009
Release of patch collection 18; patch collection 18 contains CPUApr2009.
09.04.2009
Release of generic Windows patch 7592030
10.03.2009
Release of patch collection 15;
10.02.2009
Release of patch collection 14; patch collection 14 contains CPUJan2009
10.12.2008
Release of patch collection 11; patch collection 11 contains CPUOct2008
22.09.2008
Release of patch collection 8;
due to possible ORA-07445 and ORA-00600 errors, you must take account of Note 1253845
15.07.2008
First release of Oracle Release 10.2.0.4 for SAP on Windows

**************************************************************
3. Used abbreviations and explanations
**************************************************************
The following contains abbreviations and their explanations. These abbreviations are used in the list of current patches or patch collections in this note. Also see the glossary in Note 839187. It explains further Oracle terms concerning this topic.
Abbr.MeaningExplanation(*REA)=READ READMESee patch README(*GEN)=GENERICGeneric patch(*SSN)=SEE SAP NOTESee SAP Note(*HOT)=SEE SAP HOTNEWSSee SAP HotNews(*MRG)=MERGEMerge patch (see(*CBO))(*CBO)=CBO-PatchOptimizer mergepatch(*PRT)=PORTPort-specificpatch(*MIS)=MISSINGNot yet available(*CLT)=CLIENTClient patch (seeSAP Note 819829)