1 2 Previous Next 18 Replies Latest reply on Jun 7, 2018 12:12 PM by Beauty_and_dBest

    Upgrading EBS database 10.2.0.5 to 12.1.0.2

    Beauty_and_dBest

      EBS 12.0.6

      Db 10.2.0.5

      OL5

       

       

      Hi ALL,

       

      We want to upgrade our EBS database from (10g) 10.2.0.5 to (12c) 12.1.0.2.

      Please share me docs or notes or blogs how to perform this "specific version" task.

       

       

      Kind regards,

      jc

        • 1. Re: Upgrading EBS database 10.2.0.5 to 12.1.0.2
          mdtaylor

          Hi jc,

           

          The 12c interop note for R12 has all of the steps required to complete this upgrade.

           

          Interoperability Notes EBS 12.0 or 12.1 with RDBMS 12cR1 (Doc ID 1524398.1)

           

          Regards,

          Michael

          • 2. Re: Upgrading EBS database 10.2.0.5 to 12.1.0.2
            Beauty_and_dBest

            Thanks Michael,

             

            But I can not understand well this kind of merged everything versions rolled into one upgrade docs.

            My brain get distorted while reading all kinds scenarios.

             

            Is there a blog that has done specific upgrade from 10.2.0.5  to 12.1.0.2?

             

            Can you make a blog for this

             

            Kind regards,

            • 3. Re: Upgrading EBS database 10.2.0.5 to 12.1.0.2
              Shaik

              Hi JC

               

               

              i think blogs not available

               

               

              You have to work on Oracle note 1524398.1 to acheive your target

              And for database manual upgrade check the steps from note 1503653.1

               

              I have summarised the steps , just follow and mean while completely go through the document 1524398.1 which is very important

               

              Follow the below steps from below note

              Interoperability Notes EBS 12.0 or 12.1 with RDBMS 12cR1 (Doc ID 1524398.1)

               

              1) On R12.0.6 apply the below patches

              Patch 8796558

              Patch 16289505 - 12c Release 1 interoperability patch for Release 12.0.6

               

               

              2 )Apply patch 6400501 [if you are on Linux]

               

               

              3) Install the 12c Oracle binaries

              4)install the 12c examples CD on top of 12c oracle home

               

               

              5) export the paths of 12c home

              The ORACLE_BASE environment variable must be set accordingly.

               

               

              The ORACLE_HOME environment variable points to the new 12.1.0 Oracle home.

               

               

              The PATH environment variable includes $ORACLE_HOME/bin and the directory where the new perl executable is located (usually $ORACLE_HOME/perl/bin).

               

               

              The LD_LIBRARY_PATH environment variable includes $ORACLE_HOME/lib.

               

               

              The PERL5LIB environment variable points to the directories where the new perl libraries are located ($ORACLE_HOME/perl/lib/[perl version] and $ORACLE_HOME/perl/lib/site_perl/[perl version] for UNIX/Linux, $ORACLE_HOME/perl/lib, $ORACLE_HOME/perl/site/lib for Windows).

               

               

              6) Apply the RDBSM Patches on 12c home

              6880880,19382851 19393542 19591608 19627012 19649152 20204035 22660003 22731026 23645516

              21551086 20123899 22731026

               

               

               

               

              7)Then follow the manual upgrade check list document to upgrade the databse

              Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) (Doc ID 1503653.1)

               

               

              8) Once db upgrade completed perform the post steps of Opataches if any [step 6 patches]

               

               

              9) Run the adgrants.sql . Here perform 21 to 25 points from note 1524398.1

               

               

              10) create the listener on 12c database

               

               

              11) Implement and run AutoConfig

               

               

              12) Apply the patch 14356466

               

               

              13) recreate dblinks if any

               

               

              14)start the application services

               

               

              15)Synchronize Workflow views [step 34 in note 1524398.1]

               

               

              Regards

              Shaik

              • 5. Re: Upgrading EBS database 10.2.0.5 to 12.1.0.2
                Beauty_and_dBest

                Thanks Shaik, Michael and ALL,

                 

                Are the summary steps above for database upgrade only? and retaining the Apps to same version like 12.0.6 ?

                 

                Is the above Blogs for 12.1.3 applicable for 10.2.0.5 database?

                 

                 

                Kind regards,

                • 6. Re: Upgrading EBS database 10.2.0.5 to 12.1.0.2
                  Shaik

                  Hi JC

                   

                  above link for R12.1.1 db 10.2.0.5 to 12c -- provided only for your referecne to check the process

                   

                  Yes above summarised steps for 10.2.0.5 datbase upgrade to 12c with R12.0.6 application

                   

                  Now open the document 1524398.1 and comapre with my summary so you will get idea on upgrade steps

                   

                   

                  Regards

                  Shaik

                  • 7. Re: Upgrading EBS database 10.2.0.5 to 12.1.0.2
                    Beauty_and_dBest

                    Thanks you very much Shaik & Michael,

                     

                    I will read and study first....brb

                    • 8. Re: Upgrading EBS database 10.2.0.5 to 12.1.0.2
                      Beauty_and_dBest

                      Hi Shaik, Michael, and ALL,

                       

                      Are the details below correct?

                      Thanks,

                      jc

                       

                      Detailed Steps in upgrading the PPA Database from 10.2.0.5 to 12.1.0.2

                       

                      1.  On the target server, Install 12c Oracle home software only and Examples

                          Create OracleHome /u01/oraprod/PROD/12.1.0

                          Install 12c examples

                       

                      2.  On the source server, run pre-upgrade tool script preupgrd.sql located under $ORACLE_HOME/rdbms/admin folder. This will create three output files:

                          preupgrade.log

                          preupgrade_fixups.sql

                          postupgrade_fixups.sql

                       

                      3.    Run pre-upgrade script , edit preupgrade log, and resolved errors listed.

                      SQL> @preupgrd.sql

                      Loading Pre-Upgrade Package...

                      Executing Pre-Upgrade Checks...

                       

                      4.    Run the preupgrd_fixups.sql script procedure.

                      $sqlplus sys as sysdba

                      SQL> @preupgrade_fixups.sql (on 10g database)

                       

                      Tasks to be done before upgrade:

                       

                      5.    Increase the Processes & session value

                      sqlplus sys as sysdba

                      SQL>ALTER SYSTEM SET PROCESSES=300 SCOPE=SPFILE      

                      SQL> ALTER SYSTEM SET SESSION=600 SCOPE=SPFILE

                       

                      6.    Remove the Enterprise Manager Database Control repository in Oracle Database 12c.

                       

                      7.      Remove OLAP Catalog(AMD) exists in database.  

                       

                      8.      Empty RECYCLE_BIN.

                       

                      9.      Gather dictionary stats.

                       

                      10.      Verify That Materialized View Refreshes Have Completed Before Upgrading.          

                       

                      Manual tasks to be done:

                        

                      11.    Set job_queue_processes.

                       

                      12.     Remove Hidden/Obsolete/Deprecated Parameters

                       

                      13.    Add the “diagnostic_dest” & “service_names” parameter in init.ora

                       

                      14.    Check completed dictionary tables.

                              v$recover_file,

                              v$backup,

                              dba_2pc_pending,

                              dba_recyclebin

                       

                      15.    Update Timezone

                       

                      Perform Manual Upgrade.

                       

                      16.    Shut down the database.

                       

                      SQL>shutdown normal;

                       

                      17.    Comment the bash_profile.

                       

                      Put # for old entry.

                       

                      18.    Setting environment variable.

                       

                      export ORACLE_HOME=/prodhome/DEV/tech_st/12.1.0

                      export ORACLE_SID=DEV1

                      export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

                      export TNS_ADMIN= /prodhome/TEST/tech_st/12.1.0/network/admin/TEST_ptdtestdb1

                       

                      19.    Copy the Parameter file, Network tns file directories to 12c home.

                       

                      cp -R /prodhome/DEV/tech_st/10.2.0/dbs/initDEV1.ora to /prodhome/DEV/tech_st/12.1.0/db

                      cp –R tnsnames.ora listener.ora /prodhome/DEV/tech_st/12.1.0/network/admin

                       

                      20.    Edit the "/etc/oratab" file, setting the new ORACLE_HOME value.

                       

                      DEV1:/prodhome/DEV/tech_st/10.2.0:N

                      DEV1:/prodhome/DEV/tech_st/12.1.0:Y

                       

                      . oraenv

                       

                      21.    Start the database in upgrade mode which is edited pfile for 12c.

                       

                      sqlplus sys as sysdba

                      SQL> startup upgrade pfile='initTEST.ora';

                      ORACLE instance started.

                      Total System Global Area 1073741824 bytes

                      Fixed Size                 2932632 bytes

                      Variable Size             432013416 bytes

                      Database Buffers       624951296 bytes

                      Redo Buffers             13844480 bytes

                      Database mounted.

                      Database opened.

                       

                      $ORACLE_HOME/perl/bin/perl catctl.pl -n 6 -l /prodhome/DEV/tech_st/12.1.0/diagnostics/ catupgrd.sql

                       

                       

                      22.    Start the database in normal mode.

                       

                      cd $ORACLE_HOME/rdbms/admin/

                      $ sqlplus "/as sysdba"

                      SQL> STARTUP

                      SQL> @utlu121s.sql

                       

                      23.    Run catuppst.sql,

                       

                      SQL> @catuppst.sql

                       

                      24.    Complile Invalid objects

                       

                      SQL> @utlrp.sql

                       

                      25.    Upgrade the Time Zone File Version After Upgrading Oracle Database

                            

                              unzip DBMS_DST_scriptsV1.9.zip   and run timezone update.

                       

                      26.    Set environment variable

                       

                      export ORACLE_HOME=/prodhome/DEV/tech_st/12.1.0

                      export ORACLE_SID=DEV1

                      export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

                      export TNS_ADMIN=/prodhome/DEV/tech_st/12.1.0/network/admin/DEV1_ptdtestdb

                       

                       

                      27.    Apply additional 12.1.0.2 RDBMS patches and Consolidated List of Patches for 12c database ( EBS Technology Codelevel Checker for database (ETCC))

                       

                       

                      28.    Check the opatch version:

                       

                      opatch version

                      OPatch Version: 12.1.0.1.3

                      OPatch succeeded.

                       

                      29.    Apply the latest version of opatch

                       

                      Unzip p6880880_121010_Linux-x86-64.zip

                      $mv Opatch $ORACLE_HOME/

                       

                      30.    Check the opatch Location & version

                       

                      which opatch

                      /prodhome/TEST/tech_st/12.1.0/OPatch/opatch

                       

                      opatch version

                      OPatch Version: 12.1.0.1.10

                       

                      OPatch succeeded.

                       

                      31.    Apply the RDBMS Patches:

                       

                      Sl.No    Patches            Post step

                      1    18966843    Post installation

                      2    19291380   

                      3    19393542   

                      4    19472320   

                      5    19627012   

                      6    19649152   

                      7    19779059   

                      8    19835133   

                      9    19896336   

                      10    20093776   

                      11    20204035    Post installation

                      12    20294666   

                      13    20476776    Post installation

                      14    20798891   

                      15    20830911   

                      16    20887355    Post installation

                      17    21153266   

                      18    21188532   

                      19    21443504   

                      20    22223463   

                      21    21286665   

                      22    21387964   

                      23    21841318   

                      24    21967332   

                      25    22098146   

                      26    20181016  

                       

                       

                       

                      Review/compare:

                      Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)

                       

                       

                      32.    Setting environment variable

                       

                      export ORACLE_HOME=/prodhome/DEV/tech_st/12.1.0

                      export ORACLE_SID=DEV1

                      export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

                      export TNS_ADMIN=/prodhome/DEV/tech_st/12.1.0/network/admin/DEV1_ptdtestdb

                       

                      33.    Startup the 12c database

                       

                      SQL>startup;

                       

                      34.    Create nls/data/9idata directory

                       

                      $ perl $ORACLE_HOME/nls/data/old/cr9idata.pl

                       

                      export ORA_NLS10=/prodhome/TEST/tech_st/12.1.0/nls/data/9idata

                       

                      35.    Enabling Archivelog mode:

                       

                      SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;

                      Output:

                      LOG_MODE

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

                      NOARCHIVELOG

                       

                      sqlplus sys as sysdba

                       

                      SQL>startup mount;

                      SQL>alter database archivelog;

                       

                      SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;

                      Output:

                      LOG_MODE

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

                      ARCHIVELOG

                       

                      ===========================================

                      ***END***

                      • 9. Re: Upgrading EBS database 10.2.0.5 to 12.1.0.2
                        Beauty_and_dBest

                        Hi Shaik, Michael, and ALL,

                         

                        Is it mandatory to upgrade the TIMEZONE version? 

                         

                        Thanks

                        • 10. Re: Upgrading EBS database 10.2.0.5 to 12.1.0.2
                          Shaik

                          Hi JC

                           

                          Hi JC

                           

                           

                          Here you need to consider a point that is you are upgrading the EBS database

                           

                          so first you have to apply the EBS pre-req patches which i mentioned earlier [point 1 &2]

                           

                          then Install the oracle home adn 12c examples as you mentioned and immediately apply the patches which i mentioned in point 6 which i mentioned earlier

                           

                          then follow the steps which you mentioned

                          Point 34 which you mentioned will come earlier ,that is before upgrade . please check document 1524398.1

                           

                          Regards

                          Shaik

                          • 11. Re: Upgrading EBS database 10.2.0.5 to 12.1.0.2
                            Shaik

                            Hi JC

                             

                            Yes you have to upgrade the timezone

                            • 12. Re: Upgrading EBS database 10.2.0.5 to 12.1.0.2
                              Beauty_and_dBest

                              Thanks,

                               

                              Just to confirm, I need to do manual upgrade right? and not use the DBUA?

                              • 13. Re: Upgrading EBS database 10.2.0.5 to 12.1.0.2
                                Shaik

                                Hi JC

                                 

                                You can gow ith any of the way, either manual or DBUA

                                 

                                but above discussion is manual upgrade method so proceed with manual uprade .

                                 

                                 

                                Regards

                                Shaik

                                • 14. Re: Upgrading EBS database 10.2.0.5 to 12.1.0.2
                                  Beauty_and_dBest

                                  Do I need to implement  item #3?

                                   

                                  3. Update application tier context file with new database listener port number (conditional)

                                  The new 12.1.0 Oracle home uses its own database listener for the database instance, replacing the current database listener. Use the Context Editor to update the following variables in the Applications context file on each application tier server node to reflect the 12.1.0 configuration:

                                  Variable NameValue
                                  s_dbhostNew database hostname
                                  s_dbdomainNew database domain name
                                  s_dbportNew database listener port
                                  s_apps_jdbc_connect_descriptorNULL
                                  1 2 Previous Next