7 Replies Latest reply on May 17, 2017 5:57 PM by Aldrich

    EBS Database Upgrade

    Ibrahim Malek

      Dear friends,

      I need a help

       

      I am a junior apps dba

       

      There is an old custom built EBS system here runs on Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit  on Solaris 10 Spark

      My task is to upgrade the database to 11.2.0.1

       

      I am looking for notes & pieces of advice

       

      regards

        • 1. Re: EBS Database Upgrade
          Shaik

          Hi

           

          Please let me know your current Application and OS version

           

          Regards

          Shaik

          • 2. Re: EBS Database Upgrade
            Ibrahim Malek

            Database Server

            ----------------------------------------

            RDBMS : 10.2.0.3.0

            Oracle Applications : 12.0.6

             

            User : APPS

            Oracle SID : PROD

            System Date : 15-MAY-2017 11:21:42

            Database Server PID : 20397

            Session SID : 883

            SERIAL# : 9818

            AUDSID : 27335801

            Database CPU Usage (in secs) : 0.40

             

             

             

             

            ----------------------------------------

            Forms Server

            ----------------------------------------

            Oracle Forms Version : 10.1.2.2.0

            Application Object Library : 12.0.0

             

            Forms User CPU (secs) : 0.370000

            Forms System CPU (secs) : 0.100000

            Forms Process ID : 26875

             

             

            ----------------------------------------

            Name : FNDCPVCM

            Form Path : /oracle/prod/a01/apps/apps_st/appl/fnd/12.0.0/forms/US/FNDCPVCM.fmx

            Form Version : 12.0.2

            Form Last Modified : $Date: 2006/04/25 12:45  $

             

             

            ----------------------------------------

            Scheme Display Profiles

            ----------------------------------------

            Java Look and Feel : ORACLE

            Java Color Scheme : SWAN

            Color Scheme Indicator : SWAN

            Indicator Colors : Y

             

             

            ----------------------------------------

            Forms

            ----------------------------------------

            APPSTAND : 12.0.6.12000000.3

            FNDCPVCM : 12.0.2

            FNDSCSGN : 12.0.14.12000000.3

             

             

            ----------------------------------------

            Form Menus

            ----------------------------------------

            FNDMENU : 12.0.2

             

             

            ----------------------------------------

            Forms PL/SQL

            ----------------------------------------

            APPCORE : 12.0.21.12000000.13

            CUSTOM : 12.0.0

            FNDCONC : 12.0.5.12000000.5

            FNDSQF : 12.0.3

            GHR : 12.0.22.12000000.26

            GLOBE : 12.0.62.12000000.11

            GMS : 12.0.42.12000000.11

            IGILUTIL2 : 12.0.24.12000000.3

            IGILUTIL : 12.0.1.12000000.3

            OPM : 12.0.7.12000000.2

            PQH_GEN : 12.0.7

            PSA : 12.0.17

            PSAC : 12.0.4.12000000.2

            • 3. Re: EBS Database Upgrade
              Shaik

              Hi

               

              You have to follow the instructions as below note

              Interoperability Notes EBS 12.0 and 12.1 with Database 11gR2 (Doc ID 1058763.1)

               

               

              Why not you go for R12.2.6

              https://blogs.oracle.com/stevenchan/oracle-e-business-suite-1226-now-available

               

               

              Regards

              Shaik

              1 person found this helpful
              • 4. Re: EBS Database Upgrade
                Pravin Takpire

                Instead of going to 11.2.0.3 go to 11.2.0.4 ( check certification though as you are at 12.0.6 application level)

                regards

                Pravin

                • 5. Re: EBS Database Upgrade
                  Ibrahim Malek

                  This is my first upgrade guys

                   

                  wish me luck

                  • 6. Re: EBS Database Upgrade
                    Kanda-Oracle

                    Best wishes! Post upgrade Please review the output of bde_chk_cbo.sql as per note 174605.1  to check whether init.ora are in tact. This helps to preempt many issues (esp perf. issues) .

                    • 7. Re: EBS Database Upgrade
                      Aldrich

                      I recommend that you have the latest cloning patches applied.  You may run into cloning issues if you do not.