4 Replies Latest reply: Jan 31, 2011 1:18 PM by 835383 RSS

    EBS 11.5.9 to 12.1.1 upgrade

    835383
      Hi,

      We are in process of up-gradation of ebs 11.5.9 to 12.1.1 on solaris 9. our database is 9.2.0.8. Mentioned in the oracle up-gradation document We can directly upgrade EBS 11.5.9 base to 12.1.1, and also mentioned that we need to upgrade the database to 10.2.0.2 atleast, for that we need to apply cu2 on 11.5.9.

      can we upgrade oracle database 9.2.0.8 to 11.1.0.7 directly.
      as We've completed rapidwiz installation phase.

      can anyone provide clear steps of db upgrade from 9.2.0.8 to 11.1.0.7 during the up-gradation of EBS 11.5.9 to 12.1.1

      Thanks,
      Vihang
        • 1. Re: EBS 11.5.9 to 12.1.1 upgrade
          Hussein Sawwan-Oracle
          can we upgrade oracle database 9.2.0.8 to 11.1.0.7 directly.
          as We've completed rapidwiz installation phase.
          Yes.

          Oracle Applications Release 11i with Oracle 11g Release 1 (11.1.0) [ID 452783.1]
          Interoperability Notes E-Business Suite R12 with Oracle Database 11gR1 (11.1.0) [ID 735276.1]
          can anyone provide clear steps of db upgrade from 9.2.0.8 to 11.1.0.7 during the up-gradation of EBS 11.5.9 to 12.1.1
          Since 11gR2 is certified with 11i/R12, I would suggest you upgrade to this release instead of 11gR1.

          11gR2 11.2.0.2 Database Certified with E-Business Suite
          http://blogs.oracle.com/stevenChan/2010/11/db_11gr2_11202_ebs.html

          Thanks,
          Hussein
          • 2. Re: EBS 11.5.9 to 12.1.1 upgrade
            835383
            Hi Hussein,

            Thanks for your prompt response.

            as per the note id Oracle Applications Release 11i with Oracle 11g Release 1 (11.1.0) [ID 452783.1]
            Oracle E-Business Suite 11.5.10 CU2 minimum version for 11g. and we are on 11.5.9 base.

            do i need to follow the ID 735276.1 as per the note id Interoperability Notes E-Business Suite R12 with Oracle Database 11gR1 (11.1.0) only?

            as per the note id 735276.1 my steps would be
            1. Apply patch 6400501
            2. deregister the current database
            3. update the context file
            4. oracle_home 11.1.0.7 already installed from 12.1.1 tech stack.
            5. create sysaux tablespace in existing database.
            6. upgrade the database using dbua.
            7. apply the necessary patches as per the note id.

            If i'm missing any steps from above, kindly suggest it.

            Thanks,
            Vihang
            • 3. Re: EBS 11.5.9 to 12.1.1 upgrade
              Hussein Sawwan-Oracle
              As per the upgrade doc (Database Preparation Guidelines for an E-Business Suite Release 12.1.1 Upgrade [ID 761570.1]), the available upgrade paths are (Path A or Path B), so I believe you have to upgrade to 10gR2 as mentioned in the doc. Then once you are done with the R12 upgrade you can upgrade the R12 to 11gR1/11gR2.

              Thanks,
              Hussein
              • 4. Re: EBS 11.5.9 to 12.1.1 upgrade
                835383
                Thanks a lot for clearing doubts.

                Regards,