12 Replies Latest reply: Jan 10, 2013 10:20 AM by Hussein Sawwan-Oracle RSS

    R12(12.0.4)10gWin32bit Migration to R12(12.1.3)11gR2(11.2.0.3) Linux64bit

    982192
      Dear All,

      We have planned to migrate existing R12(12.0.4) 10g(10.2.0.3) environment running on windows 32bit to R12(12.1.3) with 11gR2(11.2.0.3)DB on linux 64bit.
      I have reviewed metalink migration documents to achieve the same, but still have some confusions. Below is the plan which i have drive after reading all the posts and documents.I would appreciate if anyone having experience of doing similar setup/configuration can guide me in right direction.

      1. Prepare the source Application and DB by Applying pre-migration patches

      2. Install latest oracle db binaries 11.2.0.3 64bit linux on target and apply all the certified patches

      3. Migrate the database using transportable tablespace
      Using Transportable Database to migrate E-Business Suite R12 Using Oracle Database 10gR2 or 11g [ID 734763.1]
      -- Here plz clarify DB 32bit win to DB 64bit linux can be achieved using above note or any other step would be required, any other metalink note?

      4. Once DB is migrated, Install 12.1.1 Tech-stack on target app-node from stage.

      5. Copy Application tier files from win32bit to Linux 64bit.

      Copy the Source System to the Target System
      Copy the application tier file system from the Source Oracle E-Business Suite system to the Target Node
      [APPL_TOP]
      [COMMON_TOP]/clone
      [COMMON_TOP]/java
      [COMMON_TOP]/_pages
      [COMMON_TOP]/webapps
      [COMMON_TOP]/util

      -- Is this is the way to migrate from windows to linux????

      6. Then perform rest of the configuration and integrate with db.

      -- Any additional steps as the source application was 12.0.4 and target would be 12.1.1, This is ok to go from 12.0.4 to 12.1.1?

      7. Once the Application and DB are migrated, Do R12 12.1.3 upgrade.
      Let me know if its fine or not, Also refer some documetns that can help me. Thanks

      Best Regards
        • 1. Re: R12(12.0.4)10gWin32bit Migration to R12(12.1.3)11gR2(11.2.0.3) Linux64bit
          Carlo den Otter-Oracle
          Hello,

          It seems better to do the DB migration at the start of the end of the procedure. Also Note 734763.1 : "Using Transportable Database to migrate E-Business Suite R12 Using Oracle Database 10gR2 or 11g" reads: This document assumes that the source and target application server tiers are the same. Creating new application server tiers for the target environment has to be done either before starting or after completing all the steps in this document.

          Also note the following: The target Oracle home version (including patch set version) must match the source.
          So if you want to upgrade from 10.2.0.3 to 11.2.0.3 this will have to be done separately, either before or after the migration.

          Regards, Carlo.
          • 2. Re: R12(12.0.4)10gWin32bit Migration to R12(12.1.3)11gR2(11.2.0.3) Linux64bit
            982192
            Thanks for your feedback. Its mean we can not migrate using Transportable tablespace from lower version of DB to Higher version of DB?
            In my case 10.2.0.3 to 11.2.0.3?
            • 3. Re: R12(12.0.4)10gWin32bit Migration to R12(12.1.3)11gR2(11.2.0.3) Linux64bit
              Hussein Sawwan-Oracle
              We have planned to migrate existing R12(12.0.4) 10g(10.2.0.3) environment running on windows 32bit to R12(12.1.3) with 11gR2(11.2.0.3)DB on linux 64bit.
              I have reviewed metalink migration documents to achieve the same, but still have some confusions. Below is the plan which i have drive after reading all the posts and documents.I would appreciate if anyone having experience of doing similar setup/configuration can guide me in right direction.

              1. Prepare the source Application and DB by Applying pre-migration patches

              2. Install latest oracle db binaries 11.2.0.3 64bit linux on target and apply all the certified patches

              3. Migrate the database using transportable tablespace
              Using Transportable Database to migrate E-Business Suite R12 Using Oracle Database 10gR2 or 11g [ID 734763.1]
              -- Here plz clarify DB 32bit win to DB 64bit linux can be achieved using above note or any other step would be required, any other metalink note?
              The target Oracle home version (including patch set version) must match the source --> So, use the export/import instead (see the docs referenced below).
              4. Once DB is migrated, Install 12.1.1 Tech-stack on target app-node from stage.

              5. Copy Application tier files from win32bit to Linux 64bit.

              Copy the Source System to the Target System
              Copy the application tier file system from the Source Oracle E-Business Suite system to the Target Node
              [APPL_TOP]
              [COMMON_TOP]/clone
              [COMMON_TOP]/java
              [COMMON_TOP]/_pages
              [COMMON_TOP]/webapps
              [COMMON_TOP]/util

              -- Is this is the way to migrate from windows to linux????
              Yes -- This is also mentioned in the Linux migration doc for the apps tier node referenced below.
              6. Then perform rest of the configuration and integrate with db.

              -- Any additional steps as the source application was 12.0.4 and target would be 12.1.1, This is ok to go from 12.0.4 to 12.1.1?
              Yes you can -- Oracle E-Business Suite Release 12.1.1 Maintenance Pack Installation Instructions [ID 752619.1]

              You can upgrade to 12.1.3 then -- https://blogs.oracle.com/stevenChan/entry/ebs_1213_available
              7. Once the Application and DB are migrated, Do R12 12.1.3 upgrade.
              Let me know if its fine or not, Also refer some documetns that can help me. Thanks
              Migrating E-Business Suite Application Tier Servers to Linux
              https://blogs.oracle.com/stevenChan/entry/migrate_ebs_apptiers_linux

              Application Tier Platform Migration with Oracle E-Business Suite Release 12 [ID 438086.1]

              Export/import process for R12 using 11gR1 or 11gR2 [ID 741818.1]
              Export/Import Process for Oracle E-Business Suite Release 12 using 10gR2 [ID 454616.1]

              Thanks,
              Hussein
              • 4. Re: R12(12.0.4)10gWin32bit Migration to R12(12.1.3)11gR2(11.2.0.3) Linux64bit
                Hussein Sawwan-Oracle
                979189 wrote:
                Thanks for your feedback. Its mean we can not migrate using Transportable tablespace from lower version of DB to Higher version of DB?
                In my case 10.2.0.3 to 11.2.0.3?
                Correct, and you need to use the export/import instead -- See the docs referenced above in my previous reply.

                Thanks,
                Hussein
                • 5. Re: R12(12.0.4)10gWin32bit Migration to R12(12.1.3)11gR2(11.2.0.3) Linux64bit
                  Carlo den Otter-Oracle
                  Export/Import is not to be taken lightly (though it does help to reorganize data).
                  An upgrade and a transport might be considered as an alternative.
                  • 6. Re: R12(12.0.4)10gWin32bit Migration to R12(12.1.3)11gR2(11.2.0.3) Linux64bit
                    Hussein Sawwan-Oracle
                    Carlo den Otter wrote:
                    Export/Import is not to be taken lightly (though it does help to reorganize data).
                    I agree.
                    An upgrade and a transport might be considered as an alternative.
                    In my opinion, it is not less painful than using the upgrade and the transportable TS approach ;)

                    Thanks,
                    Hussein
                    • 7. Re: R12(12.0.4)10gWin32bit Migration to R12(12.1.3)11gR2(11.2.0.3) Linux64bit
                      982192
                      Hi,

                      Thank-you all for sharing experience. From your posts/replies what i understood is:

                      1. Migrate DB 10g(10.2.0.3) 32Bit windows to 10g(10.2.0.3) 64bit Linux using export/import and not transportable tablespace.
                      Moreover can we migrate from 10gr2 windows 32bit to 11gr3 linux 64bit using export/import?

                      2. Once the DB is migrated to same version of DB 10g(10.2.0.3) linux then upgrade to 11gR3(11.2.0.3). Right?

                      3. Now Install on Target App-tier with Tech-stack option only.

                      4. Next copy the source windows 32bit App-Tier TOP's to target Linux 64bit and configure following recommended notes.

                      [APPL_TOP]
                      [COMMON_TOP]/clone
                      [COMMON_TOP]/java
                      [COMMON_TOP]/_pages
                      [COMMON_TOP]/webapps
                      [COMMON_TOP]/util

                      5. Is there any other way then export/import to migrate DB from windows to linux like rman?

                      Best Regards,
                      • 8. Re: R12(12.0.4)10gWin32bit Migration to R12(12.1.3)11gR2(11.2.0.3) Linux64bit
                        Kashif M
                        I will share my exp, we just went go-live on 1st Jan 13.
                        Existing: R12.0.4 – 10g(10.2.0.4) 32bit Windows 2003 to R12.1.1>R12.1.3 - R11gR2 (11.2.0.3) 64bit Redhat Linux 6.2

                        High Level Plan with Reference notes:
                        Upgrade Database 10g Windows to 11g on Linux, 11g DB was installed on Linux
                        Followed import/export reference note
                        Export/import process for R12 using 11gR1 or 11gR2 [ID 741818.1]

                        Migrate Apps R12.0.4 Windows to R12.0.4 on Linux
                        Application Tier Platform Migration with Oracle E-Business Suite Release 12 [ID 438086.1]

                        Upgrade Apps R12.0.4 Linux to R12.1.1 Linux
                        Oracle E-Business Suite Release 12.1.1 Maintenance Pack Installation Instructions [ID 752619.1]

                        Upgrade Apps R12.1.1 Linux to R12.1.3 Linux
                        Oracle E-Business Suite Release 12.1.3 Readme [ID 1080973.1]

                        we have done 3 trials and production upgrade was very sucessful.
                        thanks
                        • 9. Re: R12(12.0.4)10gWin32bit Migration to R12(12.1.3)11gR2(11.2.0.3) Linux64bit
                          Hussein Sawwan-Oracle
                          979189 wrote:
                          Hi,

                          Thank-you all for sharing experience. From your posts/replies what i understood is:

                          1. Migrate DB 10g(10.2.0.3) 32Bit windows to 10g(10.2.0.3) 64bit Linux using export/import and not transportable tablespace.
                          Moreover can we migrate from 10gr2 windows 32bit to 11gr3 linux 64bit using export/import?
                          Yes.
                          2. Once the DB is migrated to same version of DB 10g(10.2.0.3) linux then upgrade to 11gR3(11.2.0.3). Right?
                          No, you can do the export from 10gR2 to 11gR2.
                          3. Now Install on Target App-tier with Tech-stack option only.
                          Yes.
                          4. Next copy the source windows 32bit App-Tier TOP's to target Linux 64bit and configure following recommended notes.

                          [APPL_TOP]
                          [COMMON_TOP]/clone
                          [COMMON_TOP]/java
                          [COMMON_TOP]/_pages
                          [COMMON_TOP]/webapps
                          [COMMON_TOP]/util
                          Yes.
                          5. Is there any other way then export/import to migrate DB from windows to linux like rman?
                          No.

                          Thanks,
                          Hussein
                          • 10. Re: R12(12.0.4)10gWin32bit Migration to R12(12.1.3)11gR2(11.2.0.3) Linux64bit
                            982192
                            Thanks Hussain and Kashif.



                            ***********************************************************************
                            ++__+++++I will share my exp, we just went go-live on 1st Jan 13.+++++__++
                            ++__+++++Existing: R12.0.4 – 10g(10.2.0.4) 32bit Windows 2003 to R12.1.1>R12.1.3 - R11gR2 (11.2.0.3) 64bit Redhat Linux 6.2+++++__++

                            ++__+++++High Level Plan with Reference notes:+++++__++
                            ++__+++++Upgrade Database 10g Windows to 11g on Linux, 11g DB was installed on Linux+++++__++
                            ++__+++++Followed import/export reference note+++++__++
                            ++__+++++Export/import process for R12 using 11gR1 or+ 11gR2 [ID+ 741818.1]+++__++

                            Understood
                            ***********************************************************************

                            Migrate Apps R12.0.4 Windows to R12.0.4 on Linux
                            Application Tier Platform Migration with Oracle E-Business Suite Release 12 [ID 438086.1]

                            Here we can not migrate directly to 12.1.1 and later upgrade to 12.1.3?
                            If we migrate to linux 12.0.4 first, we dont have to apply patches that were applied on source system or in which case we have to apply?

                            ***********************************************************************
                            Upgrade Apps R12.0.4 Linux to R12.1.1 Linux
                            Oracle E-Business Suite Release 12.1.1 Maintenance Pack Installation Instructions [ID 752619.1]
                            Upgrade Apps R12.1.1 Linux to R12.1.3 Linux
                            Oracle E-Business Suite Release 12.1.3 Readme [ID 1080973.1]

                            Understood
                            ***********************************************************************

                            Best Regards,
                            • 11. Re: R12(12.0.4)10gWin32bit Migration to R12(12.1.3)11gR2(11.2.0.3) Linux64bit
                              Carlo den Otter-Oracle
                              The procedure of Note 438086.1 : "Application Tier Platform Migration with Oracle E-Business Suite Release 12" is to migrate, which is separate from upgrading.
                              It is not required to re-apply all apps tier patches in the target env as this is taken care of by requesting, downloading and applying the customer-specific update with AutoPatch as per the note.

                              Regards, Carlo.
                              • 12. Re: R12(12.0.4)10gWin32bit Migration to R12(12.1.3)11gR2(11.2.0.3) Linux64bit
                                Hussein Sawwan-Oracle
                                Here we can not migrate directly to 12.1.1 and later upgrade to 12.1.3?
                                You can ugrade to 12.1.1/12.1.3 after you finish the migration.

                                Oracle E-Business Suite Release 12.1.1 Maintenance Pack Installation Instructions [ID 752619.1]

                                Oracle E-Business Suite Release 12.1.3 Now Available
                                https://blogs.oracle.com/stevenChan/entry/ebs_1213_available
                                If we migrate to linux 12.0.4 first, we dont have to apply patches that were applied on source system or in which case we have to apply?
                                Correct.

                                Thanks,
                                Hussein