This discussion is archived
1 2 3 Previous Next 33 Replies Latest reply: Feb 14, 2013 12:41 PM by Hussein Sawwan-Oracle RSS

R12.1.3 - DB upgrade now CPU/PSU

user6445925 Newbie
Currently Being Moderated
R12.1.3 env running on RedHat Linux 5.7

I've recently patched my database to 11.2.0.3 via ID 1058763.1

Now I'm on to CPU/SPU's or PSU's and am leaning towards PSU's as the seem to be recomended by oracle.
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.

Database 11.2.0.3 SPU Patch 14841409, or Database 11.2.0.3.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 to
3.4.13.6 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.

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.
  • 1. Re: R12.1.3 - DB upgrade now CPU/PSU
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    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.

    Database 11.2.0.3 SPU Patch 14841409, or Database 11.2.0.3.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?
    You need to apply one of the patches in the first row and the patch in the second row.
    Then if I look at my apps tier it takes me to
    3.4.13.6 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?
    If I understand you correctly, it is because those patches were released before (in previous 2012 updates) and no new patches were released since then.
    and then UNIX: CPU Patch 14010540 which is from July 2012.

    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?
    This patch should be applied on top of 10.1.3.5 ORACLE_HOME.
    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.

    Thanks,
    Hussein
  • 2. Re: R12.1.3 - DB upgrade now CPU/PSU
    user6445925 Newbie
    Currently Being Moderated
    Not sure how best to reply to your reply and keep it readable but here goes.
    Question 1) - Why does it also list "CPU Patch 13705478" in the row below?
    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?
    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 3.2.4.1, "Patch Availability for Oracle Database"
    Section 3.2.4.2, "Oracle Database 11.2.0.3"
    Section 3.2.4.3, "Oracle Database 11.2.0.2"
    Section 3.2.4.4, "Oracle Database 11.1.0.7"
    Section 3.2.4.5, "Oracle Database 10.2.0.5"
    Section 3.2.4.6, "Oracle Database 10.2.0.4"
    Section 3.2.4.7, "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".
    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."
    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.

    Edited by: user6445925 on 30-Jan-2013 07:30
  • 3. Re: R12.1.3 - DB upgrade now CPU/PSU
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Fro applying EBS security patches, pl follow the steps in this MOS Doc

    Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (January 2013) [ID 1499376.1]

    I believe it will answer your questions

    HTH
    Srini
  • 4. Re: R12.1.3 - DB upgrade now CPU/PSU
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Question 1) - Why does it also list "CPU Patch 13705478" in the row below?
    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.
    Yes, CPU patches are cummulative but if this patch has no replacement (or recent version), then this explains why it is available by itself.
    Question 2) Then some references to the previous Oracle Database home for some reason?
    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 3.2.4.1, "Patch Availability for Oracle Database"
    Section 3.2.4.2, "Oracle Database 11.2.0.3"
    Section 3.2.4.3, "Oracle Database 11.2.0.2"
    Section 3.2.4.4, "Oracle Database 11.1.0.7"
    Section 3.2.4.5, "Oracle Database 10.2.0.5"
    Section 3.2.4.6, "Oracle Database 10.2.0.4"
    Section 3.2.4.7, "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?
    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.
    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".
    Now do the other patches listed under OC4J Standalone home (2 patches), Oracle SOA Suite and WebLogic Server/WebCenter Suite apply?
    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".
    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."
    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.
    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]

    Thanks,
    Hussein
  • 5. Re: R12.1.3 - DB upgrade now CPU/PSU
    user6445925 Newbie
    Currently Being Moderated
    Thanks for your help Hussien I can appreciate it is hard to help someone who is trying to explain things via a forum only so I'll try and be clear.
    You said "+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.+"

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

    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.


    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?
    *****Apache Version*****
    Server version: Oracle-Application-Server-10g/10.1.3.5.0 Oracle-HTTP-Server
    Server built: Jul 21 2009 11:12:22
    *****Forms Version*****
    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
  • 6. Re: R12.1.3 - DB upgrade now CPU/PSU
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    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).

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

    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?
    *****Apache Version*****
    Server version: Oracle-Application-Server-10g/10.1.3.5.0 Oracle-HTTP-Server
    Server built: Jul 21 2009 11:12:22
    *****Forms Version*****
    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
    Yes.

    For 10.1.3.5 --> Refer to: Document 1455387.1, Patch Set Update and Critical Patch Update July 2012 Availability Document
    For 10.1.2.3 --> Refer to: Document 1354842.1, Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (October 2011)

    Thanks,
    Hussein
  • 7. Re: R12.1.3 - DB upgrade now CPU/PSU
    user6445925 Newbie
    Currently Being Moderated
    ok thanks. Let me review some more and I'll update this post.
  • 8. Re: R12.1.3 - DB upgrade now CPU/PSU
    user6445925 Newbie
    Currently Being Moderated
    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?
    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?
  • 9. Re: R12.1.3 - DB upgrade now CPU/PSU
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    user6445925 wrote:
    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.
    Correct.
    Lastly do I apply all patches listed like OC4J home, SOA and WebCenter etc. whether I think we are using them or not?
    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.
    Apply the OC4J patch(es) but not the SOA or WebCenter ones.
    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>

    Or, you can try any of the commands in (Patch Set Updates for Oracle Products [ID 854428.1]) -- Search for "grep".

    Thanks,
    Hussein
  • 10. Re: R12.1.3 - DB upgrade now CPU/PSU
    user6445925 Newbie
    Currently Being Moderated
    Yah I should have thought of just using 'grep'.

    ok I think I'm almost there...
    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).
    From there I get to 1315202.1 and finally 1323616.1 which is July 2011 CPU. Database stuff doesn't apply to 11.2.0.3 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 listing as I'm also just stating it for my own purposes and for this thread).*

    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.

    Edited by: user6445925 on 01-Feb-2013 09:47
  • 11. Re: R12.1.3 - DB upgrade now CPU/PSU
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    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).
    From there I get to 1315202.1 and finally 1323616.1 which is July 2011 CPU. Database stuff doesn't apply to 11.2.0.3 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?
    Yes. If you do not use SSO or Portal (or any of those products) then you can ignore their patches.
    *(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).*

    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?
    Yes.
    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.

    Thanks,
    Hussein
  • 12. Re: R12.1.3 - DB upgrade now CPU/PSU
    user6445925 Newbie
    Currently Being Moderated
    I'll see how this all goes not that I think I have the process figured out.
    Thanks again Hussein.
  • 13. Re: R12.1.3 - DB upgrade now CPU/PSU
    user6445925 Newbie
    Currently Being Moderated
    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...
  • 14. Re: R12.1.3 - DB upgrade now CPU/PSU
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    user6445925 wrote:
    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...
    Please see (How to apply OC4J patch (13705478) on RDBMS home [ID 1474666.1]).

    Thanks,
    Hussein
1 2 3 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points