7 Replies Latest reply: Oct 17, 2012 2:48 PM by Hussein Sawwan-Oracle RSS

    DB Upgrade approach during R12 Upgrade

    User426388
      We have a 11.5.10.2 instance with 10.2.0.5 database and we are Planning to upgrade the database to 11.2.0.3 during our upgrade R12.1.1, as per the note 761570.1, we have the Patch C and Path D available to us. We have decided to use the path C i.e upgrade the database to 11.2.0.3 during the R12 upgrade itself and no two downtime windows. As per this note 761570.1, in path c If the database upgrade is part of the R12 upgrade, perform all the steps in the Interoperabity Notes except the following steps:

      Verify software versions
      Run adgrants.sql
      Implement and run Autoconfig
      Re-create grants and synonyms
      Restart Applications server processes
      Apply Oracle Human Resources (HRMS) patch 7721754

      so does that mean we don't have to apply any patches mentioned under Verify software versions like Interoperability patch , ATG Patch 7456837 etc.. on 11i ?

      Thanks
      Murali
        • 1. Re: DB Upgrade approach during R12 Upgrade
          Hussein Sawwan-Oracle
          Hi Murali,
          We have a 11.5.10.2 instance with 10.2.0.5 database and we are Planning to upgrade the database to 11.2.0.3 during our upgrade R12.1.1, as per the note 761570.1, we have the Patch C and Path D available to us. We have decided to use the path C i.e upgrade the database to 11.2.0.3 during the R12 upgrade itself and no two downtime windows. As per this note 761570.1, in path c If the database upgrade is part of the R12 upgrade, perform all the steps in the Interoperabity Notes except the following steps:

          Verify software versions
          Run adgrants.sql
          Implement and run Autoconfig
          Re-create grants and synonyms
          Restart Applications server processes
          Apply Oracle Human Resources (HRMS) patch 7721754

          so does that mean we don't have to apply any patches mentioned under Verify software versions like Interoperability patch , ATG Patch 7456837 etc.. on 11i ?
          If you are planning to upgrade the database in the same downtime window of R12 upgrade, then you do not need to apply the patches under "verify software versions" section in the 11i doc. However, you need to consider applying the patches under the same section in (Interoperability Notes EBS R12 with Database 11gR2 [ID 1058763.1]). Those patches should be applied before you release the R12 instance to the users.

          Thanks,
          Hussein
          • 2. Re: DB Upgrade approach during R12 Upgrade
            mybro62-Oracle
            At the point where you stop to upgrade the database, you should have completed all the prep for upgrade steps so you will not be going back into the 11i environment and would not need to apply any 11i patches or perform any other 11i administrative utility. After the RDBMS upgrade you start 12.1.1 upgrade. You also would not need to execute any steps that involve 11i interoperability, just 12.1 interoperability.
            • 3. Re: DB Upgrade approach during R12 Upgrade
              User426388
              Thanks for the confirmation, as per the document, I am planning to apply the R12 interoperability patches once the R12 upgrade is completed.

              I have one more question,

              As per 11i Interoperability note 881505.1, below is the list of DB patches to be applied on top of 11.2.0.3 Oracle Home

              9858539
              12942119
              12960302
              12985184
              13001379
              13004894
              13258936
              13366268

              And As per the note 761570.1, for path C as part of the Step 4, it says to apply the patches

              4247037
              9858539
              12942119
              12960302
              12985184
              13001379
              13004894
              13258936
              13366268

              when I compared the above patches only the patch 4247037 was not applied during 11gR2 upgrade, so at this point I apply only this patch 4247037 and complete post patch instructions for the other patches, which were not completed during the 11gR2 upgrade?

              Thanks
              Murali
              • 4. Re: DB Upgrade approach during R12 Upgrade
                User426388
                Any Updates pls?
                • 5. Re: DB Upgrade approach during R12 Upgrade
                  Hussein Sawwan-Oracle
                  I understand you want to upgrade the database directly before the upgrade to R12 and you are not going to release the 11i instance to the users after the database upgrade. So, in this case you need to apply all those database patches before starting the R12 upgrade.

                  Thanks,
                  Hussein
                  • 6. Re: DB Upgrade approach during R12 Upgrade
                    User426388
                    Thanks alot Hussein for Clarifying that. When do I need to run the post 11gR2 upgrade steps such as below?

                    Run adgrants.sql
                    Grant create procedure privilege on CTXSYS
                    Set CTXSYS parameter
                    Validate Workflow ruleset
                    Implement and run AutoConfig
                    Gather statistics for SYS schema
                    Re-create grants and synonyms
                    Synchronize Workflow views

                    After I am done with R12.1.1 upgrade? or immediately after 11gR2 upgrade? As the database guidelines doc says not to run below 11i 11gR2 interoperability steps

                    Run adgrants.sql
                    Implement and run Autoconfig
                    Re-create grants and synonyms
                    Restart Applications server processes
                    Apply Oracle Human Resources (HRMS) patch 7721754

                    Thanks
                    Murali
                    • 7. Re: DB Upgrade approach during R12 Upgrade
                      Hussein Sawwan-Oracle
                      You need to run them directly after the database upgrade except for the steps which require the application to be up then you can implement it after you start the application.

                      Thanks,
                      Hussein