If I look at the latest Jan 2013 CPU guide [ID 1502461.1] it would appear my first step would be to tackle the database patching.You need to apply one of the patches in the first row and the patch in the second row.
Database 22.214.171.124 SPU Patch 14841409, or Database 126.96.36.199.5 PSU Patch 14727310.
Based on my earlier decision I'll go with 14727310.
Question 1) - Why does it also list "CPU Patch 13705478" in the row below?
Then if I look at my apps tier it takes me toIf I understand you correctly, it is because those patches were released before (in previous 2012 updates) and no new patches were released since then.
188.8.131.52 Patch Availability for Oracle Fusion Middleware 10.1.3.5.x and
Table 88 Patch Availability for Oracle Fusion Middleware 10.1.3.5.x
Question 2) Then some references to the previous Oracle Database home for some reason?
and then UNIX: CPU Patch 14010540 which is from July 2012.This patch should be applied on top of 10.1.3.5 ORACLE_HOME.
Then I'm a little lost on the next rows as to whether any of them would apply.
"OC4J Standalone home" that doesn't refer to either my Tools or Web Home does it?
As I compose this post I see where I should look at Note 405972.1 and maybe it help me with what I might need to apply to the Tools or Web Home's if anything.Since Oracle EBS R12 apps tier comes with 2 ORACLE_HOMEs, you will need to apply the patches under 10.1.2.x and 10.1.3.x sections.
Question 1) - Why does it also list "CPU Patch 13705478" in the row below?Yes, CPU patches are cummulative but if this patch has no replacement (or recent version), then this explains why it is available by itself.
I guess I thought CPU patches were cummulative so why would it be listing an older CPU patch from Apr 2012. But if it's on the list I'll apply it.
Question 2) Then some references to the previous Oracle Database home for some reason?If there is no recent CPU patches released (i.e. Jan 2013) then you need to refer to the old doc to find the list of patches. All docs are referenced in the latest Jan 2013 critical patches docs.
What I meant was when I get to "Table 88 Patch Availability for Oracle Fusion Middleware 10.1.3.5.x" the first entry refers to:
Product Home Patch
Oracle Database home See Section 3.2.4, "Oracle Database"
Which takes me back to the database section:
3.2.4 Oracle Database
This section contains the following:
Section 184.108.40.206, "Patch Availability for Oracle Database"
Section 220.127.116.11, "Oracle Database 18.104.22.168"
Section 22.214.171.124, "Oracle Database 126.96.36.199"
Section 188.8.131.52, "Oracle Database 184.108.40.206"
Section 220.127.116.11, "Oracle Database 10.2.0.5"
Section 18.104.22.168, "Oracle Database 10.2.0.4"
Section 22.214.171.124, "Oracle Database 10.2.0.3"
So none of the above Oracle_Homes apply to my Fusion Middleware 10.1.2 or 10.1.3 homes. So I guess it doesn't apply to me and move on?
Then on the next row it recommends patch 14010540 and as you say "This patch should be applied on top of 10.1.3.5 ORACLE_HOME".What other two patches you are referring to? I only see Patch 14010540 under "Table 73 Patch Availability for Oracle Fusion Middleware 10.1.3.5.x".
Now do the other patches listed under OC4J Standalone home (2 patches), Oracle SOA Suite and WebLogic Server/WebCenter Suite apply?
Lastly you say "Since Oracle EBS R12 apps tier comes with 2 ORACLE_HOMEs, you will need to apply the patches under 10.1.2.x and 10.1.3.x sections."What 10.1.2.x patchset you are on? Please refer to the doc which is application to your patchset under "Table 2: Information on patches to apply to Oracle Fusion Middleware homes for Release 12 and Oracle Application Server home for Release 11i" in [ID 1499376.1]
Were you referring to the entries in "Table 88 Patch Availability for Oracle Fusion Middleware 10.1.3.5.x" that I'm referring to above? I don't see any referernce to a 10.1.2.x Oracle_Home anywhere in the CPU Guide except for other Products like Oracle Collaboration Suite and Oracle Fusion Middleware Utilities for Oracle Databases.
So I am referring to "Patch Set Update and Critical Patch Update January 2013 Availability Document [ID 1502461.1]" Modified 23-Jan-2013. What do you mean by 'old doc'? My issue is I don't see any applicable database patches for the Fusion Middleware Homes (i.e. it is all 10.2x to 11.2.x).I meant [ID 1499376.1] -- If you refer to "Table 2" you will find the list of docs you need to refer to (which is according to the version you are on).
You said "+What other two patches you are referring to? I only see Patch 14010540 under "Table 73 Patch Availability for Oracle Fusion Middleware 10.1.3.5.x"+."
I'm looking at Table 88 Patch Availability for Oracle Fusion Middleware 10.1.3.5.x" so we must have different revs of the guide but what I was referring to are the patches under Product Home OC4J Standalone home (CPU Patch 14123312, and CPU Patch 13564288). Do they apply? I'm familiar with OC4J and 10gAS deployments just wasn't sure if it applies to EBS or not. Same applies to the SOA Suite and Weblogic/WebCenter patches 12539587 and 12957596.Yes.
You said "+What 10.1.2.x patchset you are on? Please refer to the doc which is application to your patchset under "Table 2: Information on patches to apply to Oracle Fusion Middleware homes for Release 12 and Oracle Application Server home for Release 11i" in [ID 1499376.1+]"
My Web stack is 10.1.3.5 and Tools Stack is 10.1.2.3 correct?
Server version: Oracle-Application-Server-10g/10.1.3.5.0 Oracle-HTTP-Server
Server built: Jul 21 2009 11:12:22
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)
Do I then refer to these two Guides in Table 2?
10.1.3.5 July 2012 Knowledge Document 1455387.1, Patch Set Update and Critical Patch Update July 2012 Availability Document.
10.1.2.3 October 2011 Knowledge Document 1354842.1, Oracle E-Business Suite Releases 11i and 12 Critical Patch Update
So I'll assume that since I have not been actively applying CPU's or patching that is why I get directed back as far as July 2010 CPU Patch 6640838 for the 10.1.2.3 OH and once I get current I will be able to see that I've already applied these pacthes and can stop when I get to that point.
Lastly do I apply all patches listed like OC4J home, SOA and WebCenter etc. whether I think we are using them or not?Apply the OC4J patch(es) but not the SOA or WebCenter ones.
I'm specifically looking at ID 1346104.1 and "+Table 39 Patch Availability for Oracle Fusion Middleware 10.1.3.5.x+" but the same sort of product options come up all the time and I'm not sure what the proper approach is.
Is there any 'opatch lsinventory' option to allow me to search for a patch - or just search the resulting log file?$ opatch lsinventory | grep <patch number>
Start with ID 150246.1 which leads me to 1499376.1, which then leads to 1455387.1 (10.1.3.5 OH) and 1354842.1. (10.1.2.3 OH).Yes. If you do not use SSO or Portal (or any of those products) then you can ignore their patches.
From there I get to 1315202.1 and finally 1323616.1 which is July 2011 CPU. Database stuff doesn't apply to 126.96.36.199 so skip to 3.2 Fusion Middleware.
For Fusion Middleware 10.1.3.5.x I find patches 12434156 and 1243228.
For Fusion Middleware 10.1.2.3 I find a number of patches like 6640838, 11842285 and 12434134, 12434221, 9593176. Plus some Portal Patches that I would apply? Yes/No?
*(Not looking for you to double-check all the patches I'm lisiting as I'm also just stating it for my own purposes and for this thread).*Yes.
Then under the "Section 3: Patches to Apply to Oracle E-Business Suite" get patch 12406916. which is July 2011 CPU. Can I just ignore that since I plan on applying Jan 2013 CPU and they are cummulative?
If all correct, once I get all my patches figured out and listed the proper methodology is to work with one Oracle_Home at a time then and apply all applicable patches with EBS DB Home first, then Web (10.1.3) and then Tools (10.1.2) although order of Web/Tools is likley not important.I agree.
user6445925 wrote:Please see (How to apply OC4J patch (13705478) on RDBMS home [ID 1474666.1]).
Just getting going here and I the first patch I'm going to apply to my Oracle_Home, patch 13705478 extracts to 13734635?
Patch 13705478: OC4J PATCH FOR CVE-2011-5035
Via the readme:
# Bugs Fixed by this patch:
# 13734635:MLR ON TOP OF STANDALONE OC4J 10.1.3.4 FOR CPUJAN2012
I guess it must be the right patch but I don't see anything that says 'this patch has been superseded by 13734635 or anything of that nature.
On a related note my plan is go from oldest to newest when applying the patches. Just looking for confirmation...