This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Jul 18, 2013 11:32 AM by user130038 RSS

Patch problem

user130038 Pro
Currently Being Moderated

Hi

 

Env:

Oracle 10gr2 10.2.0.5

OEL 5.8 32-bit

 

I have an existing server where I get this output for "lsinventory":

-----output --------

$ opatch lsinventory
Invoking OPatch 10.2.0.5.1

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


Oracle Home       : /app/oracle/product/10.2.0/asm
Central Inventory : /app/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.5.1
OUI version       : 10.2.0.5.0
OUI location      : /app/oracle/product/10.2.0/asm/oui
Log file location : /app/oracle/product/10.2.0/asm/cfgtoollogs/opatch/opatch2013-07-03_11-13-49AM.log

Patch history file: /app/oracle/product/10.2.0/asm/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /app/oracle/product/10.2.0/asm/cfgtoollogs/opatch/lsinv/lsinventory2013-07-03_11-13-49AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (2):

Oracle Database 10g                                                  10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 4                            10.2.0.5.0
There are 2 products installed in this Oracle Home.


Interim patches (2) :

Patch  14269955    : applied on Wed Sep 19 11:43:16 EDT 2012
Unique Patch ID:  15334435
   Created on 1 Aug 2012, 02:14:36 hrs PST8PDT
   Bugs fixed:
     14269955
   This patch overlays patches:
     13923855
   This patch needs patches:
     13923855
   as prerequisites

Patch  13923855     : applied on Wed Sep 19 11:35:10 EDT 2012
Unique Patch ID:  15054672
   Created on 21 Jun 2012, 20:30:59 hrs PST8PDT
   Bugs fixed:
     8865718, 11790175, 13489660, 9020537, 9772888, 8650138, 8664189, 10091698
     10092858, 12551710, 7519406, 13349665, 8771916, 7509714, 8822531
     10139235, 10159846, 13257247, 8350262, 11792865, 7119382, 13632738
     11724962, 8966823, 9320130, 11674645, 7026523, 9399589, 9672816, 13503598
     9499302, 9150282, 9448311, 9659614, 13632743, 9949948, 10327179, 8882576
     7612454, 7111619, 9711859, 9714832, 9735237, 9952230, 12780098, 8660422
     11066597, 14105702, 9713537, 14105703, 14105704, 13737773, 13737775
     12925532, 12748240, 9694101, 12862186, 12862187, 10249537, 9586877
     8211733, 6694396, 9548269, 7115910, 7710224, 9337325, 8354642, 7602341
     14076510, 10157402, 12565867, 6402302, 10327190, 10269717, 11693109
     10017048, 8546356, 8394351, 9024850, 8224558, 9770451, 9360157, 8488233
     9109487, 10132870, 9171933, 10173237, 9532911, 10068982, 10306945
     7361418, 11725006, 8666117, 6157713, 9184754, 10214450, 8544696, 9767674
     9323583, 8277300, 9726739, 13343467, 8412426, 10326338, 10165083
     6651220, 12419392, 10208905, 9145204, 13554409, 11076894, 7450366
     11893577, 8970313, 6011045, 10162036, 11814891, 10248542, 9469117
     13359623, 9952270, 13343471, 9842573, 10324526, 12419258, 9322219
     8636407, 10010310, 12828105, 9689310, 9390484, 13736501, 13736502
     9824435, 13736503, 13736504, 13736505, 13736506, 9963497, 9032322
     13736507, 12551700, 12551701, 12551702, 11858315, 12551703, 12551704
     12551705, 10076669, 12551706, 14040433, 12551707, 6076890, 9308296
     12551708, 13916709, 12827745, 12880299, 14038805, 13923855, 8528171
     9072105, 11737047

-----end output --------

 

I have to prepare a new server with exact same binaries. So I downloaded 14269955 and 13923855.

 

README of 14269955 says that patch 13343471 must be installed/applied before applying it.

 

Now here is the problem. If I apply 13343471, then 14269955 and 13923855, the patch installation for 13923855 give me error that:

                 
Interim Patch 13923855 is a superset of the patche(s) [ 13343471 ]

   

If I apply 13923855 and then try to apply 14269955, I get this error:

 

Required patch(es) [13343471] for patch ‘14269955’ are not present in Oracle Home.

  …

OPatch failed with error code 74


UPDATE:

If I try to apply  [13343471], I get following error:

 

Interim patch 13343471 is a subset of the patch(es) [ 13923855 ] in <oracle home>

All the fixes of this patch 13343471 are already present in the Oracle Home, No Need to apply this patch.

So how do I apply "14269955’" patch now? I am stuck!!!

 

Please advise! This is urgent please.

Best regards

 

Message was edited by: user130038

  • 1. Re: Patch problem
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated

    One option would be to clone the ORACLE_HOME - this assumes that the target OS is the same as the source OS

     

    http://docs.oracle.com/cd/B19306_01/install.102/b15660/app_cloning.htm#sthref1128

     

    HTH
    Srini

  • 2. Re: Patch problem
    user130038 Pro
    Currently Being Moderated

    Thank you for your response Srini! Current production servers are being maintained by third part and due to complexity/politics for access to them, Oracle_home clone option is very very difficult (if not impossible).

     

    Anyway,

    Couple of more questions:

     

    1. Do the patches listed in the "opatch lsinventory" are in the order they were applied? Just curious.
    2. Are the patch numbers for 32-bit release and 64-bit release different? What I mean is that, say, for a certain bug fix, Oracle may release patch#123 for 64-bit and same patch#123 for a different fix but for 32-bit release - is this possible? The reason I am asking is that whatever patching I tried yesterday was on 32-bit oracle home (on VM on my laptop) while the "opatch lsinventory" output the DBA provided was from 64-bit PROD env. This may also be a reason I encountered this situation.

    Best regards

  • 3. Re: Patch problem
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated

    The opatch listing is, by default, in reverse chronological order - this is documented :-) - Oracle Software Patching Using OPatch

     

    It is possible (but very unlikely) that patch numbers for 32-bit and 64-bit versions are different. The patch README files contain information on what bugs have been fixed. So why are you testing the patch process on a Vm on your laptop ?

     

    HTH
    Srini

  • 4. Re: Patch problem
    user130038 Pro
    Currently Being Moderated

    Hi Srini

     

    Thank you so much for your response.

     

    I am testing the patches on VM on my laptop because the new server that I'll start building next week for the client will be a VMWare Virtual Machine. There are no test servers available where I may test the patching.

     

    OK Please guide me on this issue - details below:

     

    The existing Prod server has following patches applied on ASM Home [10.2.0.5, RH 64-bit] :

    • 14269955 = Bug Fix
    • 13923855 = 10.2.0.5.8 PSU

     

    DB Home only has one patch applied:

    • 13923855 = 10.2.0.5.8 PSU

     

    The new VM I will build must have (I believe) same patches applied. And here are the steps I took and the problem I face now:

     

    1. I applied 13923855
    2. Then I tried to apply "14269955" but it said that required pre-requisite patch "13343471" is missing (this was also mentioned in the readme)
    3. Then I tried to apply "13343471". This errored out that it cannot be applied because "13923855" is already applied (which supersedes "13343471")
    4. So in order to be able to apply "14269955", I rolled back "13923855" and successfully applied "13343471" and "14269955".
    5. Now I tried to apply "13923855" but it failed because it said "13343471" must be rolledback before install "13923855" - which it could not rollback automatically because "14269955" needs to be rolled back.

     

    Here is what each patch is:

     

    13923855 = 10.2.0.5.8 PSU

    13343471 = 10.2.0.5.6 PSU

    14269955 = Bug Fix that has pre-req of 13343471.


    Q1. Please advise how can I resolve this problem.

    Q2. OR is it ok if I only apply  on both ASM and DB home and forget about "14269955" bug fix patch?


    Best regards


  • 5. Re: Patch problem
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated

    Is the VM setup on your laptop exactly the same (in every aspect) as your new server ? If not, this exercise is meaningless.

     

    Pl open an SR with Support for this issue and ask for their advice

     

    HTH
    Srini

  • 6. Re: Patch problem
    user130038 Pro
    Currently Being Moderated

    Hi Srini

     

    Thank you for your quick response.

     

    I applied 10.2.0.5.9 PSU on ASM Home and I found that the bug "14269955 " is listed in the "lsinventory" output.

     

    So Please advise - if I only apply 10.2.0.5.9 PSU, would it suffice (cover for both 10.2.0.5.6 PSU and the "14269955 " patch)?

     

    The VM is no exactly the same in terms of resources (CPU/Mem/Disk) but platform is the same. So I hope my exercise is not totally useless :-)

     

    Best regards

  • 7. Re: Patch problem
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated

    If you use 10.2.0.5.9 on your target, then this will not match your binaries on source. After moving the databases over, you will need to perform the post-install steps documented in the 10.2.0.5.9 README for each of the databases associated with this ORACLE_HOME

     

    HTH
    Srini

  • 8. Re: Patch problem
    user130038 Pro
    Currently Being Moderated

    OK I got that - thanks for pointing this out.

     

    After I have the binaries at 10.2.0.5.9 level, I will bring the databases over using expdp/impdp (only select schemas need to be brought over to new server). So I will create empty databases after applying 10.2.0.5.9 and them impdp the databases.

     

    I think in this situation, no post-install steps are required.  Right?

     

    Best regards

     

    Message was edited by: user130038

  • 9. Re: Patch problem
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated

    If you plan to create new (empty) databases on the target, then bring over selected schemas from the source using expdp/impdp, then the ORACLE_HOME binaries on the source and target do not have to match at all :-)

     

    Srini

  • 10. Re: Patch problem
    user130038 Pro
    Currently Being Moderated

    Really? That is great!

     

    In that case, I would like to stay as close to the original binaries on existing server as possible. Is this right approach? Or should I apply the most recen PSU (10.2.0.5.11)?

     

    Thank you so much for your time and valuable advice!!

     

    Keep well!

     

    Best regards

     

    Message was edited by: user130038

  • 11. Re: Patch problem
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated

    It depends on what your requirements are, which are unclear. If you plan to use export/import utilities to move the schemas, then as long as the target database version is the same or higher than the source, this is a relatively simple and straightforward process - you can indeed apply the latest PSU on the target if you wish

     

    HTH
    Srini

  • 12. Re: Patch problem
    user130038 Pro
    Currently Being Moderated

    I do not have any clear requirements other than to "move the databases (two) from existing server to new VM server". That is all I have been asked to do (and yeah, keep the oracle version same). The existing server is being managed by 3rd party and i have very limited access to it. So I thought to configure the new VM server with same patch-level of binaries as the existing one. SO I requested the dba of the 3rd party to provide me "opatch lsinventory" output so that I may download the required patches (and I decided to try them as well - perhaps a good thing for me that I found some issue). So that is the background and 'requirements' :-)

     

    There is no one in the client's office who will decide on what to do - I have to decide all this (which PSU to install, how to bring databases over, etc).

     

    So if I go with latest PSU, will that affect/hinder database functionality/performance in anyway? Perhaps too open question to ask I guess.

     

    Best regards

  • 13. Re: Patch problem
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated

    If you apply the latest PSU on the target and use export/import to being needed schemas over, then you should be good. As always, pl test this before attempting in production :-)

     

    Srini

  • 14. Re: Patch problem
    user130038 Pro
    Currently Being Moderated

    Thank you so much Srini - The VM I am going to build will be used for testing (QA/UAT) by the application team(s). I'll keep a snapshot of it before I impdp the databases. Then this snapshot will be used to create a VM for production.

     

    Is there anything on the database side that I should keep my eyes on during the testing period? I am not a very experience dba yet but I hope to get there soon :-) I have got a lot to learn!!

     

    Best regards

1 2 Previous Next

Legend

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