Friday, October 27, 2017

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, 8th 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.

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)