SAPTechno

Note 1431752 - Oracle 10.2.0: Patches/Patch Collections for 10.2.0.5

Version : 43 / 2013-08-15


Symptom

Oracle 10.2.0.5.0 Extended Support


If you want to download Oracle 10.2.0.5.0 patches, please see SAP Hot News note 1654734 first. That note provides important information about a new download policy valid in the Oracle Extended Support phase.

Migration of Oracle Patches on the SAP Support Portal


Due to legal reasons the Oracle patches on the SAP Support Portal must be migrated from their current location, the "Database Patches" area located at http://service.sap.com/oracle-download, to the SAP Software Download Center at http://service.sap.com/swdc. That migration affects also the names of the Oracle patches provided on the SAP Software Download Center, both for the Unix and the Windows platforms.

Oracle will migrate its patches to the SAP Software Download Center according to the following schedule:

  10.2.0.5.0: Patchday February 2013
  11.2.0.2.0: Patchday May 2013
  11.2.0.3.0: Patchday June 2013

For more information about the migration process, see SAP Note 509314.

Oracle Database Patches for 10.2.0.5 for SAP


This note describes which patches for Oracle Database release 10.2.0.5 are released for SAP. All the patches mentioned in this note need to be installed to ensure that the SAP system functions properly.

To download Oracle 10.2.0.5.0 patches from the SAP Support Portal follow the path below:

  http://service.sap.com/oracle
  -> Oracle Patches 10.2.0.5 (in the right-hand side info page)

The next updates for this note are scheduled for the following dates:

   no further regular SBP for 10.2.0.5 scheduled

Please note, CPUJul2013 will be the terminal PSU/CPU for the Oracle release 10.2.0.5. The CPUJul2013 is scheduled within the SAP Bundle Patch (SBP) SAP10205P_1308 in August 2013.

Besides those scheduled updates this note will change in exceptional cases only.


Other Terms


Oracle Release 10.2.0.5
Patch Set Update / PSU
SAP Bundle Patch / SBP


Reason and Prerequisites


You must apply the SAP Bundle Patches on Unix/Linux or the patch collection on Windows. For more information, see Note 839187.

To apply the current SAP bundle patches or the patch collection, you must follow the instructions of the corresponding README.


Solution

Contents of this note


1.  SAP Bundle Patches for Unix Platforms
1.1 SAP Bundle Patches released for SAP
1.2 SAP Bundle Patch Information
1.3 Installing an SAP Bundle Patch
1.4 Change history (Unix)

2.  Patch Collections for Windows Platforms
2.1 Patch Collections released for SAP
2.2 Generic Windows Patches
2.3 Change History (Windows)

1. SAP Bundle Patches for Unix Platforms

1.1 SAP Bundle Patches released for SAP

The last 2 SBPs are listed:

Oracle Release SBP Release Date SBP Name

10.2.0.5.12 2013-08 SAP10205P_1308
10.2.0.5.11 2013-05 SAP10205P_1305


SAP Bundle Patch SAP10205P_1302 requires at least MOPatch version 2.1.14.  Update your MOPatch version according to the instructions in the SBP readme before installing the SBP itself.

1.2 SAP Bundle Patch Information

This section contains corrections and important information regarding the installation of the SBPs listed above.

22. November 2011

Based on a technical reason (missing Merge 12750959) the SBP SAP_102055_201111 has been withdrawn. Customers who already applied this SBP should apply December SBP SAP_102055_201112 as soon as it is available.

1.3 Installing an SAP Bundle Patch
    1. Follow the path below:

      http://service.sap.com/oracle
      -> Oracle Patches 10.2.0.5 (in the right-hand side info page)
    2. Open the platform directory and download the SAP Bundle Patch file SAP<Release>P_<Date>-<GUID>.ZIP, the SBP README README<Release>P_<Date>-<GUID>.HTM, and the SBP patch history BUGSFIXED<Release>P_<Date>-<GUID>.HTM to your database server.
    3. Use MOPatch (SAP note 1027012) to install the SAP bundle patch in accordance with the instructions in the SBP README. When you do this, pay particular attention to the patch-specific installation instructions.


Remarks:

  • Due to the complexity, the installation of a new PSU (if it is contained in the SAP bundle patch) takes a considerably longer amount of time than a normal installation of an individual patch. The runtime depends on how powerful your database server is. You can track the progress of the installation in the MOPatch log file specified below.
  • You must use MOPatch to install SBPs. The direct use of OPatch to install SBPs or individual patches from an SBP is not supported unless specifically stated.

1.4 Change history (Unix)


15. August 2013
SAP10205P_1308 released for customers (includes CPUJul2013).

14. August 2013
SAP10205P_1308 is delayed.
The next planned release date for this SBP is 16. August 2013.


15. May 2013
SAP10205P_1305 released for customers (includes CPUApr2013).

14. February 2013
SAP10205P_1302 released for customers (includes CPUJan2013).
This SBP is the first released on the new SAP Software Download Center.
This SBP requires MOPatch 2.1.14.

10. January 2013
No SBP scheduled.

11. December 2012
No SBP scheduled.

16. November 2012
SBP_102059_201211 released for customers (includes CPUOct2012)

13. November 2012
SBP_102059_201211 is delayed.
The next planned release date for this SBP is 15. November 2012.

11. October 2012
No SBP scheduled.

13. September 2012
No SBP scheduled.

14. August 2012
SBP_102058_201205 released for customers (includes CPUJul2012)

10. July 2012
SBP_102057_201207 released for customers

12. June 2012
SBP_102057_201206 released for customers

15. May 2012
SBP_102057_201205 released for customers (includes CPUApr2012)

10. May 2012
SBP_102057_201205 is delayed.
The next planned release date for this SBP is 15. May 2012.

12. April 2012
No SBP scheduled.

13. March 2012
SBP_102056_201203 released for customers

14. February 2012
SBP_102056_201202 released for customers (includes CPUJan2012)

11. January 2012
No SBP scheduled.

13. December 2011
SBP_102055_201112 released for customers

10. November 2011
SBP_102055_201111 released for customers (includes CPUOct2011)

12. October 2011
SBP_102054_201110 released for customers

13. September 2011
SBP_102054_201109 released for customers

10. August 2011
SBP_102054_201108 released for customers (includes CPUJul2011)

13. July 2011
SBP_102053_201107 released for customers

10. June 2011
SBP_102053_201106 released for customers
SBP for platforms Linux IA64 and Linux on Power released for customers.

12. May 2011
SBP_102053_201105 released for customers (includes CPUApr2011)

12. April 2011
SBP_102052_201104 released for customers

11. March 2011
SBP_102052_201103 released for customers

10. February 2011
SBP_102052_201102 released for customers (includes CPUJan2011)

11. January 2011
SBP_102051_201101 released for customers

Please note: As described in the README.htm you have to de-install patch 10111124 manually before applying the SBP_102051_201101.


14. December 2010
SBP_102051_201012 released for customers


10. November 2010
SBP_102051_201011 released for customers (includes CPUOct2010)

This SBP contains a new MOPatch version (2.1.5), which has to be installed before the SBP will be applied. Please see the SBP README.

2. Patch Collections for Windows Platforms


General Information

  • The last two (most recent) Oracle patch collections released by SAP for each Windows platform are listed. It is recommended to use the most recent patch collection.
  • Additional required generic patches are also listed.
  • Please apply Oracle patch collection and Oracle 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".
  • To apply the patch collection and the generic patches use OPatch (see Note 839182).
  • In order to determine which Oracle patch collection is currently installed in your system, use the following query:
    SQL> select action, namespace, version, id, comments
        from dba_registry_history
        where version = '10.2.0.5.0'
         order by action_time desc;
  • To install all generic patches in one opatch run, download all the patch files into a patch directory <patch_dir> on your database server, open a command window and run 'opatch napply <patch_dir>' (without extracting the patch files before).


2.1 Patch Collections released for SAP


Patch collections MS Windows x86-64 (64-bit)

PATCHBUNDLE10205P_22-10010776.ZIP (Patch: 16803782)
PATCHBUNDLE10205P_20-10010776.ZIP (Patch: 15848062)

Patch collections for platform MS Windows (32-bit)

PATCHBUNDLE10205P_22-10010774.ZIP (Patch: 16803780)
PATCHBUNDLE10205P_20-10010774.ZIP (Patch: 15848060)

Patch collections for platform MS Windows Itanium (64-bit)

PATCHBUNDLE10205P_22-10010775.ZIP (Patch: 16803781)
PATCHBUNDLE10205P_20-10010775.ZIP (Patch: 15848061)

Be aware that you are required to hold a valid Oracle 10.2 Extended Support contract to request, download or deploy 10.2.0.5 patch collections. However, Oracle 10.2 Extended Support is free for Windows on Itanium.

2.2 Generic Windows Patches


P9445675GEN10205P_1-*.ZIP
P9584028GEN10205P_1-*.ZIP
P9843740GEN10205P_1-*.ZIP
P10357961GEN10205P_1-*.ZIP
P13617518GEN10205P_1-*.ZIP

2.3 Change History (Windows)


14. August 2013
Patchcollection 22 released for customers (includes CPUJul2013).

14. February 2013
Patchcollection 20 released for customers (includes CPUJan2013).
This patchcollection is the first released on the new SAP Software Download Center.

13. November 2012
Patchcollection 19 released for customers (includes CPUOct2012)

14. August 2012
Patchcollection 18 released for customers (includes CPUJul2012)

10. May 2012
Patchcollection 16 released for customers (includes CPUApr2012)

13. March 2012
Generic patch 10431010 removed
Generic patch 13617518 released for customers

27. February 2012
Status update for MS Windows Itanium platform

14. February 2012
Patchcollection 14 released for customers (includes CPUJan2012)

10. November 2011
Patchcollection 12 released for customers (includes CPUOct2011)

17. October 2011
Patchcollection 10: patch numbers of patchcollection 10 rectified

10. August 2011
Patchcollection 10 released for customers (includes CPUJul2011)

13. July 2011
Generic patch 9445675 released for customers

10. May 2011
Patchcollection 08 released for customers (includes CPUApr2011)

12. April 2011
Generic patch 9843740 released for customers

10. February 2011
Patchcollection 05 released for customers (includes CPUJan2011)

25. January 2011
10.2.0.5 Patch collections for Windows Itanium are not available.

14. December 2010
Patchcollection 04 released for customers

10. November 2010
Patchcollection 01 released for customers (includes CPUOct2010)



Other Attributes

ORACLE
Oracle 10.2

Header Data

Released On 15.08.2013 14:12:41
Release Status Released for Customer
Component BC-DB-ORA Oracle
Other Components
BC-DB-ORA-INS Installation SAP System with Oracle
Priority Correction with high priority
Category Installation information

Validity

This document is not restricted to a software component or software component version

References

This document refers to:

SAP Notes
1900628   SPU - Oracle Security Patch Update July 2013
1860292   CPU Patches April 2013 (Oracle Critical Update Program)
1822955   CPU Patches January 2013 (Oracle Critical Update Program)
1790307   CPU Patches October 2012 (Oracle Critical Update Program)
1753600   CPU Patches July 2012 (Oracle Critical Update Program)
1718792   CPU Patches April 2012 (Oracle Critical Update Program)
1684424   CPU Patches January 2012 (Oracle Critical Update Program)
1654734   Ext Support contract required for 10.2.0.5 PSU, SBP & Client
1651427   CPU Patches October 2011 (Oracle Critical Update Program)
1633801   DBV check code 6401 when using transportable tablespaces
1619685   CPU Patches July 2011 (Oracle Critical Update Program)
1590858   CPU Patches April 2011 (Oracle Critical Update Program)
1525673   Optimizer merge fix for Oracle 10.2.0.5
1461804   Query failed with ORA-00600 [kdsgrp1]
1237838   Current version of pre-upgrade information script
1227404   Oracle Database 10g: Oracle Configuration Manager (OCM)
1175996   Oracle 10g/11g patches check
1027012   MOPatch - Install Multiple Oracle Patches in One Run
1017936   Oracle Database 10g: Upgrade history
871735   Current patch set for Oracle 10.2.0
850306   Oracle Critical Patch Update Program
839187   Oracle 10.2.0: Applying patch set/patches/patch collection
839182   Oracle patch installation with OPatch
830576   Parameter recommendations for Oracle 10g
819829   Oracle Instant Client Installation and Configuration on Unix

This document is referenced by:

SAP Notes (25)
1017936   Oracle Database 10g: Upgrade history
839182   Oracle patch installation with OPatch
839187   Oracle 10.2.0: Applying patch set/patches/patch collection
1684424   CPU Patches January 2012 (Oracle Critical Update Program)
1027012   MOPatch - Install Multiple Oracle Patches in One Run
850306   Oracle Critical Patch Update Program
871735   Current patch set for Oracle 10.2.0
1175996   Oracle 10g/11g patches check
1822955   CPU Patches January 2013 (Oracle Critical Update Program)
1237838   Current version of pre-upgrade information script
1619685   CPU Patches July 2011 (Oracle Critical Update Program)
1753600   CPU Patches July 2012 (Oracle Critical Update Program)
1900628   SPU - Oracle Security Patch Update July 2013
830576   Parameter recommendations for Oracle 10g
819829   Oracle Instant Client Installation and Configuration on Unix
1461804   Query failed with ORA-00600 [kdsgrp1]
1590858   CPU Patches April 2011 (Oracle Critical Update Program)
1718792   CPU Patches April 2012 (Oracle Critical Update Program)
1227404   Oracle Database 10g: Oracle Configuration Manager (OCM)
1633801   DBV check code 6401 when using transportable tablespaces
1651427   CPU Patches October 2011 (Oracle Critical Update Program)
1525673   Optimizer merge fix for Oracle 10.2.0.5
1654734   Ext Support contract required for 10.2.0.5 PSU, SBP & Client
1860292   CPU Patches April 2013 (Oracle Critical Update Program)
1790307   CPU Patches October 2012 (Oracle Critical Update Program)