Oracle E-Business Suite upgrade from 12.1.1 to 12.2.7

This is a step by step upgrade of EBS 12.1.1 to EBS 12.2.7. EBS 12.2.7 was released on September, 8^th 2017 and more details can be found under https://blogs.oracle.com/stevenchan/oracle-e-business-suite-1227-now-available.

There is no direct upgrade path from EBS 12.1.1 to EBS 12.2.7. Release 12.1.1 customers must first upgrade to EBS 12.2 before applying 12.2.7.

The following is a summary of the steps for each category:

1.Prepare the Database

2.Upgrade the database to the minimum version or latest certified version

3.Migrate to a new platform (optional)

4.Apply the latest database patches

5.Lay Down the Oracle E-Business Suite Release 12.2 File System

6.Use Rapid Install to lay down the file system and technology stack

7.Apply the latest application tier technology stack patches

8.Upgrade to Release 12.2.0

9.Apply the latest AD upgrade patch and Oracle E-Business Suite Consolidated Upgrade Patch (CUP)

10.Apply the latest Oracle E-Business Suite pre-install patches

11.Apply the 12.2 merged upgrade driver

12.Run Rapid Install in 'configure' mode

13.Enable Online Patching

14.Apply the latest Online Patching Readiness Report Patch

15.Apply required updates to custom code according to the readiness reports

16.Apply the enablement patch

17.Upgrade to the latest code

18.Apply the latest AD-TXK RUP

19.Apply the latest Oracle E-Business Suite Release 12.2 Release Update Pack (RUP)

Note: You must apply the 12.2.3 or later Release Update Pack (RUP) to your existing Release 12.2 system for production use.

RUPs are released periodically. Each one is cumulative and delivers error corrections and system updates, not only for the most current release update pack, but also for all the RUPs that precede it. Oracle highly recommends that when planning your upgrade you plan to upgrade to the latest RUP available.

You can keep current on the latest release information, as well as new RUP announcements and other updates that may affect your upgrade by reviewing the latest version of Oracle Applications Release Notes Release 12.2.0.

20.Complete post-upgrade steps

21.Apply the latest security patches

22.Apply all recommended patches

23.Apply NLS patches (conditional)

24.Deploy custom code, external integrations and third-party integrations

25.Perform advanced configurations

26.Scale up and/or scale out (add additional managed servers, add application tier nodes, add RAC nodes, and so on)

Note: The upgrade process is performed with one application tier and one database tier. If you are using an Oracle RAC environment, then you should run the Release 12.2 upgrade on a single Oracle RAC node. The reason for upgrading with a single Oracle RAC node is that most of the elapsed time in the upgrade will be taken by jobs running DML (INSERT, UPDATE, DELETE). These jobs use multiple workers and parallel servers, which typically attempt to access the same objects and blocks concurrently. The consequent additional communication between cluster nodes (and associated cluster waits) significantly outweigh any gains from using the additional CPU's to increase throughput. Scaling out is a post-upgrade step.

27.Secure configurations

28.DMZ configuration

29.Disaster recovery setup

30.Reporting environment setup

31.Perform product specific tasks

Some products include tasks that must be performed after the upgrade is complete. The main project steps can be segregated as below:

Phase 1      

• Upgrade the database on the existing EBS 12.1: apps DBA team      
• Execute a functional test: EBS functional team

Phase 2      

• Install all application pre-upgrade patches: apps DBA team      
• Verify the instance: EBS functional team

Phase 3      

• Execute all functional pre-upgrade tasks including customizations: functional team      
• Perform a full system backup: System and apps DBA team   

 Phase 4      

• Apply localization and 12.2 pre-upgrade patches: apps DBA team      
• Upgrade to 12.2.0: apps DBA team      
• Enable online patching: apps DBA team      
• Apply tech stack patches: apps DBA team      
• Upgrade to 12.2.6/12.2.7: apps DBA team      
• Perform all post-upgrade tasks: apps DBA and functional teams      
• Application function test cases: core business users.

So without further delay, let’s jump to the steps.

I had an EBS 12.1.1 running with Database 11.1.0.7. As part of the process, the database has to be first upgraded to minimum version(11.2.0.4) or latest certified version.

 I have upgraded the database first to 12.1.0.2.

You can refer to my blog on how to upgrade http://samappsdba.blogspot.in/2017/01/ebs-db-11107-upgrade-to-12c-12102.html

Now my current environment is

EBS -12.1.1 running with Database-12.1.0.2

Now the upgrade process:-

1. Back up database, Oracle E-Business Suite, and customizations (recommended): Note: Shut down the database with the NORMAL option. You may not be able to restore it from the backup if you use the IMMEDIATE or ABORT option.

2. If there any customizations, take a backup of those and customized help files(HTML)

3. If you have customized forms with Oracle Forms 6i, then upgrade them to Oracle Forms 10i after the upgrade

4. Drop event alert triggers in custom schemas (conditional):

To drop all event alert database triggers in custom schemas, run the alrdtrig.sql script,

located in $ALR_TOP/patch/115/sql. Re-create the triggers after the upgrade is

complete.

5. Review sizes of old and new tablespaces (required): Make sure you allocate sufficient tablespace. For guidelines, see Oracle E-Business Suite Release 12.2: Upgrade Sizing and Best Practices (Doc ID: 1597531.1).

6. Migrate Existing Objects to New Tablespace Model (recommended): Oracle E-Business Suite Release 12 environments contain the new Oracle Applications Tablespace Model (OATM). This model is based on database object type rather than product affiliation, making it simpler to manage and requiring far fewer tablespaces and operating system files. If you previously upgraded your environment from Release 11i to Release 12, then the upgrade process created tablespaces for all new products, configured the database for the new tablespace model, and created new objects. However, it did not automatically migrate your existing objects. If you have not already done so, Oracle strongly recommends that you use the Tablespace Migration Utility to perform this migration now. Note that this utility is not supported for use after you enable Online Patching, so you cannot perform the migration after your environment is upgraded to Release 12.2. If you choose not to migrate to OATM now, then you must continue to manage your tablespaces separately. For more information, see the Oracle E-Business Suite Setup Guide, Release 12.2.

7. Gather SYS, Fixed Object and Dictionary Statistics (required)

login as sysdba

begin  

dbms_stats.gather_schema_stats(      'SYS',      options=>'GATHER STALE',      estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,      method_opt => 'FOR ALL COLUMNS SIZE AUTO',      cascade => TRUE); end; /

2. Fixed Object and Dictionary Statistics

8. Gather schema statistics (required)

9. Install JRE on the database tier (conditional)

10. Reset init.ora parameters (required)

Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)

Additional Database Initialization Parameters For Oracle E-Business Suite Release 12.2

SQL> ALTER SYSTEM SET recyclebin = OFF scope=spfile;

System altered.

SQL>  show parameter service

NAME                                 TYPE        VALUE

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

service_names                        string      PROD

SQL> alter system set service_names=PROD,ebs_patch scope=spfile;

System altered.

SQL>  alter system set local_listener='PROD_LOCAL' scope=spfile;

System altered.

SQL>  alter system set local_listener='PROD_LOCAL' scope=spfile;

System altered.

Set SQLNET.ALLOWED_LOGON_VERSION=8 in the oracle_home/network/admin/sqlnet.ora file.

Restart your database

Human Resource Management (HRMS)

SQL>  SELECT package_name,object_name,argument_name,data_type FROM all_arguments WHERE (package_name,object_name) IN (SELECT call_package,call_procedure FROM hr_api_hook_calls) AND data_type = 'LONG';

PACKAGE_NAME

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

OBJECT_NAME

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

ARGUMENT_NAME

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

DATA_TYPE

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

PSB_HR_POPULATE_DATA_PVT

INSERT_POSITION_TXN_INFO

P_COMMENTS

LONG

Changed long to CLOB

Ref : https://docs.oracle.com/cd/E26401_01/doc.122/e48839/T579510T580873.htm#T609999

Stage Creation (Root user)

R12.2: How to Create the Stage in Preparation for Installation (Doc ID 1596433.1)

This should be done using the latest startCD. At the time of writing this blog, the latest one is startCD51.

Build the stage

[root@ebs1 bin]# sh buildStage.sh

                     Copyright (c) 2002, 2013 Oracle Corporation

                        Redwood Shores, California, USA

                       Oracle E-Business Suite Rapid Install

                                 Version 12.2.0

Press Enter to continue...

                      Build Stage Menu

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

   1.     Create new stage area

   2.     Copy patches to existing stage area

   3.     List files in TechPatches directory

   4.     Exit menu

   Enter your choice [4]: 1

            Rapid Install Platform Menu

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

   1.    Oracle Solaris SPARC (64-bit)

   2.    Linux x86 (64-bit)

   3.    IBM AIX on Power Systems (64-bit)

   4.    HP-UX Itanium

   5.    Exit Menu

   Enter your choice [5]: 2

Running command:

/u01/stage/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java -classpath /u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/jnls.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/ACC.JAR:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/netcfg.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/ojdbc14.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/OraInstaller.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/java oracle.apps.ad.rapidwiz.util.StageBuilder /u01/stage/startCD/Disk1/rapidwiz/bin Linux_x64 Linux_x64

Specify the directory containing the zipped installation media:

/u01/stage

File list:

/u01/stage/startCD/Disk1/rapidwiz/bin/stageData/zipFiles.dat

The set of zip files is complete.

Unzip command is: /u01/stage/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip -o

Press Enter to continue...

Archive:  /u01/stage/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip

 extracting: /u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14272383/p14272383_1036_Generic.zip

 extracting: /u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/20484781/p20484781_111190_Generic.zip

 extracting: /u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14577216/p14577216_101231_Generic.zip

 extracting: /u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/16241466/p16241466_10123_LINUX.zip

                     Build Stage Menu

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

   1.     Create new stage area

   2.     Copy patches to existing stage area

   3.     List files in TechPatches directory

   4.     Exit menu

   Enter your choice [4]: 2

         Rapid Install Platform Menu

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

   1.    Oracle Solaris SPARC (64-bit)

   2.    Linux x86 (64-bit)

   3.    IBM AIX on Power Systems (64-bit)

   4.    HP-UX Itanium

   5.    Exit Menu

   Enter your choice [5]: 2

Directory /u01/stage/TechPatches

Stage Builder will now stage the one-off patches for Linux_x64...

Press Enter to continue...

Press Enter to continue...

Archive:  /u01/stage/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip

Finished copying additional patches.

Press Enter to continue...

                      Build Stage Menu

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

   1.     Create new stage area

   2.     Copy patches to existing stage area

   3.     List files in TechPatches directory

   4.     Exit menu

   Enter your choice [4]:4

Now, start the rapidwiz process.

Now layout EBS 12.2 file system using existing Oracle Home

I will be updating the full steps here once i get time. Meanwhile, please contact me over my email samratsinha05@gmail.com if you want the complete step by step document. 

:

References:-

Oracle E-Business Suite Release 12.2.7 Readme (Doc ID 2230783.1)
https://docs.oracle.com/cd/E26401_01/doc.122/e48839.pdf-upgrade guide
Best Practices for Minimizing Oracle E-Business Suite Release 12.1.3 and 12.2.n Upgrade Downtime (Doc ID 1581549.1)

R12.1 / R12.2 : Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (Doc ID 1302189.1)
Upgrade Advisor: E-Business Suite (EBS) Upgrade from 12.0/12.1 to 12.2.x (Doc ID 1593640.1)
Oracle E-Business Suite Reducing Downtime Upgrading to 12.1/12.2 (Doc ID 1578187.1)