Thursday, October 13, 2011

Conflict when applying DB patch 9032412 (pre-req for APPS CPU APR2010) - conflicts with DB patch 9352164 (10.2.0.4.4 PSU incl. CPU APR2010)

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:

Conflict when applying DB patch 9032412 (pre-req for APPS CPU APR2010) - conflicts with DB patch 9352164 (10.2.0.4.4 PSU incl. CPU APR2010)
Symptoms:
DB upgraded from 10.2.0.2 to 10.2.0.4.4 PSU. APP upgraded to RUP7. Now, to apply APP CPU APR2010, was trying to apply patch 9032412 but conflict reported with DB PSU 10.20.0.4.4 (9352164).



Log files:

opatch apply
Invoking OPatch 10.2.0.5.0

Oracle Interim Patch Installer version 10.2.0.5.0
Copyright (c) 2010, Oracle Corporation. All rights reserved.


Oracle Home : db/10.2.0
Central Inventory : db/10.2.0/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 10.2.0.5.0
OUI version : 10.2.0.4.0
OUI location : db/10.2.0/oui
Log file location : db/10.2.0/cfgtoollogs/opatch/opatch2010-09-16_11-12-45AM.log

Patch history file: db/10.2.0/cfgtoollogs/opatch/opatch_history.txt

ApplySession applying interim patch '9032412' to OH 'db/10.2.0'
Interim patch 9032412 conflict with patch(es) [ 9352164 ] in the Oracle Home

Patch [ 9032412 ] conflict with patch(es) [ 9352164 ] in the Oracle Home.

To resolve patch conflicts please contact Oracle Support Services.
If you continue, patch(es) [ 9352164 ] will be rolled back and the new Patch [ 9032412 ] will be installed.


Solution:


applying patch 9032412 would be bad/contraproductive.
Patch 9352164 DATABASE PSU 10.2.0.4.4 (INCLUDES CPUAPR2010) already contains the newer CPUAPR2010 patch (from April 2010).
Patch 8836683 - DB-10.2.0.4-MOLECULE-033-CPUOCT2009 would apply a molecule of the much older CPUOCT2009 (from October 2009) and this is not useful (you do not want to replace a newer CPU with an older CPU).

Customers who run PSU patches should no longer apply PSU patches anyway (this is described in Note.854428.1 Patch Set Updates for Oracle Products: => see step 8.) as the PSU patch contains the suitable CPU patch.
So in your case there is no action required. You should NOT apply any of the patches listed in this SR as you already run the latest Patch 9352164 DATABASE PSU 10.2.0.4.4 (INCLUDES CPUAPR2010)




References:

Patch 9352164 DATABASE PSU 10.2.0.4.4 (INCLUDES CPUAPR2010)
(Note.9352164.8 Bug 9352164 - 10.2.0.4.4 Patch Set Update (PSU))

Bug 9032412 - MERGE REQUEST ON TOP OF 10.2.0.4.0 FOR BUGS 6600051 & 8836683
Bug 6600051 - AQRAC:ENQUEUE AND ALTER QUEUE TABLE RESULT IN HANG IN RAC ENV
=> according to internal Note 1123863.1 this got fixed in 10.2.0.4.3 (and later as PSUs are cumulative)
Bug 8836683 - DB-10.2.0.4-MOLECULE-033-CPUOCT2009 (see Note 881301.1)
Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: