5 Replies Latest reply: Mar 30, 2013 12:56 PM by Hussein Sawwan-Oracle RSS

    How to Upgrade 11.1.0.7 to 11gR2 in EBS R12.1

    MZ_AppsDBA
      Hi Experts

      I wanna upgrade the 11.1.0.7 to 11gR2 in EBS R12.1 which is on a single node architecture.
      I am not sure about the Patches that i need to apply on Apps & DB tier even after going through couple of metalink note like 1058763.1 &
      blog http://chavalis.blogspot.in/2012/10/upgrading-r12-11-vision-database.html

      Please see the following Sequence of steps for the Upgrade ... which m not sure of .. Please confirm these steps.


      *The current DB version is : 11.1.0.7 & EBS R12 version[VISION DB Instance) = 12.1.1*  
      *Plateform : RHEL 6 64 bit*

      According to metalink ID :  1058763.1.. the Sequence would be by applying the following Patches

      *9062910 - Interoperability Patch For R12.1.1 On 11.2 RDBMS ( The downloading options given for this Patch is Linuxx86 However the Current server is RHEL 64 bit*
      *I am not sure if its compatible for linux 64 bit arch ?  Please confirm)*

      8919489 - Oracle E-Business Suite Techstack 12.1.3 Product Release Update Pack
      9868229 - CST_LAYER_ACTUAL_COST_DTLS_V Becomes Invalid After 11.2.0.2 Upgrade
      10163753 - BIV_B_AGE_H_SUM_MV Fails During Index Creation
      11071569 - ADBLDXML Fails On Windows Server 2008 R2 64 Bit 
      9738085 - Sourcing CMD File On Windows Exits With 1
      9852070 - ADBLDXML And AUTOCONFIG Complete With JAVA.LANG.UNSATISFIEDLINKERROR
      12686610 - R12 And R121 Backport Request For Bug Fix 12336911
      6400501 - Not Able To Compile Forms Library With 11G DB (patch for 10.1.2 forms ORACLE_HOME)

         DO i need to apply the following patches to the 11.1.0.7 database ORACLE_HOME ??

      7695070 - Change In The Timezone File Format

      13417321 - DST 18 : Half Yearly DST Patches, MAY 2012
      14112098 - DST Changes For DSTV18 (TZDATA2012C) - Need OJVM Fix

      7695070 - Change In The Timezone File Format  ( Not sure of .... Please confirm)
        
        And after that
      Download & Install the 11.2.0.3 x86_64 software (files 1of7.zip and 2of7.zip of patch 10404530)  is that fine ?


      Thanks
      MZ                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
        • 1. Re: How to Upgrade 11.1.0.7 to 11gR2 in EBS R12.1
          Srini Chavali-Oracle
          MZ_AppsDBA wrote:
          Hi Experts

          I wanna upgrade the 11.1.0.7 to 11gR2 in EBS R12.1 which is on a single node architecture.
          I am not sure about the Patches that i need to apply on Apps & DB tier even after going through couple of metalink note like 1058763.1 &
          blog http://chavalis.blogspot.in/2012/10/upgrading-r12-11-vision-database.html

          Please see the following Sequence of steps for the Upgrade ... which m not sure of .. Please confirm these steps.


          *The current DB version is : 11.1.0.7 & EBS R12 version[VISION DB Instance) = 12.1.1*  
          *Plateform : RHEL 6 64 bit*

          According to metalink ID :  1058763.1.. the Sequence would be by applying the following Patches

          *9062910 - Interoperability Patch For R12.1.1 On 11.2 RDBMS ( The downloading options given for this Patch is Linuxx86 However the Current server is RHEL 64 bit*
          *I am not sure if its compatible for linux 64 bit arch ?  Please confirm)*
          EBS is a 32-bit application - you need to apply the 32-bit version of the patch.> 8919489 - Oracle E-Business Suite Techstack 12.1.3 Product Release Update Pack> 9868229 - CST_LAYER_ACTUAL_COST_DTLS_V Becomes Invalid After 11.2.0.2 Upgrade> 10163753 - BIV_B_AGE_H_SUM_MV Fails During Index Creation> 11071569 - ADBLDXML Fails On Windows Server 2008 R2 64 Bit  > 9738085 - Sourcing CMD File On Windows Exits With 1> 9852070 - ADBLDXML And AUTOCONFIG Complete With JAVA.LANG.UNSATISFIEDLINKERROR> 12686610 - R12 And R121 Backport Request For Bug Fix 12336911> 6400501 - Not Able To Compile Forms Library With 11G DB (patch for 10.1.2 forms ORACLE_HOME)>Correct -  apply all of the above. >    DO i need to apply the following patches to the 11.1.0.7 database ORACLE_HOME ??> > 7695070 - Change In The Timezone File Format> > 13417321 - DST 18 : Half Yearly DST Patches, MAY 2012> 14112098 - DST Changes For DSTV18 (TZDATA2012C) - Need OJVM Fix >Yes - pl see instructions in MOS Doc 563019.1  - this is identified in "Daylight Saving Changes" section of 1058763.1> 7695070 - Change In The Timezone File Format  ( Not sure of .... Please confirm)>You have to apply the 10.1.0.5 version of this patch to the 10.1.2 and 10.1.3 HOMEs - see MOS Doc 563091.1    >   And after that >  Download & Install the 11.2.0.3 x86_64 software (files 1of7.zip and 2of7.zip of patch 10404530)  is that fine ?> >Correct - you will also need to download and install the Examples CD as noted in my blog post. >  Thanks>  MZHTHSrini                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
          • 2. Re: How to Upgrade 11.1.0.7 to 11gR2 in EBS R12.1
            MZ_AppsDBA
            Thanks for the Enlightining response Srini.

            I forgot to mention this Patch 7303030 which is mentioned in MOS Doc 1058763.1
            However it is not mentioned in your Blog. Please tell do i need to Apply this  Patch 7303030 as well ?

            The Patches for the Apps tier mentioned in MOS Doc 1058763.1 say that
            If you are on E-Business Suite Release 12.1, apply the following Patches

            ** Patch 7303030 - Oracle E-Business Suite 12.1.1*
            ** Patch 9062910 - 11g Release 2 interoperability patch for Release 12.1*
            ** Patch 8919489 - 12.1 TXK Delta 3 patch*
            ** Patch 9868229*
            ** Patch 10163753*
            ** Patch 11071569*

            which is also matching the required Upgrade scenario which i already mentioned i.e
            The current DB version is : 11.1.0.7 & EBS R12 version[VISION DB Instance) = 12.1.1
            Plateform : RHEL 6 64 bit           (Single Node Architecture)..        

            For the DB tier i would be applying the following that you mentioned
            7695070 - Change In The Timezone File Format
            13417321 - DST 18 : Half Yearly DST Patches, MAY 2012
            14112098 DST Changes For DSTV18 (TZDATA2012C) - Need OJVM Fix
            7695070 - Change In The Timezone File Format

                  Please correct if i misunderstood.

                
              Thanking you
               MZ                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
            • 3. Re: How to Upgrade 11.1.0.7 to 11gR2 in EBS R12.1
              Srini Chavali-Oracle
              MZ_AppsDBA wrote:
              Thanks for the Enlightining response Srini.

              I forgot to mention this Patch 7303030 which is mentioned in MOS Doc 1058763.1
              However it is not mentioned in your Blog. Please tell do i need to Apply this  Patch 7303030 as well ?
              My blog post is 6 months old - this document has been updated since then - always follow the instructions in MOS Docs
              The Patches for the Apps tier mentioned in MOS Doc 1058763.1 say that
              If you are on E-Business Suite Release 12.1, apply the following Patches

              ** Patch 7303030 - Oracle E-Business Suite 12.1.1*
              ** Patch 9062910 - 11g Release 2 interoperability patch for Release 12.1*
              ** Patch 8919489 - 12.1 TXK Delta 3 patch*
              ** Patch 9868229*
              ** Patch 10163753*
              ** Patch 11071569*

              which is also matching the required Upgrade scenario which i already mentioned i.e
              The current DB version is : 11.1.0.7 & EBS R12 version[VISION DB Instance) = 12.1.1
              Plateform : RHEL 6 64 bit           (Single Node Architecture)..        

              For the DB tier i would be applying the following that you mentioned
              7695070 - Change In The Timezone File Format
              13417321 - DST 18 : Half Yearly DST Patches, MAY 2012
              14112098 DST Changes For DSTV18 (TZDATA2012C) - Need OJVM Fix
              7695070 - Change In The Timezone File Format

              Please correct if i misunderstood.
              Correct - apply these patches as noted in the MOS Doc. >      >   Thanking you>    MZHTHSrini                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
              • 4. Re: How to Upgrade 11.1.0.7 to 11gR2 in EBS R12.1
                Hussein Sawwan-Oracle
                *The current DB version is : 11.1.0.7 & EBS R12 version[VISION DB Instance) = 12.1.1*  
                *Plateform : RHEL 6 64 bit*

                According to metalink ID :  1058763.1.. the Sequence would be by applying the following Patches

                *9062910 - Interoperability Patch For R12.1.1 On 11.2 RDBMS ( The downloading options given for this Patch is Linuxx86 However the Current server is RHEL 64 bit*
                *I am not sure if its compatible for linux 64 bit arch ?  Please confirm)* There is a generic paltform patch and it is not available for different platforms, so downloading the same patch from MOS website will be enough. > 8919489 - Oracle E-Business Suite Techstack 12.1.3 Product Release Update Pack> 9868229 - CST_LAYER_ACTUAL_COST_DTLS_V Becomes Invalid After 11.2.0.2 Upgrade> 10163753 - BIV_B_AGE_H_SUM_MV Fails During Index Creation> 11071569 - ADBLDXML Fails On Windows Server 2008 R2 64 Bit  > 9738085 - Sourcing CMD File On Windows Exits With 1> 9852070 - ADBLDXML And AUTOCONFIG Complete With JAVA.LANG.UNSATISFIEDLINKERROR> 12686610 - R12 And R121 Backport Request For Bug Fix 12336911> 6400501 - Not Able To Compile Forms Library With 11G DB (patch for 10.1.2 forms ORACLE_HOME)> >    DO i need to apply the following patches to the 11.1.0.7 database ORACLE_HOME ??Visit each patch search page and README file to find out what ORACLE_HOME you have to apply the patch to.For example, you need to apply Patch 6400501 to the iAS 10.1.2 Applications tier Oracle home.> 7695070 - Change In The Timezone File Format> > 13417321 - DST 18 : Half Yearly DST Patches, MAY 2012> 14112098 - DST Changes For DSTV18 (TZDATA2012C) - Need OJVM Fix > > 7695070 - Change In The Timezone File Format  ( Not sure of .... Please confirm)>    >   And after that >  Download & Install the 11.2.0.3 x86_64 software (files 1of7.zip and 2of7.zip of patch 10404530)  is that fine ?Yes.Thanks,Hussein                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
                • 5. Re: How to Upgrade 11.1.0.7 to 11gR2 in EBS R12.1
                  Hussein Sawwan-Oracle
                  I forgot to mention this Patch 7303030 which is mentioned in MOS Doc 1058763.1
                  However it is not mentioned in your Blog. Please tell do i need to Apply this  Patch 7303030 as well ?
                  Always follow Oracle MOS docs.
                  The Patches for the Apps tier mentioned in MOS Doc 1058763.1 say that
                  If you are on E-Business Suite Release 12.1, apply the following Patches

                  ** Patch 7303030 - Oracle E-Business Suite 12.1.1*
                  ** Patch 9062910 - 11g Release 2 interoperability patch for Release 12.1*
                  ** Patch 8919489 - 12.1 TXK Delta 3 patch*
                  ** Patch 9868229*
                  ** Patch 10163753*
                  ** Patch 11071569*

                  which is also matching the required Upgrade scenario which i already mentioned i.e
                  The current DB version is : 11.1.0.7 & EBS R12 version[VISION DB Instance) = 12.1.1
                  Plateform : RHEL 6 64 bit           (Single Node Architecture)..        

                  For the DB tier i would be applying the following that you mentioned
                  7695070 - Change In The Timezone File Format
                  13417321 - DST 18 : Half Yearly DST Patches, MAY 2012
                  14112098 DST Changes For DSTV18 (TZDATA2012C) - Need OJVM Fix
                  7695070 - Change In The Timezone File Format

                  Please correct if i misunderstood. Please always follow the steps/patches in MOS docs for such upgrades and do not follow any instructions in any blog as they might be out-dated.Thanks,Hussein