11 Replies Latest reply: May 24, 2011 6:24 AM by kkrm333 RSS

    11i to R12 Upgrade

    kkrm333
      Hi,

      We are using 11i apps with 10.2.0.3 db on RHEL 4.4 32 bit server.

      We want to upgrade to 12.1.3.

      Do I need to upgrade my OS version for this ?

      Please provide me the brief procedure for this.

      What is the estimate time to complete this upgrade?

      Thanks,
      Rajamani
        • 1. Re: 11i to R12 Upgrade
          Hussein Sawwan-Oracle
          We are using 11i apps with 10.2.0.3 db on RHEL 4.4 32 bit server.

          We want to upgrade to 12.1.3.

          Do I need to upgrade my OS version for this ?
          Not necessarily as R12 is certified with Linux 4 - Update 4 or higher

          Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 [ID 761566.1]
          Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86 [ID 761564.1]
          Please provide me the brief procedure for this.
          Oracle Applications Upgrade Guide: Release 11i to Release 12.1.1
          http://download.oracle.com/docs/cd/B53825_03/current/acrobat/121upgrade.pdf

          Oracle E-Business Suite Release 12.1.3 Now Available
          http://blogs.oracle.com/stevenChan/2010/08/ebs_1213_available.html
          What is the estimate time to complete this upgrade?
          Depends on your setup and configuration. The best practice is to upgrade an instance which is cloned from production and estimate the time.

          Thanks,
          Hussein
          • 2. Re: 11i to R12 Upgrade
            kkrm333
            Thanks for your information.

            So First I need to upgrade to 12.1.1 and then
            Upgrade to 12.1.3? There is no direct upgrade?


            Thanks,
            Kavitha
            • 3. Re: 11i to R12 Upgrade
              Hussein Sawwan-Oracle
              So First I need to upgrade to 12.1.1 and then
              Upgrade to 12.1.3? There is no direct upgrade?
              Correct -- There is no direct upgrade to 12.1.3, and in order to apply 12.1.3 you must be on 12.1.x

              Thanks,
              Hussein
              • 4. Re: 11i to R12 Upgrade
                kkrm333
                Hi,

                Please correct me if i am wrong.

                My case: 10.2.0.3 db with 11.5.10.2 on Linux 32 bit server.

                These are the steps prepared from upgrade pdf.

                1)Database preparation:
                =============
                Apply below opatches
                1.6319846
                2.6110331

                Apply service patch, 5880762

                2)Prepare for upgrade
                ============

                1.We are already in latest AD patch is 11i.AD.I.6.

                2.Run TUMS utility.

                3.Convert to Multiple Organizations architecture // We are already in multi org.

                SQL> select multi_org_flag from fnd_product_groups; Result: Y

                4. Review sizes of old and new tablespaces as per doc 399362.1.

                5. Run AD preparation scripts.

                Download patch 7197489. It will supply below scripts:
                adgncons.sql
                adcrtbsp.sql
                adgrants.sql

                6.Convert Oracle Alert E-mail Processing to the Workflow Notification Mailer (conditional) Apply Patch 5903765

                We are already using workflow notification mailer.

                7.Perform product specific steps.

                8.Gather schema statistics for CBO by Submitting “Gather Schema Statistics” concurrent request for “ALL” schemas.

                9.Backup the database. Take a cold backup.

                10. Run the rapid wizard in upgrade mode. This will create the required file system, install the required techstack components.


                3) Upgrade Process
                ============

                1.Disable AOL Audit Trail

                2.Shut down application tier listeners and concurrent managers

                3.Update init.ora with upgrade parameters as per doc 396009.1.

                4.Ensure that Maintenance Mode is enabled

                5.Apply AD 12.1.1 upgrade driver, Download and unzip the AD Upgrade Driver for 12.1.1 (patch 7461070).

                6.Run the American English upgrade patch driver, u6678700.drv

                $ adpatch options=nocopyportion,nogenerateportion

                7.Run the NLS upgrade patch driver (conditional)

                8.Apply latest product patches (required)

                9.Synchronize NLS and American English product patches (conditional)

                10.Disable Maintenance Mode (required)

                11.Reset init.ora parameters (required)

                12.Back up Oracle Applications (recommended)

                4)Finishing the upgrade
                ==============

                1.Reset schema passwords

                2.generate appsutil.zip on appmgr side

                $cd <INST_TOP>/admin/out.
                $perl <AD_TOP>/bin/admkappsutil.pl

                3.unzip appsutil.zip in new ORACLE_HOME

                4.run autoconfig in new ORACLE_HOME



                Do I need to run rapidwiz again to configure and start processes?

                Or any other steps i need to folow?


                Thanks,
                Kavitha
                • 5. Re: 11i to R12 Upgrade
                  kkrm333
                  Hi,

                  We are using multi node architecture.

                  1)So I need to run rapidwiz to install R12 File System twice on each node.

                  2) I need to apply all the patches on both nodes?

                  From upgrade pdf,

                  "Run Rapid Install again after the upgrade to configure and start the
                  servers and services. Rapid Install also delivers the unified upgrade driver that you will use later to perform upgrade."

                  Please explain this. I didn't find the steps to run rapidinstall again in the pdf.

                  Thanks,
                  Kavitha
                  • 6. Re: 11i to R12 Upgrade
                    Hussein Sawwan-Oracle
                    Do I need to run rapidwiz again to configure and start processes?
                    Yes.

                    Thanks,
                    Hussein
                    • 7. Re: 11i to R12 Upgrade
                      Hussein Sawwan-Oracle
                      We are using multi node architecture.

                      1)So I need to run rapidwiz to install R12 File System twice on each node.
                      Correct.
                      2) I need to apply all the patches on both nodes?
                      Yes, apply the patch on each node where APPL_TOP is presented (unless you are using Shared FilesSystem or Shared APPL_TOP).
                      From upgrade pdf,

                      "Run Rapid Install again after the upgrade to configure and start the
                      servers and services. Rapid Install also delivers the unified upgrade driver that you will use later to perform upgrade."

                      Please explain this. I didn't find the steps to run rapidinstall again in the pdf.
                      It is explained in the upgrade manual, Page 3-28

                      Thanks,
                      Hussein
                      • 8. Re: 11i to R12 Upgrade
                        kkrm333
                        Thanks a lot for all your answers.
                        But I am not able to get the second rapid install steps as you mentioned in upgrade doc Page 3-28.
                        Could you please provide me the latest upgrade doc for multinode.

                        Please clarify below doubts.

                        1. We have obiee integrated with 11i Apps.
                        Do the upgrade procedures continues this integration? or
                        i need to do the integration procedure after upgrade to 12i?

                        2.We are currently in 10.2.0.3 db version.
                        We want to upgrade to 11.2.0.1. Please provide the docs for upgrading apps database to 11gR2.


                        Thanks,
                        Kavitha
                        • 9. Re: 11i to R12 Upgrade
                          Hussein Sawwan-Oracle
                          1. We have obiee integrated with 11i Apps.
                          Do the upgrade procedures continues this integration? or
                          i need to do the integration procedure after upgrade to 12i?
                          Please see (Integrating Oracle Business Intelligence Applications with Oracle E-Business Suite [ID 555254.1]).
                          2.We are currently in 10.2.0.3 db version.
                          We want to upgrade to 11.2.0.1. Please provide the docs for upgrading apps database to 11gR2.
                          Interoperability Notes Oracle EBS 11i with Oracle Database 11gR2 (11.2.0.1) [ID 1265268.1]
                          Interoperability Notes Oracle EBS 11i with Oracle Database 11gR2 (11.2.0.2) [ID 881505.1]

                          Interoperability Notes Oracle EBS R12 with Oracle Database 11gR2 (11.2.0.1) [ID 1265232.1
                          Interoperability Notes EBS R12 with Database 11gR2 [ID 1058763.1]

                          Thanks,
                          Hussein
                          • 10. Re: 11i to R12 Upgrade
                            kkrm333
                            Hi,

                            We have 2 options

                            1.Upgrade the 10.2.0.3 db to 11g before upgrade of apps to R12.

                            2.Upgrade to 11g after upgrade of apps

                            What would you suggest which one is the best option?

                            When I checked, we are in Developer 6i patchset 16. As per Interoperability Notes Oracle EBS 11i with Oracle Database 11gR2 (11.2.0.1)
                            if we want to upgrade db to 11g before appl upgrade,
                            i need to apply latest certified dev 6i patcheset. But it is useless because after R12 upgrade , developer version will be 10i.

                            Thanks,
                            Kavitha
                            • 11. Re: 11i to R12 Upgrade
                              kkrm333
                              First we want to test 11g upgrade. And later will go for R12.

                              Thanks for your help