SAPTechno

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

Header
Version / Date 39 / 2013-02-14
Priority Correction with high priority
Category Installation information
Primary Component BC-DB-ORA Oracle
Secondary Components BC-DB-ORA-INS Installation SAP System with Oracle

Summary
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:

15. May 2013
14. August 2013
13. November 2013

Please note, CPUApr2013 will be the terminal PSU/CPU for the Oracle release 10.2.0.5. The CPUApr2013 is scheduled within the SAP Bundle Patch (SBP) SAP10205P_1305 in May 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.10 2013-02 SAP10205P_1302
10.2.0.5.9 2012-11 SAP_102059_201211


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)


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_20-10010776.ZIP (Patch: 15848062)
10205_Patch19_MSWIN-x86-64.zip (Patch: 14553358)

Patch collections for platform MS Windows (32-bit)

PATCHBUNDLE10205P_20-10010774.ZIP (Patch: 15848060)
10205_Patch19_WIN32.zip (Patch: 14553356)

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

PATCHBUNDLE10205P_20-10010775.ZIP (Patch: 15848061)
10205_Patch19_WINNT64.zip (Patch: 14553357)

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. 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)


Related Notes
1822955
1790307CPU Patches October 2012 (Oracle Critical Update Program)
1753600CPU Patches July 2012 (Oracle Critical Update Program)
1718792CPU Patches April 2012 (Oracle Critical Update Program)
1684424CPU Patches January 2012 (Oracle Critical Update Program)
1654734Ext Support contract required for 10.2.0.5 PSU, SBP & Client
1651427CPU Patches October 2011 (Oracle Critical Update Program)
1633801DBV check code 6401 when using transportable tablespaces
1619685CPU Patches July 2011 (Oracle Critical Update Program)
1590858CPU Patches April 2011 (Oracle Critical Update Program)
1525673Optimizer merge fix for Oracle 10.2.0.5