1 2 3 Previous Next 40 Replies Latest reply: May 13, 2013 11:35 PM by user11952526 RSS

    Upgrage from 11i(11.5.10) to R12(12.x.x) single node

    user11952526
      Hi,

      I want to upgrade my 11i single node installation to R12(12.x.x) latest version.
      My set up is, single node 11i(11.5.10) installed on Oracle Enterprise Linux 5.6(32-bit, x86)
      My database version is 9i(9.2.0.5).

      Please let me know the Metalink document(s) and the latest version of R12.
      Please let know the high level path also for better understanding.

      Thanks.
        • 1. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
          Carlo den Otter-Oracle
          Hello,

          Please check Note 1406960.1 : "Planning Your Oracle E-Business Suite (EBS) Upgrade from Release 11i to Release 12"

          Regards, Carlo den Otter.
          • 2. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
            ;) ApPsMasTi ;)
            please upgrade dabatase to 9.2.0.8 then go for 11g

            9.2.0.5--->9.2.0.8---->11.2.X
            Minimum Version of the database that can be directly upgraded to Oracle 11g Release 2

            Source Database Target Database
            9.2.0.8 or higher 11.2.x

            please follow
            Interoperability Notes Oracle EBS 11i with Oracle Database 11gR2 (11.2.0.2) [ID 1367654.1]
            Complete Checklist to Upgrade the Database to 11gR2 using DBUA [ID 870814.1]

            then please see

            Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86 [ID 761564.1]

            Oracle® Applications
            Upgrade Guide
            Release 11i to 12.1.1
            Part No. E14010-01

            then apply these fixes
            Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 [ID 437878.1]

            then upgrade to 12.1.3 see this doc

            Oracle E-Business Suite Release 12.1.3 Readme [ID 1080973.1]
            Oracle E-Business Suite Applications Technology Readme for Release 12.1.3 (R12.ATG_PF.B.delta.3, Patch 8919491) [ID 1066312.1]
            Oracle E-Business Suite Applications DBA Readme, Release 12.1.3 (R12.AD.B.DELTA.3, Patch 9239089) [ID 1077769.1]


            AppsMAsti
            Sharin IS CArin
            • 3. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
              user11952526
              Hi Carlo and Sharin,

              Thanks for the update!

              My application is not multi-org, is it possible to upgrade to R12 ???


              SQL> select RELEASE_NAME,MULTI_ORG_FLAG from FND_PRODUCT_GROUPS;

              RELEASE_NAME MULTI_ORG_FLAG
              -------------------------------------------------- ----------------
              11.5.10 ; N

              Where can I get 9i(9.2.0.8) RDBMS binary for upgrading 9i(9.2.0.5) database ???

              Thanks.
              • 4. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                Srini Chavali-Oracle
                Converting to Multi-org (even if you only plan to use one org) is a requirement for the upgrade to R12

                steps to enable multi-org

                The 9.2.0.8 database patch is available in My Oracle Support (https://support.oracle.com)

                9.2.0.8 Patch Set - Availability and Known Issues [ID 388281.1]

                HTH
                Srini
                • 5. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                  Hussein Sawwan-Oracle
                  My application is not multi-org, is it possible to upgrade to R12 ???
                  http://docs.oracle.com/cd/E18727_01/doc.121/e16342/T527285T527288.htm#5235299
                  http://docs.oracle.com/cd/E18727_01/doc.121/e16342/T527285T527288.htm#5235419
                  SQL> select RELEASE_NAME,MULTI_ORG_FLAG from FND_PRODUCT_GROUPS;

                  RELEASE_NAME MULTI_ORG_FLAG
                  -------------------------------------------------- ----------------
                  11.5.10 ; N

                  Where can I get 9i(9.2.0.8) RDBMS binary for upgrading 9i(9.2.0.5) database ???
                  Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0) [ID 216550.1]
                  Database Preparation Guidelines for an E-Business Suite Release 12.1 Upgrade [ID 761570.1]

                  Thanks,
                  Hussein
                  • 6. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                    user11952526
                    Hi Srini and Hussein,

                    Thanks for the update!
                    I am going through the docs.

                    Is it possible to configure multiorg during installation of 11i (selecting more that one country) ???

                    Thanks.

                    Edited by: user11952526 on Apr 30, 2013 11:24 AM
                    • 7. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                      Srini Chavali-Oracle
                      You configure multi-org after installing 11i - and anytime before you upgrade to R12. This is a functional process/setup, not a technical one.

                      HTH
                      Srini
                      • 8. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                        Hussein Sawwan-Oracle
                        user11952526 wrote:
                        Hi Srini and Hussein,

                        Thanks for the update!
                        I am going through the docs.

                        Is it possible to configure multiorg during installation of 11i (selecting more that one country) ???

                        Thanks.
                        Selecting more than one country during the installation is different than enabling Multi-Org.

                        You can enable multi-org after you are done with 11i installation -- Please see the following docs for details.

                        Planning Your Oracle E-Business Suite (EBS) Upgrade from Release 11i to Release 12 [ID 1406960.1]
                        Use of Multiple Organizations In Oracle Applications Release 11i [ID 210193.1]
                        Improved Convert to Multi-Org Process In Oracle Applications 11i [ID 208267.1]
                        Oracle E-Business Suite Upgrade Guide Release 11i to 12.1.1 [ID 1082375.1]

                        Thanks,
                        Hussein
                        • 9. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                          user11952526
                          Hi Srini and Hussein,

                          Thanks for the update!

                          My EBS version is 11.5.10 (DB version 9.2.0.5), most of the doc mention the application as 11.5.10.2, do I need to move to Application version 11.5.10.2 ??? If need then let me know the Doc no.
                          Then I will upgrade DB to 9.2.0.8 and then 11.2.x
                          Then Application from 11.5.10.2 ---> 12.1.1

                          Thanks.

                          Edited by: user11952526 on Apr 30, 2013 10:33 PM
                          • 10. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                            Hussein Sawwan-Oracle
                            My EBS version is 11.5.10 (DB version 9.2.0.5), most of the doc mention the application as 11.5.10.2, do I need to move to Application version 11.5.10.2 ??? If need then let me know the Doc no.
                            Then I will upgrade DB to 9.2.0.8 and then 11.2.x
                            Then Application from 11.5.10.2 ---> 12.1.1

                            Thanks.

                            Edited by: user11952526 on Apr 30, 2013 10:33 PM
                            You already have the docs referenced above -- Go with "Path A: Standard Upgrade Path".

                            Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0) [ID 216550.1]
                            Database Preparation Guidelines for an E-Business Suite Release 12.1 Upgrade [ID 761570.1]

                            Thanks,
                            Hussein
                            • 11. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                              user11952526
                              Hi Hussein,

                              My ERP application is now multi-org. First pre-req is competed.

                              SQL> select RELEASE_NAME,MULTI_ORG_FLAG from FND_PRODUCT_GROUPS;

                              RELEASE_NAME MULTI_ORG_FLAG
                              -------------------------------------------------- ----------------
                              11.5.10 ; Y

                              I was going through the below dos and bit confused...

                              Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0) [ID 216550.1]
                              Database Preparation Guidelines for an E-Business Suite Release 12.1 Upgrade [ID 761570.1]

                              Doc 216550.1 says to upgrade the database to 9.2.0.8
                              and doc 761570.1(Path A) says to upgrade database to 10.2.0

                              Could you please let me know how to go about it (for e.g. First database upgrade to version x.x.x.x.x and application to 12.1.1)...
                              This is my first upgrade.

                              Thanks.
                              • 12. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                                Hussein Sawwan-Oracle
                                I was going through the below dos and bit confused...

                                Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0) [ID 216550.1]
                                Database Preparation Guidelines for an E-Business Suite Release 12.1 Upgrade [ID 761570.1]

                                Doc 216550.1 says to upgrade the database to 9.2.0.8
                                and doc 761570.1(Path A) says to upgrade database to 10.2.0

                                Could you please let me know how to go about it (for e.g. First database upgrade to version x.x.x.x.x and application to 12.1.1)...
                                This is my first upgrade.
                                Since you can't upgrade directly from 9.2.0.5 to 11gR2, you can either upgrade to 9.2.0.8 then to 11gR2 (11.2.0.3) or upgrade to 10gR2 then to 11gR2 (11.2.0.3) -- Complete Checklist for Manual Upgrades to 11gR2 [ID 837570.1]

                                I would suggest you upgrade to 9.2.0.8 then directly to 11gR2 (11.2.0.3) before you start R12 upgrade.

                                Thanks,
                                Hussein
                                • 13. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                                  953361
                                  Hi,

                                  I would suggest you to upgrade your DB from 9i to 10gR2 and then you can move ahead towards 11gr2 upgradation.

                                  For upgradation of 9i to 10gR2 please refer below doc.
                                  http://docs.oracle.com/cd/B19306_01/server.102/b14238/upgrade.htm#BABJADGA

                                  Thanks
                                  • 14. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                                    Hussein Sawwan-Oracle
                                    950358 wrote:
                                    Hi,

                                    I would suggest you to upgrade your DB from 9i to 10gR2 and then you can move ahead towards 11gr2 upgradation.

                                    For upgradation of 9i to 10gR2 please refer below doc.
                                    http://docs.oracle.com/cd/B19306_01/server.102/b14238/upgrade.htm#BABJADGA

                                    Thanks
                                    I believe it would take less time and effort to upgrade from 9.2.0.x to 9.2.0.8 then to 11gR2 comparing to 9.2.0.x to 10gR2 then to 11gR2

                                    Thanks,
                                    Hussein
                                    1 2 3 Previous Next